KB440362: An extra entry is generated in STG_IS_REPORT_STATS each time for cube based document or dossier in MicroStrategy 10.x

Starting with the release of Strategy ONE (March 2024), dossiers are also known as dashboards.
SYMPTOM:
 
In Strategy 10.x, An extra entry is generated in STG_IS_REPORT_STATS each time a document or dossier which uses an Intelligent Cube as a dataset is executed.
 
Two entries are logged with two different entries are logged into STG_IS_REPORT_STATS for same session ID 1813 as shown below:

 
REPRODUCING STEPS IN TUTORIAL:

1. Create an Intelligent cube
2. Create a Document based off the cube
3. Save the Document 
4. Run the Document
5. Via DBQuery tool, it is noticed one transaction for execute report and one transaction for execute document.

 
CAUSE:
 
This is working as designed with Strategy document execution workflow.
 
When executing a cube based document, there is a fake cube instance needs to be executed to do resolution and find cube, there is always one record for the cube/report execution each time when a dossier/document is executed.
 
 
ACTION:
 
An enhancement request has been raised to Skip the logging for the fake cube statistics in table STG_IS_REPORT_STATS. This enhancement has been introduced from Strategy 10.11. Please upgrade to take advantage of the new feature.
 
Article Reference Number: KB440362 KB440362