Customising web config

There are several settings that administrators can edit in the web.config file to alter the default behaviour of XLCubedWeb.

If these don't exist in the <appSettings> section they can be added.

• StartupReport - Replaces the default startup page with the specified report. The report should be in the form:

   <add key="StartupReport" value="Folder/reportname.xml"/> 

• CustomHelpUrl - Allows you to direct your users to a custom help portal you have created.
• ProgressBarUrl - Sets a custom image for the progress bar.
• ProgressBarCss - Custom css class for the progress image. Built in values are "xl3-progress", the standard position and "xl3-progress-center" which centers the image.
• AllowHtmlColon - Allows outputting or raw html into workbooks. True/False.
• CustomerLogo - Allows you to include a custom logo in the XLCubedWeb header area. The image must be under 32px in height
• ShowReportsBeforeFolders - New in Version 8.1. Set to True to display reports before sub-folders
• UsePathsForSQLRepository - New in Version 8.1. Set to True so that the "Get URL" or reports selected in the SharePoint web part are referred to using the path rather then a Guid when running the SQL Repository
• KeepAlive - New in Version 8.1. Set to True to allow XLCubed to make a web request to the server every minute to keep the session alive, and stop open reports from expiring.
• GoogleMapsJavascriptUri and GoogleMapsMarkerManJavascriptUri - New in Version 8.1. Allows specifying a non-default location for the map javascript. Useful when google.com is not reachable, e.g. in China.
• RespositoryFolderMenu - New in Version 8.1.23. Enable or disable "Delete/Rename" right-click options on a folder
• RespositoryFileMenu - New in Version 8.1.23. Enable or disable "Delete/Rename" right-click options on reports
• UnmapConnectionsOnExport Controls whether connections are unmapped when a user downloads a file, default is True. True/False.
• PowerBiCloudAlwaysPromptUserNameAndPassword Forces a logon prompt even if the published report did not require a password. Useful if Excel connections are integrated with AAD but web requires users to enter their credentials.

New in Version 9.1

• StopImpersonatingDuringDataAccess and StopImpersonatingDuringRelationalDataAccess Stops impersonation during multidimensional or relational data access. Connection will be made as the AppPool user instead.
• AlwaysHideButtons Comma delimited list of toolbar buttons to hide, valid values are:
  • SubmitChanges
  • Print
  • SaveToExcel
  • SaveToPowerPoint
  • SaveToRepository
  • SaveParameters
  • Refresh
  • ToggleSlicerTaskPane

Standard IIS Options

The following are standard IIS/.Net options which may be of interest

• executionTimeout Extends the request timeout in case of long running queries.
  • Amend the httpRuntime element, e.g. <httpRuntime ... executionTimeout=120 />