Jump to: navigation, search
  • Main page
  • Recent changes
  • Random page
  • 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.

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