Customising web config

Revision as of 16:36, 15 November 2017 by Colin (talk | contribs)

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 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 and AnalysisServicesAzureAlwaysPromptUserNameAndPassword Forces the logon prompt On/Off 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.
  • CommentReverseChronology - Change to order comments are displayed.

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 />