Skip to content

CALUMO Documentation

OpenDrillThroughFromCGETMDX

Initializing search

Home
Reference
Administration
Release Notes

CALUMO Documentation

Home
Home
- Introduction
- CALUMO Home
  CALUMO Home
- 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
- Published Reports
  Published Reports
- 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
  - 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
Reference
Reference
- CALUMO Excel Functions
  CALUMO Excel Functions
- Excel VBA API
  Excel VBA API
  - Introduction
  - CGetMdxGrid
  - Enable/DisableTheFuzz
  - ExecSqlProc
  - GetSqlData
  - OpenCalumoBrowser
  - OpenDrillThroughFromCGET
  - OpenDrillThroughFromCGETMDX OpenDrillThroughFromCGETMDX
    Table of contents
    
    Summary
    
    Example
  - OpenMemberExplorer
  - PublishActiveSheet
  - WriteBack (VBA)
  - Settings
- Published Reports Supported Excel Functions
  Published Reports Supported Excel 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
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
- 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
  - 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 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

Table of contents

Summary
Example

OpenDrillThroughFromCGETMDX¶

Summary¶

Opens a drill through from the selected cell if it is a CGETMDX

Example¶

Previous OpenDrillThroughFromCGET

Next OpenMemberExplorer

© insightsoftware. All Rights Reserved.

Made with Material for MkDocs