Skip to content
CALUMO Documentation
Release Highlights - 2024.1
Initializing search
Home
Reference
Administration
Release Notes
CALUMO Documentation
Home
Home
Introduction
CALUMO Home
CALUMO Home
Introduction
Recent
My
Library
Apps
Data
Data
Introduction
Manage CALUMO Perspectives
Maintain Dimensions
Rebuild Olap Cache
Using Drawers
Search
Downloading the CALUMO Client
Logging In/Out
CALUMO Document Types
Marking Favorites
Using CALUMO Tabs
Checking CALUMO Version
Data Explorer
Data Explorer
Introduction
The Basics
Working with Data Views
Working with Data Views
Introduction
Advanced Data View Options
Cancel Long Running Calculations
Rules for Measures
Tuplesets
Data Explorer Anatomy
Data Explorer Anatomy
Introduction
Cubes, Dimensions and Hierarchies
Hierarchy Types
Rows, Columns and Slicers
Member Explorer
Member Explorer
Introduction
Toolbar
Member List
Using the Cart
Button Bar
Working with Subsets
Filtering Members
Calculated Members
MDX Mode
Published Reports
Published Reports
Introduction
Published Reports Overview
Accessing and Viewing Published Reports
The Published Report Window
Working with Published Reports
Creating a Published Report
Rich Text Notes
Cell Highlighting
Spreading
Spreading
Introduction
Spreading Precision
Holding Cells Whilst Spreading
Using Keyboard Shortcuts to Spread
Reporting Against Relational Data
Push Analytics
Push Analytics
Introduction
Linked Analytics
Linked Analytics
Introduction
Visual Data Discovery
Visual Data Discovery
Introduction
Getting started
Getting started
Introduction
Creating your First Chart
Exploring Data with a ViewChart
Customizing your Chart
Multi Axes and Combination ViewCharts
Dimension Stacking
Auto Scaling
Label Trimming
Chart Types
Chart Types
Introduction
All Data
All Data
Introduction
Area
Bar
Donut
Line
Select Data
Select Data
Introduction
Bubble
Funnel
Pie
Waterfall
Doing More
Doing More
Chart-Related Excel Functions
Formatting Visualisations
Formatting Visualisations
Introduction
Date Formatting
Number Formating
CALUMO Apps
CALUMO Apps
Introduction
About Apps
Designing Apps
Designing Apps
Introduction
Adding Documents
Customizing Appearance (Menu Styles)
Info Pages
Using Apps (Desktop)
Using Apps (Mobile)
Filtering Data with Query Strings
App Slicers
App Slicers
Introduction
App Slicer Editor
App Slicer Priority
CALUMO Excel Client
CALUMO Excel Client
Introduction
The Ribbon
Basic Reporting
Basic Reporting
Publishing Reports - Public and Private
Creating a Report from a View
Hiding Rows and Columns
Applying Formatting Features to Reports
Excel Formula Batch Processing
Advanced Reporting
Advanced Reporting
Introduction
Reflex Reporting
Suppressing Drill-Down in Published Reports
Guided Analytics
Creating an Input Template
Adding Help to Published Reports
Extending Your Reports With Custom JavaScript and Style Sheets
Extending Your Reports With Custom JavaScript and Style Sheets
Introduction
Code Snippets for Report Manipulation
Code Snippets for Report Manipulation
Introduction
Data Handling Snippets
Data Handling Snippets
Get a value from the query string
Refresh a report every 15 seconds (JavaScript)
Look and Feel Snippets
Look and Feel Snippets
Force a Page Break in PDF (JavaScript)
Generate a QR Code for Report URL (JavaScript)
Make a Report Fill Screen Width (Style Sheet)
Make Text on a Report Selectable (Style Sheet)
Repeat a Background Inside a Report (Style Sheet)
Scroll a Report to a Given Location
Document model and events
Report Actions
Report Actions
Introduction
Procedure
Parameters
Action
Result Style
Creating Drillable Reports
CALUMO Formulator
Clear CALUMO Formula
Excel Charts and CALUMO SPARKS
Excel Charts and CALUMO SPARKS
Introduction
Excel Charts in Published Reports
Excel Charts and Images with Gradients and Image Transparency
CALUMO SPARKS
CALUMO SPARKS
Introduction to CALUMO SPARKS
Types of SPARK Charts
SPARK Chart Overview
The SPARKS Launch Wizard
Creating a CALUMO SPARK
Bonus: CALUMO SPARKS Example File
CALUMO SPARKS Advanced Settings
Calculation dependencies in CALUMO
CALUMO Skylights
CALUMO Skylights
Introduction
About Skylights
Skylights Ribbon
Adding Skylight Reports
Adding Skylight Fields
Editing Skylights
Skylight Designer
Copying and Pasting Skylights
Sharing Skylights
Restricting Information with Masking
Printing Skylight Documents
Presenting PowerPoint Slideshows
Skylight Options
Refreshing Skylights
Usage Notes
Reference
Reference
CALUMO Excel Functions
CALUMO Excel Functions
Introduction
CCHART
CCHARTDATAGRID
CCHARTSELECTIONS
CCONCAT
CEXECSTOREDPROC
CFORMATTER
CGET
CGETDATE
CGETLIST
CGETMDX
CGETMDXDATE
CGETMDXLIST
CGETMDXNOTE
CGETNOTE
CGETSQL
CHYPERLINK
CINFO
CMEMBER
CMEMBERCHILD
CMEMBERINDEX
CMEMBEROFFSET
CMEMBERPARENT
CPUT
CPUTNOTE
CRANGETOJSON
CREFLEX
CREFLEXSQL
CREFLEXTABLE
CREPORTCHECKBOX
CREPORTDATE
CREPORTFONT
CREPORTFRAME
CREPORTFREEZEPANE
CREPORTGROUP
CREPORTINPUT
CREPORTLIST
CREPORTLOCATION
CREPORTPART
CREPORTPARTPROPERTIES
CREPORTPROPERTIES
CREPORTSQLPAGER
CREPORTSQLPAGERPROPERTIES
CREPORTSQLSELECTOR
CREPORTSQLSELECTORPROPERTIES
CREPORTTOOLBAR
CREPORTSUPPRESS
CREPORTUPLOAD
CROUNDINGERROR
CSPREAD
CTABLEEDITOR
CTODAY
CURL
Intrinsic Member Properties
Excel VBA API
Excel VBA API
Introduction
CGetMdxGrid
Enable/DisableTheFuzz
ExecSqlProc
GetSqlData
OpenCalumoBrowser
OpenDrillThroughFromCGET
OpenDrillThroughFromCGETMDX
OpenMemberExplorer
PublishActiveSheet
WriteBack (VBA)
Settings
Published Reports Supported Excel Functions
Published Reports Supported Excel Functions
Introduction
Database and List Management Functions
Date and Time Functions
Financial Functions
Information Functions
Logical Functions
Lookup and Reference Functions
Math and Trigonometry Functions
Statistical Functions
Text Functions
Analysis Toolpak Functions
Report JavaScript API
Report JavaScript API
Introduction
Report API Methods
Report API Methods
Introduction
bind
calculate
getCalculatedRange
getCalculatedRanges
getCalculatedValues
getCalculationId
getChart
getChartDatasource
getElements
getKendoDataSource
getParamByName
getRange
getRanges
getReportChart
getSelectedMembers
getSelectedMembersEncoded
getUrl
getValues
isSkylight
loadScriptByUrl
sendToExcel
toolbar
trigger
writeback
Report Events
Report Events
Introduction
Event Data Structures
Event Data Structures
Introduction
Drill To Transactions Data-point Calculation Result
Report Details Object
Events
Events
Introduction
chart:rendering:complete
chart:updated
drillthrough:after
drillthrough:before
drillthrough:calculation
lightbox:close
pdf:after
pdf:before
postrender
precalculate
preinit
prerender
table-editor:rendering:complete
Custom HTML Elements Inside Published Reports
Skylights (Word) VBA API
Skylights (Word) VBA API
Introduction
OpenActiveSkylightInBrowser
Publish
RefreshAll
RefreshCurrent
SaveAs
Administration
Administration
CALUMO Administration
CALUMO Administration
Introduction
Access Control
Authorised Procs
Cube Events
Cube Events
Introduction
Cube Event Types
Writeback Parameter Options
Block Event Payloads
Parsing Keys
Dimension Maintenance
Editable Tables
Editable Tables
Introduction
Custom Tables
Import / Export
On Save Stored Procedures
Group Management
Group Management
Introduction
Managing Groups
Role Management
Role Management
Introduction
Core Roles
Managing Roles
Permissions
Job Management
Job Management
Introduction
Configuration
Monitoring Jobs
Permissions
Usability
Meta
Meta
Introduction
Administration
Publications
Query Logging
Report Vault
Report Vault
Introduction
Report Assets
Server Configuration
Server Configuration
Introduction
Application Settings
Connections
Datasource Mappings
Datasource Mappings
Introduction
Olap Connection String Defaults
Connecting to Analysis Services over HTTP(s)
Configuration of Snapshot Datasources
Connecting to Azure Analysis Services
Enable and Configure AV Scanning
Enable PowerPivot Model Publishing
Website Caching
Server Logs
In-depth Logging
Single Sign-On
Start Pages
User Management
CALUMO Requirements
CALUMO Requirements
Introduction
CALUMO Supported Software Matrix
CALUMO Database Server
CALUMO Web Server
CALUMO Office Client
Server Deployment Scenarios
SQL Server
CALUMO Installation
CALUMO Installation
Introduction
CALUMO Application Database Installation
CALUMO Application Database Installation
Introduction
Installation Validation
Silent Install - Database
Automatic Database Upgrades
CALUMO Web Server Install
CALUMO Web Server Install
Introduction
Pre-Upgrade Instructions
Installation Validation (IIS 7+)
Installation of CALUMO License File
Configuration for Forms Authentication
Configuration for Forms Authentication
Introduction
Update FormsAuthenticationEnabled property
Update CALUMO Server Configuration for Forms
Using Effective User Name in CALUMO
Using Effective User Name in CALUMO
Introduction
Assign a Service Accounts
Create a New Application Pool
Disable ASP.NET Impersonation
Grant Administrator Access
Update UseEffectiveUserName property
Update Active Directory
Configuration for Firewalls
Configuration for HTTPS
Configuration for LDAP
Configuration of Installation Directory Security
Encrypting the CALUMO Configuration
Silent Install - Webserver
Ensuring IIS is Configured to Compress the Correct Mime Types
Troubleshooting On-premise Installation
Troubleshooting On-premise Installation
Introduction
Current User Has Guest Access
How Do I Find The Schema Version of my Database
Logged in user shows as “Guest” and no username
Upgrade from versions before CALUMO 11.4
Upgrade From Prior 11.9.0.0 Version
Secure the Connection String
CALUMO Office Client Installation
CALUMO Office Client Installation
Introduction
Client Installation Notes
Silent Install - Office Client
Custom Installer Packager
CALUMO Client Registry Cleaner
Troubleshooting the CALUMO Office Client Installation
Troubleshooting the CALUMO Office Client Installation
Introduction
Installation of the CALUMO Office Client fails
Installation succeeds but I can not see the CALUMO ribbon
Send Diagnostics to CALUMO Support
Office Client Required and Optional Updates
How To Upgrade the CALUMO Office Client
Disaster Recovery Scenarios and Strategies
Release Notes
Release Notes
Introduction
CALUMO 2025.2
CALUMO 2025.2
Release Highlights
Version History
CALUMO 2025.1
CALUMO 2025.1
Version History
CALUMO 2024.4
CALUMO 2024.4
Release Highlights
Version History
CALUMO 2024.3
CALUMO 2024.3
Version History
CALUMO 2024.2
CALUMO 2024.2
Release Highlights
Version History
CALUMO 2024.1
CALUMO 2024.1
Version History
CALUMO 2023.4
CALUMO 2023.4
Version History
CALUMO 2023.3
CALUMO 2023.3
Version History
CALUMO 2023.2
CALUMO 2023.2
Version History
CALUMO 2023.1
CALUMO 2023.1
Version History
CALUMO 2022.4
CALUMO 2022.4
Version History
CALUMO 2022.3
CALUMO 2022.3
Version History
CALUMO 2022.2
CALUMO 2022.2
Version History
CALUMO 2022.1
CALUMO 2022.1
Version History
CALUMO 2021.4
CALUMO 2021.4
Release Highlights
Version History
CALUMO 2021.3
CALUMO 2021.3
Version History
CALUMO 2021.2
CALUMO 2021.2
Release Highlights
Version History
CALUMO 2021.1
CALUMO 2021.1
Release Highlights
Version History
CALUMO 2020.4
CALUMO 2020.4
Release Highlights
Version History
CALUMO 2020.3
CALUMO 2020.3
Release Highlights
Version History
CALUMO 2020.2
CALUMO 2020.2
Release Highlights
Version History
CALUMO 2020.1
CALUMO 2020.1
Release Highlights
Version History
CALUMO v12.2.1
CALUMO v12.2.1
Release Highlights
Version History
Advisories
CALUMO Software Release Process
CALUMO Software End Of Life
CALUMO End-User License Agreement
Credits
Release Highlights - 2024.1
¶
Back to top