Application Settings

The core set of configuration for CALUMO can be managed from the CALUMO Server Configuration page in the Administration section of the CALUMO Website.

To change a settings, enter the new value in the relevant field and the press TAB or click out of the field and the page will detect that you have made a change, flag the item that was changed and offer to Save or Cancel the change as shown in the screen shot below.

You can make multiple changes at once.

The following table details the settings that can be configured in CALUMO along with their defaults and whether they are editable in the Server Configuration UI or only via modification directly in the CALUMO database.

The password to use of the account with administration access to the OLAP server being connected to via HTTP(s)

Configuration Value Default Edit In Database Only Description
Active Directory Connection (LDAP) The connection string used for to connect to your Active Directory via LDAP
Active Directory (LDAP) Password The password for the Active Directory account used to perform lookups as users login
Active Directory (LDAP) Username The username of the Active Directory account used to perform lookups as users login
Allowed Upload File Types 3g2,3gp,avi,csv,doc,docx,
gif,jpeg,jpg,m4a,m4v,mov,
mp3,mp4,mpg,odt,ogg,ogv,
pdf,png,pps,ppsx,ppt,pptx,
tab,tif,tiff,txt,wav,wmv,
xls,xlsx,zip
The list of allowed file extensions that can be uploaded into CALUMO using the Upload File functionality in the Library
Analytics Process Interval 60 Yes The duration in seconds between processing/sending analytic events.
Cache Default Expiry (mins) 5 The default time in minutes that a cached item without an explicit expiration time will live in the cache for.
Cache Max Size (Mb) 500 The maximum size the cache is allowed to get to in megabytes before it wll start expiring the oldest items from the cache to regain space.
Cache Type InMemory The type of cache to use. Valid cache types are ‘InMemory’ or ‘Redis’. You can not use the cache type InMemory if you are load balancing your CALUMO Website or you are running more than one IIS worker process.
Cache Type Connection String The connection string to use to connect to the cache type selected. NOTE: InMemory will ignore this value as it is not required.
Client Time out 60 The time out, in seconds, that the CALUMO Office client will wait for a response from the server.
Connection String The connection string to use to connect to the CALUMO database
Create Thumbnails false Whether or not to create thumbnails of assets for use on the recent view.
Culture en-AU The culture that CALUMO requests will run under by default. This can be overridden on a per user basis.
Default Domain The default domain name that user account will sign in using when CALUMO is running in Forms Authentication mode.
Dimension Maintenance Enabled false Legacy - this is no longer required as of CALUMO 12.1.4+. Whether or not the dimension maintenance button is enabled in the CALUMO Excel client
Dimension Maintenance Report Name Legacy - this is no longer required as of CALUMO 12.1.4+. The CALUMO Report name that is providing dimension maintenance functionality.
Drill Through Rows 250 The maximum number of rows returned after a drill through operation
Environment production This settings determines the mode that the CALUMO Website runs in. In production mode all optimizations are turned on and the Website is geared for performance. In ‘development’ mode, all optimizations are turned off and the Website is geared for debugging and detailed issue resolution. Note: This is purely a debug setting and should not be set to true unless directed by CALUMO Support.
Forms Auth Disable Remember Me false When CALUMO is running in Forms Authentication mode, this setting determines whether users are allowed to use the “Remember Me” options for saving their credentials
Keep Logs For 30 The number of days to keep log entries in the database before purging
Keep Temp Images For 1 The number of hours to keep temporary images generated by CALUMO
Max Member Count 1000 The maximum number of members returned in a single query.
Office Client Installation Location ClientInstall/CALUMO OfficeClient.exe The location of the office client installation file on the CALUMO Server. Set to no value to hide the Download Client link for users. Note: This setting can be changed if you want to relocate this file to a more central location for your users.
OLAP Base Http Connection Authentication Password The password of the account with administration access to the OLAP server being connected to via HTTP(s)
OLAP Base Http Connection Authentication User ID The username of the account with administration access to the OLAP server being connected to via HTTP(s)
OLAP Base Http Connection String Provider=MSOLAP.3;MDX Compatibility=2; The base connection string to use when connecting to an OLAP server via HTTP(s)
OLAP Base Connection String Integrated Security=SSPI;Provider=MSOLAP.3;SSPI=NTLM;MDX Compatibility=2;Optimize Response=2; The default connection string for connecting to SQL Server Analysis Services. Read about the Olap Connection String Defaults.
OLAP Cache Build Wait 2 The number of minutes the process will wait to complete caching before erroring out
OLAP Cache Expiry 1440 The number of minutes between OLAP Cache refresh actions
OLAP Servers The list of Analysis Services servers, separated by a pipe “
Profile nHibernate false Yes Turn on profiling for nHibernate. (Will severely reduce system performance). Note: This is purely a debug setting and should not be set to true unless directed by CALUMO Support.
Protocol http Yes The default CALUMO web site protocol. Note: This setting will need to be changed if you are using HTTPS
Published Reports Cache Time out 60 (Minutes) The amount of time in minutes that a single calculation of a CALUMO Published Report will stay in the Report Cache before being purged.
Published Reports Cached Mode true Whether or not the Published Report calculation engine will cache and re-use the cached calculation each time.
Report Image Capture Load Wait 30 (seconds) The number of seconds the image capture process will wait for a report to return from the server before moving on to the next stage. The process will not wait for the entire length if the report returns from the server before the time has expired.
Report Image Capture Post Load Wait 5 (seconds) The number of seconds the image capture process will wait once a report has returned from the server before moving on to the next stage to allow assets such as images to be downloaded from the server. This entire duration is waited for and it is recommended this not be more than 5 seconds.
Report Image Capture Snapshot Wait 45 (seconds) The maximum number of seconds the image capture process will wait for the report to finish rendering before taking the image to allow for dynamic items such as ReportParts or Charts to calculate. The process will not wait for the entire length if there are no dynamic items on the report or they have all registered as completed.
Site Name CompanyX Yes The current virtual directory for this instance of CALUMO
Slice Changes to MDX At (cells) 2000 The number of cells in a view at which the slice will automatically change to be a CGETMDX based slice for increased performance
Slice Cells Max (cells) 20000 The maximum number of cells that can be created from a slice
SMTP Email From Address The email address to make emails sent from CALUMO “FROM”
SMTP Server Password The password for the SMTP server connection.
SMTP Server Port The port for the SMTP server connection.
SMTP Server The address of the SMTP server.
SMTP Connect with TLS Wether or not to use a TLS connection when connecting to the SMTP server.
SQL Base Connection String Yes The base SQL Server connection string that CALUMO will use.
Stored Procedure Command Timeout 60 Sets the command timeout for store procedures called by CALUMO
Stored Procedure Max (rows) 50000 The maximum number of rows to be returned from a stored procedure
Stored Procedure No Cross Join Return Value 0 The value to return to stored procedures if the Cross Join All flag is off and the required conditions are met for not performing a cross join.
Stored Procedure Writeback Timeout (sec) 30 (Seconds) The default timeout for a stored procedure to finish executing
Super User Admin Password Yes See server.config.json file in your CALUMO Web Server installation directory.The main admin password for CALUMO.
Super User Admin Name Yes See server.config.json file in your CALUMO Web Server installation directory.The admin user name
Support Email support@calumo.com The support email that will be used inside the application when people click “Send to CALUMO”. This can be replaced by any email, such as your companies internal IT Help Desk for first level troubleshooting.
Suppress Client Update Notifications false Whether or not the CALUMO Office Client will prompt its users that it is out of date and needs to be updated. You would want to set this to tru if you are rolling the client out via a tool like SCCM or if you deploy the client via Citrix.
Tabular Deployment Servers A list of Analysis Services Tabular servers that you want to make available as deployment sources for Power Pivot models from the CALUMO Excel Client
Temp Image Cleanup (hours) 30 (Hours) The number of hours an image generated from a given calculation of a Published Report will be cached for on the server.
View Cache Cells Max 1000 The maximum number of cells in the view query result that we will cache before we move to a live query for subsequent pages
Views Cache Results true Whether or not to cache subsequent pages of view result sets on the server
View Columns 100 The max number of columns that will be displayed in a CALUMO View
View Rows 500 The max number of rows that will be displayed in a CALUMO View