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.
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
UnmapConnectionsOnExportControls whether connections are unmapped when a user downloads a file, default is True. True/False.
PowerBiCloudAlwaysPromptUserNameAndPasswordForces 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
StopImpersonatingDuringRelationalDataAccessStops impersonation during multidimensional or relational data access. Connection will be made as the AppPool user instead.