Strategy diagnostic logs for capturing SQL statements against the metadata and data warehouses are well-known. Strategy technical notes on these logs are listed at the end of this document for reference.
These logs also capture some information about multidimensional expression (MDX) execution. Other diagnostics, less commonly used, can provide more information. The logging options are different depending on whether the data source is a SAP BW database or an XMLA (XML for Analysis) cube provider such as Microsoft Analysis Services (MSAS) or Hyperion Essbase.
Of particular importance is the fact that the DSS Database Classes - Trace SQL diagnostic does not capture element browsing requests submitted against a cube warehouse. This is because the Strategy MDX engine does not use an MDX statement to retrieve attribute elements. For this, the Engine - DFC Engine log must be used. XMLA data sources may also use the XMLA - Verbose Info log.
Diagnostics for SAP BW
DB object: “Microsoft SQL Server 2012”
RATE_IDRATE_DESC118.9212.635.749.7MONTH_IDMONTH_DESC200201Jan 02200202Feb 02200203Mar 03RATE_IDMONTH_IDFACT112002012120020342200201622002028220020310320020212420020314Type of informationLog componentLog dispatcherMDX execution errorDatabase ClassesErrorMDX for report executionEngineDFC EngineDatabase ClassesTrace SQLMDX for attribute element request *EngineDFC EngineType of informationLog componentLog dispatcherMDX execution errorDatabase ClassesErrorMDX for report executionEngineDFC EngineXMLAVerbose InfoDatabase ClassesTrace SQLMDX for attribute element requestEngineDFC EngineXMLAVerbose Info | DB object: “Microsoft SQL Server 2012”
RATE_IDRATE_DESC118.9212.635.749.7MONTH_IDMONTH_DESC200201Jan 02200202Feb 02200203Mar 03RATE_IDMONTH_IDFACT112002012120020342200201622002028220020310320020212420020314Type of informationLog componentLog dispatcherMDX execution errorDatabase ClassesErrorMDX for report executionEngineDFC EngineDatabase ClassesTrace SQLMDX for attribute element request *EngineDFC EngineType of informationLog componentLog dispatcherMDX execution errorDatabase ClassesErrorMDX for report executionEngineDFC EngineXMLAVerbose InfoDatabase ClassesTrace SQLMDX for attribute element requestEngineDFC EngineXMLAVerbose Info | DB object: “Microsoft SQL Server 2012”
RATE_IDRATE_DESC118.9212.635.749.7MONTH_IDMONTH_DESC200201Jan 02200202Feb 02200203Mar 03RATE_IDMONTH_IDFACT112002012120020342200201622002028220020310320020212420020314Type of informationLog componentLog dispatcherMDX execution errorDatabase ClassesErrorMDX for report executionEngineDFC EngineDatabase ClassesTrace SQLMDX for attribute element request *EngineDFC EngineType of informationLog componentLog dispatcherMDX execution errorDatabase ClassesErrorMDX for report executionEngineDFC EngineXMLAVerbose InfoDatabase ClassesTrace SQLMDX for attribute element requestEngineDFC EngineXMLAVerbose Info |
DB object: “Microsoft SQL Server 2012”
RATE_IDRATE_DESC118.9212.635.749.7MONTH_IDMONTH_DESC200201Jan 02200202Feb 02200203Mar 03RATE_IDMONTH_IDFACT112002012120020342200201622002028220020310320020212420020314Type of informationLog componentLog dispatcherMDX execution errorDatabase ClassesErrorMDX for report executionEngineDFC EngineDatabase ClassesTrace SQLMDX for attribute element request *EngineDFC EngineType of informationLog componentLog dispatcherMDX execution errorDatabase ClassesErrorMDX for report executionEngineDFC EngineXMLAVerbose InfoDatabase ClassesTrace SQLMDX for attribute element requestEngineDFC EngineXMLAVerbose Info | DB object: “Microsoft SQL Server 2012”
RATE_IDRATE_DESC118.9212.635.749.7MONTH_IDMONTH_DESC200201Jan 02200202Feb 02200203Mar 03RATE_IDMONTH_IDFACT112002012120020342200201622002028220020310320020212420020314Type of informationLog componentLog dispatcherMDX execution errorDatabase ClassesErrorMDX for report executionEngineDFC EngineDatabase ClassesTrace SQLMDX for attribute element request *EngineDFC EngineType of informationLog componentLog dispatcherMDX execution errorDatabase ClassesErrorMDX for report executionEngineDFC EngineXMLAVerbose InfoDatabase ClassesTrace SQLMDX for attribute element requestEngineDFC EngineXMLAVerbose Info | DB object: “Microsoft SQL Server 2012”
RATE_IDRATE_DESC118.9212.635.749.7MONTH_IDMONTH_DESC200201Jan 02200202Feb 02200203Mar 03RATE_IDMONTH_IDFACT112002012120020342200201622002028220020310320020212420020314Type of informationLog componentLog dispatcherMDX execution errorDatabase ClassesErrorMDX for report executionEngineDFC EngineDatabase ClassesTrace SQLMDX for attribute element request *EngineDFC EngineType of informationLog componentLog dispatcherMDX execution errorDatabase ClassesErrorMDX for report executionEngineDFC EngineXMLAVerbose InfoDatabase ClassesTrace SQLMDX for attribute element requestEngineDFC EngineXMLAVerbose Info |
DB object: “Microsoft SQL Server 2012”
RATE_IDRATE_DESC118.9212.635.749.7MONTH_IDMONTH_DESC200201Jan 02200202Feb 02200203Mar 03RATE_IDMONTH_IDFACT112002012120020342200201622002028220020310320020212420020314Type of informationLog componentLog dispatcherMDX execution errorDatabase ClassesErrorMDX for report executionEngineDFC EngineDatabase ClassesTrace SQLMDX for attribute element request *EngineDFC EngineType of informationLog componentLog dispatcherMDX execution errorDatabase ClassesErrorMDX for report executionEngineDFC EngineXMLAVerbose InfoDatabase ClassesTrace SQLMDX for attribute element requestEngineDFC EngineXMLAVerbose Info | DB object: “Microsoft SQL Server 2012”
RATE_IDRATE_DESC118.9212.635.749.7MONTH_IDMONTH_DESC200201Jan 02200202Feb 02200203Mar 03RATE_IDMONTH_IDFACT112002012120020342200201622002028220020310320020212420020314Type of informationLog componentLog dispatcherMDX execution errorDatabase ClassesErrorMDX for report executionEngineDFC EngineDatabase ClassesTrace SQLMDX for attribute element request *EngineDFC EngineType of informationLog componentLog dispatcherMDX execution errorDatabase ClassesErrorMDX for report executionEngineDFC EngineXMLAVerbose InfoDatabase ClassesTrace SQLMDX for attribute element requestEngineDFC EngineXMLAVerbose Info | DB object: “Microsoft SQL Server 2012”
RATE_IDRATE_DESC118.9212.635.749.7MONTH_IDMONTH_DESC200201Jan 02200202Feb 02200203Mar 03RATE_IDMONTH_IDFACT112002012120020342200201622002028220020310320020212420020314Type of informationLog componentLog dispatcherMDX execution errorDatabase ClassesErrorMDX for report executionEngineDFC EngineDatabase ClassesTrace SQLMDX for attribute element request *EngineDFC EngineType of informationLog componentLog dispatcherMDX execution errorDatabase ClassesErrorMDX for report executionEngineDFC EngineXMLAVerbose InfoDatabase ClassesTrace SQLMDX for attribute element requestEngineDFC EngineXMLAVerbose Info |
DB object: “Microsoft SQL Server 2012”
RATE_IDRATE_DESC118.9212.635.749.7MONTH_IDMONTH_DESC200201Jan 02200202Feb 02200203Mar 03RATE_IDMONTH_IDFACT112002012120020342200201622002028220020310320020212420020314Type of informationLog componentLog dispatcherMDX execution errorDatabase ClassesErrorMDX for report executionEngineDFC EngineDatabase ClassesTrace SQLMDX for attribute element request *EngineDFC EngineType of informationLog componentLog dispatcherMDX execution errorDatabase ClassesErrorMDX for report executionEngineDFC EngineXMLAVerbose InfoDatabase ClassesTrace SQLMDX for attribute element requestEngineDFC EngineXMLAVerbose Info | DB object: “Microsoft SQL Server 2012”
RATE_IDRATE_DESC118.9212.635.749.7MONTH_IDMONTH_DESC200201Jan 02200202Feb 02200203Mar 03RATE_IDMONTH_IDFACT112002012120020342200201622002028220020310320020212420020314Type of informationLog componentLog dispatcherMDX execution errorDatabase ClassesErrorMDX for report executionEngineDFC EngineDatabase ClassesTrace SQLMDX for attribute element request *EngineDFC EngineType of informationLog componentLog dispatcherMDX execution errorDatabase ClassesErrorMDX for report executionEngineDFC EngineXMLAVerbose InfoDatabase ClassesTrace SQLMDX for attribute element requestEngineDFC EngineXMLAVerbose Info |
DB object: “Microsoft SQL Server 2012”
RATE_IDRATE_DESC118.9212.635.749.7MONTH_IDMONTH_DESC200201Jan 02200202Feb 02200203Mar 03RATE_IDMONTH_IDFACT112002012120020342200201622002028220020310320020212420020314Type of informationLog componentLog dispatcherMDX execution errorDatabase ClassesErrorMDX for report executionEngineDFC EngineDatabase ClassesTrace SQLMDX for attribute element request *EngineDFC EngineType of informationLog componentLog dispatcherMDX execution errorDatabase ClassesErrorMDX for report executionEngineDFC EngineXMLAVerbose InfoDatabase ClassesTrace SQLMDX for attribute element requestEngineDFC EngineXMLAVerbose Info | DB object: “Microsoft SQL Server 2012”
RATE_IDRATE_DESC118.9212.635.749.7MONTH_IDMONTH_DESC200201Jan 02200202Feb 02200203Mar 03RATE_IDMONTH_IDFACT112002012120020342200201622002028220020310320020212420020314Type of informationLog componentLog dispatcherMDX execution errorDatabase ClassesErrorMDX for report executionEngineDFC EngineDatabase ClassesTrace SQLMDX for attribute element request *EngineDFC EngineType of informationLog componentLog dispatcherMDX execution errorDatabase ClassesErrorMDX for report executionEngineDFC EngineXMLAVerbose InfoDatabase ClassesTrace SQLMDX for attribute element requestEngineDFC EngineXMLAVerbose Info | DB object: “Microsoft SQL Server 2012”
RATE_IDRATE_DESC118.9212.635.749.7MONTH_IDMONTH_DESC200201Jan 02200202Feb 02200203Mar 03RATE_IDMONTH_IDFACT112002012120020342200201622002028220020310320020212420020314Type of informationLog componentLog dispatcherMDX execution errorDatabase ClassesErrorMDX for report executionEngineDFC EngineDatabase ClassesTrace SQLMDX for attribute element request *EngineDFC EngineType of informationLog componentLog dispatcherMDX execution errorDatabase ClassesErrorMDX for report executionEngineDFC EngineXMLAVerbose InfoDatabase ClassesTrace SQLMDX for attribute element requestEngineDFC EngineXMLAVerbose Info |
* Note: The DFC Engine log will show the results of the element browse request. The only indication of the request itself is found in the Database Classes - SQL Trace log.
RowSet Call: GetMembers
Diagnostics for XMLA
DB object: “Microsoft SQL Server 2012”
RATE_IDRATE_DESC118.9212.635.749.7MONTH_IDMONTH_DESC200201Jan 02200202Feb 02200203Mar 03RATE_IDMONTH_IDFACT112002012120020342200201622002028220020310320020212420020314Type of informationLog componentLog dispatcherMDX execution errorDatabase ClassesErrorMDX for report executionEngineDFC EngineDatabase ClassesTrace SQLMDX for attribute element request *EngineDFC EngineType of informationLog componentLog dispatcherMDX execution errorDatabase ClassesErrorMDX for report executionEngineDFC EngineXMLAVerbose InfoDatabase ClassesTrace SQLMDX for attribute element requestEngineDFC EngineXMLAVerbose Info | DB object: “Microsoft SQL Server 2012”
RATE_IDRATE_DESC118.9212.635.749.7MONTH_IDMONTH_DESC200201Jan 02200202Feb 02200203Mar 03RATE_IDMONTH_IDFACT112002012120020342200201622002028220020310320020212420020314Type of informationLog componentLog dispatcherMDX execution errorDatabase ClassesErrorMDX for report executionEngineDFC EngineDatabase ClassesTrace SQLMDX for attribute element request *EngineDFC EngineType of informationLog componentLog dispatcherMDX execution errorDatabase ClassesErrorMDX for report executionEngineDFC EngineXMLAVerbose InfoDatabase ClassesTrace SQLMDX for attribute element requestEngineDFC EngineXMLAVerbose Info | DB object: “Microsoft SQL Server 2012”
RATE_IDRATE_DESC118.9212.635.749.7MONTH_IDMONTH_DESC200201Jan 02200202Feb 02200203Mar 03RATE_IDMONTH_IDFACT112002012120020342200201622002028220020310320020212420020314Type of informationLog componentLog dispatcherMDX execution errorDatabase ClassesErrorMDX for report executionEngineDFC EngineDatabase ClassesTrace SQLMDX for attribute element request *EngineDFC EngineType of informationLog componentLog dispatcherMDX execution errorDatabase ClassesErrorMDX for report executionEngineDFC EngineXMLAVerbose InfoDatabase ClassesTrace SQLMDX for attribute element requestEngineDFC EngineXMLAVerbose Info |
DB object: “Microsoft SQL Server 2012”
RATE_IDRATE_DESC118.9212.635.749.7MONTH_IDMONTH_DESC200201Jan 02200202Feb 02200203Mar 03RATE_IDMONTH_IDFACT112002012120020342200201622002028220020310320020212420020314Type of informationLog componentLog dispatcherMDX execution errorDatabase ClassesErrorMDX for report executionEngineDFC EngineDatabase ClassesTrace SQLMDX for attribute element request *EngineDFC EngineType of informationLog componentLog dispatcherMDX execution errorDatabase ClassesErrorMDX for report executionEngineDFC EngineXMLAVerbose InfoDatabase ClassesTrace SQLMDX for attribute element requestEngineDFC EngineXMLAVerbose Info | DB object: “Microsoft SQL Server 2012”
RATE_IDRATE_DESC118.9212.635.749.7MONTH_IDMONTH_DESC200201Jan 02200202Feb 02200203Mar 03RATE_IDMONTH_IDFACT112002012120020342200201622002028220020310320020212420020314Type of informationLog componentLog dispatcherMDX execution errorDatabase ClassesErrorMDX for report executionEngineDFC EngineDatabase ClassesTrace SQLMDX for attribute element request *EngineDFC EngineType of informationLog componentLog dispatcherMDX execution errorDatabase ClassesErrorMDX for report executionEngineDFC EngineXMLAVerbose InfoDatabase ClassesTrace SQLMDX for attribute element requestEngineDFC EngineXMLAVerbose Info | DB object: “Microsoft SQL Server 2012”
RATE_IDRATE_DESC118.9212.635.749.7MONTH_IDMONTH_DESC200201Jan 02200202Feb 02200203Mar 03RATE_IDMONTH_IDFACT112002012120020342200201622002028220020310320020212420020314Type of informationLog componentLog dispatcherMDX execution errorDatabase ClassesErrorMDX for report executionEngineDFC EngineDatabase ClassesTrace SQLMDX for attribute element request *EngineDFC EngineType of informationLog componentLog dispatcherMDX execution errorDatabase ClassesErrorMDX for report executionEngineDFC EngineXMLAVerbose InfoDatabase ClassesTrace SQLMDX for attribute element requestEngineDFC EngineXMLAVerbose Info |
DB object: “Microsoft SQL Server 2012”
RATE_IDRATE_DESC118.9212.635.749.7MONTH_IDMONTH_DESC200201Jan 02200202Feb 02200203Mar 03RATE_IDMONTH_IDFACT112002012120020342200201622002028220020310320020212420020314Type of informationLog componentLog dispatcherMDX execution errorDatabase ClassesErrorMDX for report executionEngineDFC EngineDatabase ClassesTrace SQLMDX for attribute element request *EngineDFC EngineType of informationLog componentLog dispatcherMDX execution errorDatabase ClassesErrorMDX for report executionEngineDFC EngineXMLAVerbose InfoDatabase ClassesTrace SQLMDX for attribute element requestEngineDFC EngineXMLAVerbose Info | DB object: “Microsoft SQL Server 2012”
RATE_IDRATE_DESC118.9212.635.749.7MONTH_IDMONTH_DESC200201Jan 02200202Feb 02200203Mar 03RATE_IDMONTH_IDFACT112002012120020342200201622002028220020310320020212420020314Type of informationLog componentLog dispatcherMDX execution errorDatabase ClassesErrorMDX for report executionEngineDFC EngineDatabase ClassesTrace SQLMDX for attribute element request *EngineDFC EngineType of informationLog componentLog dispatcherMDX execution errorDatabase ClassesErrorMDX for report executionEngineDFC EngineXMLAVerbose InfoDatabase ClassesTrace SQLMDX for attribute element requestEngineDFC EngineXMLAVerbose Info | DB object: “Microsoft SQL Server 2012”
RATE_IDRATE_DESC118.9212.635.749.7MONTH_IDMONTH_DESC200201Jan 02200202Feb 02200203Mar 03RATE_IDMONTH_IDFACT112002012120020342200201622002028220020310320020212420020314Type of informationLog componentLog dispatcherMDX execution errorDatabase ClassesErrorMDX for report executionEngineDFC EngineDatabase ClassesTrace SQLMDX for attribute element request *EngineDFC EngineType of informationLog componentLog dispatcherMDX execution errorDatabase ClassesErrorMDX for report executionEngineDFC EngineXMLAVerbose InfoDatabase ClassesTrace SQLMDX for attribute element requestEngineDFC EngineXMLAVerbose Info |
DB object: “Microsoft SQL Server 2012”
RATE_IDRATE_DESC118.9212.635.749.7MONTH_IDMONTH_DESC200201Jan 02200202Feb 02200203Mar 03RATE_IDMONTH_IDFACT112002012120020342200201622002028220020310320020212420020314Type of informationLog componentLog dispatcherMDX execution errorDatabase ClassesErrorMDX for report executionEngineDFC EngineDatabase ClassesTrace SQLMDX for attribute element request *EngineDFC EngineType of informationLog componentLog dispatcherMDX execution errorDatabase ClassesErrorMDX for report executionEngineDFC EngineXMLAVerbose InfoDatabase ClassesTrace SQLMDX for attribute element requestEngineDFC EngineXMLAVerbose Info | DB object: “Microsoft SQL Server 2012”
RATE_IDRATE_DESC118.9212.635.749.7MONTH_IDMONTH_DESC200201Jan 02200202Feb 02200203Mar 03RATE_IDMONTH_IDFACT112002012120020342200201622002028220020310320020212420020314Type of informationLog componentLog dispatcherMDX execution errorDatabase ClassesErrorMDX for report executionEngineDFC EngineDatabase ClassesTrace SQLMDX for attribute element request *EngineDFC EngineType of informationLog componentLog dispatcherMDX execution errorDatabase ClassesErrorMDX for report executionEngineDFC EngineXMLAVerbose InfoDatabase ClassesTrace SQLMDX for attribute element requestEngineDFC EngineXMLAVerbose Info |
DB object: “Microsoft SQL Server 2012”
RATE_IDRATE_DESC118.9212.635.749.7MONTH_IDMONTH_DESC200201Jan 02200202Feb 02200203Mar 03RATE_IDMONTH_IDFACT112002012120020342200201622002028220020310320020212420020314Type of informationLog componentLog dispatcherMDX execution errorDatabase ClassesErrorMDX for report executionEngineDFC EngineDatabase ClassesTrace SQLMDX for attribute element request *EngineDFC EngineType of informationLog componentLog dispatcherMDX execution errorDatabase ClassesErrorMDX for report executionEngineDFC EngineXMLAVerbose InfoDatabase ClassesTrace SQLMDX for attribute element requestEngineDFC EngineXMLAVerbose Info | DB object: “Microsoft SQL Server 2012”
RATE_IDRATE_DESC118.9212.635.749.7MONTH_IDMONTH_DESC200201Jan 02200202Feb 02200203Mar 03RATE_IDMONTH_IDFACT112002012120020342200201622002028220020310320020212420020314Type of informationLog componentLog dispatcherMDX execution errorDatabase ClassesErrorMDX for report executionEngineDFC EngineDatabase ClassesTrace SQLMDX for attribute element request *EngineDFC EngineType of informationLog componentLog dispatcherMDX execution errorDatabase ClassesErrorMDX for report executionEngineDFC EngineXMLAVerbose InfoDatabase ClassesTrace SQLMDX for attribute element requestEngineDFC EngineXMLAVerbose Info |
DB object: “Microsoft SQL Server 2012”
RATE_IDRATE_DESC118.9212.635.749.7MONTH_IDMONTH_DESC200201Jan 02200202Feb 02200203Mar 03RATE_IDMONTH_IDFACT112002012120020342200201622002028220020310320020212420020314Type of informationLog componentLog dispatcherMDX execution errorDatabase ClassesErrorMDX for report executionEngineDFC EngineDatabase ClassesTrace SQLMDX for attribute element request *EngineDFC EngineType of informationLog componentLog dispatcherMDX execution errorDatabase ClassesErrorMDX for report executionEngineDFC EngineXMLAVerbose InfoDatabase ClassesTrace SQLMDX for attribute element requestEngineDFC EngineXMLAVerbose Info | DB object: “Microsoft SQL Server 2012”
RATE_IDRATE_DESC118.9212.635.749.7MONTH_IDMONTH_DESC200201Jan 02200202Feb 02200203Mar 03RATE_IDMONTH_IDFACT112002012120020342200201622002028220020310320020212420020314Type of informationLog componentLog dispatcherMDX execution errorDatabase ClassesErrorMDX for report executionEngineDFC EngineDatabase ClassesTrace SQLMDX for attribute element request *EngineDFC EngineType of informationLog componentLog dispatcherMDX execution errorDatabase ClassesErrorMDX for report executionEngineDFC EngineXMLAVerbose InfoDatabase ClassesTrace SQLMDX for attribute element requestEngineDFC EngineXMLAVerbose Info | DB object: “Microsoft SQL Server 2012”
RATE_IDRATE_DESC118.9212.635.749.7MONTH_IDMONTH_DESC200201Jan 02200202Feb 02200203Mar 03RATE_IDMONTH_IDFACT112002012120020342200201622002028220020310320020212420020314Type of informationLog componentLog dispatcherMDX execution errorDatabase ClassesErrorMDX for report executionEngineDFC EngineDatabase ClassesTrace SQLMDX for attribute element request *EngineDFC EngineType of informationLog componentLog dispatcherMDX execution errorDatabase ClassesErrorMDX for report executionEngineDFC EngineXMLAVerbose InfoDatabase ClassesTrace SQLMDX for attribute element requestEngineDFC EngineXMLAVerbose Info |
DB object: “Microsoft SQL Server 2012”
RATE_IDRATE_DESC118.9212.635.749.7MONTH_IDMONTH_DESC200201Jan 02200202Feb 02200203Mar 03RATE_IDMONTH_IDFACT112002012120020342200201622002028220020310320020212420020314Type of informationLog componentLog dispatcherMDX execution errorDatabase ClassesErrorMDX for report executionEngineDFC EngineDatabase ClassesTrace SQLMDX for attribute element request *EngineDFC EngineType of informationLog componentLog dispatcherMDX execution errorDatabase ClassesErrorMDX for report executionEngineDFC EngineXMLAVerbose InfoDatabase ClassesTrace SQLMDX for attribute element requestEngineDFC EngineXMLAVerbose Info | DB object: “Microsoft SQL Server 2012”
RATE_IDRATE_DESC118.9212.635.749.7MONTH_IDMONTH_DESC200201Jan 02200202Feb 02200203Mar 03RATE_IDMONTH_IDFACT112002012120020342200201622002028220020310320020212420020314Type of informationLog componentLog dispatcherMDX execution errorDatabase ClassesErrorMDX for report executionEngineDFC EngineDatabase ClassesTrace SQLMDX for attribute element request *EngineDFC EngineType of informationLog componentLog dispatcherMDX execution errorDatabase ClassesErrorMDX for report executionEngineDFC EngineXMLAVerbose InfoDatabase ClassesTrace SQLMDX for attribute element requestEngineDFC EngineXMLAVerbose Info |
Example log entries for SAP BW
Element browsing request
RowSet Call: GetMembers
On element browsing reply
MDX Result Set: Members Catalog Set
MDX Result Set: MDX Element Browsing Result Set
Column 0: ID
Column 1: DESC
Row 0: ., Boston
Row 1: ., New York
Report execution
12EAA728112EAA748with set as '{..members}' select {.} on columns, non empty hierarchize({}) on rows from
On report execution reply
RowSet Call: GetAxisData
RowSet Call: GetCellData
Note that the RowSet call indicates the type of information desired from the warehouse. For element browsing, the call is to get hierarchical members. No MDX needs to be submitted for this call to return results. During report execution, the RowSet calls occur after the multidimensional expression has completed execution in the warehouse. Separate calls are needed to retrieve access information (usually attributes) and cell data (metrics).
The calls are similar for XMLA data sources. The exact XML strings submitted and received can be found in the XMLA - Verbose Info log. The result strings in particular may be extremely long.
Important: All of the diagnostics described in this article log a great deal of information and will have a negative performance impact on production systems. Strategy recommends enabling these logs only for brief, controlled tests and disabling the logs immediately afterward.
Strategy Diagnostics to capture SQL executed against relational databases
KB5200-8X-0524 - Important diagnostics used for capturing SQL for various requests submitted by Strategy Engine 8.x
KB5200-007-0024 - How to view the SQL generated by Strategy SQL Generation Engine for a report job or element browsing
KB5303-753-0726 - How to trace the SQL generated by Strategy Engine 8.x
