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.

    Setting name Description Valid values
    AllowGuest Not currently used.
    AllowHtmlColon Allows outputting or raw html into workbooks. True/False
    AlwaysHideButtons Comma delimited list of toolbar buttons to hide. SubmitChanges, Print, SaveToExcel, SaveToPowerPoint, SaveToRepository, SaveParameters, Refresh, ToggleSlicerTaskPane
    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. True/False
    ApplicationUrl The URL that the users use to access the application. Can usually be left blank. e.g. https://myapplication.example.org/xlcubedweb
    AutoReloadOnSessionTimeout Allows the report to be automatically reloaded if a user allows their session to time out. True/False
    ClearLevelsMovedToFilters Where an entire level is selected on an axis (potentially a large number of members), and is dragged onto the slicer, the selection is changed to the default member (Typically 'All'). This is to prevent users accidentally creating a very slow running query by individually aggregating all the members dragged to the slicer True/False
    CommentReverseChronology Change the order comments are displayed. True/False
    CustomHelpUrl Allows you to direct your users to a custom help portal you have created. e.g. https://otherserver.example.org/xlcubedhelp
    CustomerLogo Allows you to include a custom logo in the XLCubedWeb header area. The image must be under 32px in height. e.g. https://otherserver.example.org/companylogo.png
    DefaultChartSeries The default number of series to chart on an ad-hoc report. Integer
    DefaultCulture The backup culture where it cannot be retrieved from the browser. e.g. en-US
    DefaultFormatString The default format string to use before the user has set one. e.g. 0.00
    DirectoryServicesSizeLimit Not currently used.
    DisplaySystemMemProps Show system member properties available for selection. True/False
    DocumentDomain Used when embedding XLCubed within an iframe on a different server. e.g. otherservice.example.org
    DrillthroughAbsoluteMaxRows maximum permitted rows on a drillthrough Integer
    DrillthroughDefaultMaxRows default maximum rows on a drillthrough Integer
    GoogleMapsJavascriptUri Allows specifying a non-default location for the map javascript. Useful when google.com is not reachable, e.g. in China. (from Version 8.1) e.g. maps.google.com/maps/api/js?sensor=false&v=3.9
    GoogleMapsMarkerManJavascriptUri Allows specifying a non-default location for the map javascript. Useful when google.com is not reachable, e.g. in China. (from Version 8.1) e.g. google-maps-utility-library-v3.googlecode.com/svn/tags/markermanager/1.0/src/markermanager_packed.js
    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. True/False
    LogErrors Write errors to the Error.log file. True/False
    LogPerformance For debug only. True/False
    MapUseHttps Specifies that XLCubed should use HTTPS links to map scripts. Can usually be left blank. True/False
    MaxChartSeries The maximum number of series to chart on an ad-hoc report. Integer
    PdfConverterPassword Not currently used.
    PdfConverterUserName Not currently used.
    PdfHostWebBrowser Not currently used.
    PdfRenderer Not currently used.
    PdfSetCookie Not currently used.
    PdfUseAppPoolUserForPdfConversion True to use the IIS configured application pool user for creating the PDF during the PDF print; false uses the impersonated user. Must be true for 64-bit application pools. True/False
    PdfUseAppPoolUserForXpsPrint True to use the IIS configured application pool user for creating the XPS during the PDF print; false uses the impersonated user. Must be true for 64-bit application pools. True/False
    PdfXpsDriver The XPS driver for creating the XPS during the PDF print. Usually Microsoft XPS Document Writer
    PowerBiCloudAlwaysPromptUserNameAndPassword 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. True/False
    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). e.g. xl3-progress-center
    ProgressBarUrl Sets a custom image for the progress bar. e.g. https://otherserver.example.org/progress.gif
    QueryActiveDirectory Used to display the user name on homepage. True/False
    RepositioryRootUNC No longer supported - listed for compatibility reasons. To create a shared repository, use MKLink to replace the folder with a Symbolic Link to a network share.
    RespositoryFileMenu New in Version 8.1.23. Enable or disable "Delete/Rename" right-click options on a file. True/False
    RespositoryFolderMenu New in Version 8.1.23. Enable or disable "Delete/Rename" right-click options on a folder. True/False
    SQLRepositoryConnectionString The connection string used to connect to the SQL Repository. e.g. Data Source=sql.example.org;Initial Catalog=XLCubedWeb;Integrated Security=True
    SharePointUseRepository Whether to use SharePoint for the repository. True/False
    SharePointServerUrl The SharePoint server to use for the repository. e.g. http://sharepoint
    ShowErrorMessages Show detailed error messages or just a reference to the log file. True/False
    ShowReportsBeforeFolders New in Version 8.1. Set to True to display reports before sub-folders. True/False
    StartupReport Replaces the default startup page with the specified report. e.g. Reports/StartupReport.xml
    StopImpersonatingDuringDataAccess Stops impersonation during multidimensional data access. Connection will be made as the AppPool user instead. True/False
    StopImpersonatingDuringRelationalDataAccess  Stops impersonation during relational data access. Connection will be made as the AppPool user instead. True/False
    TwoPassQueryMaxTupleCount The maximum number of tuples to submit at once for formula queries. Integer
    UnmapConnectionsOnExport Controls whether connections are unmapped when a user downloads a file, default is True. True/False
    UseAppPoolUserForSQLRepository Whether to use the application pool user to connect to the SQL Repository. True/False
    UseAppPoolUserForSharepointDownload Whether to use the application pool user to download from SharePoint. True/False
    UsePathsForSQLRepository New in Version 8.1. Set to True so that the "Get URL" of reports selected in the SharePoint web part are referred to using the path rather than a Guid when running the SQL Repository. True/False
    V5FormatFileLocation Not currently used.
    WithMembersOnWhere Formula engine option to control MDX generation, puts aggregates in the where clause. Mimics the same option from Excel. True/False
    WritebackTimeout Writeback timeout in milliseconds Integer
    XL3LastCubeUpdateVolatile Whether the XL3LastCubeUpdate formula should be volatile. True/False
    X_UA_Compatible_IE Sets the X-UA-Compatible meta tag, which forces compatibility rendering in Internet Explorer. e.g. Edge

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

    PDF Printing Configuration

    To configure the web edition to use the impersonated user instead of the application pool user, see Version 7.1 instructions.

    1. Set PdfUseAppPoolUserForXpsPrint and PdfUseAppPoolUserForPdfConversion to true
    2. Ensure the application pool user has read and write access to the "Temp" folder, \inetpub\wwwroot\xlcubedweb\temp

    Data Configuration Settings

    Updating Data Configuration Settings may be done to affect connection behaviour by advanced users, although it is not recommended to do this without advice from XLCubed support.