EducationSoftwareStrategy.com
StrategyCommunity

Knowledge Base

Product

Community

Knowledge Base

TopicsBrowse ArticlesDeveloper Zone

Product

Download SoftwareProduct DocumentationSecurity Hub

Education

Tutorial VideosSolution GalleryEducation courses

Community

GuidelinesGrandmastersEvents
x_social-icon_white.svglinkedin_social-icon_white.svg
Strategy logoCommunity

© Strategy Inc. All Rights Reserved.

LegalTerms of UsePrivacy Policy
  1. Home
  2. Topics

KB35166: Is MicroStrategy Enterprise Manager tracking the execution of reports used as filter in other reports?


Community Admin

• Strategy


MicroStrategy Enterprise Manager is mainly tracking the report execution in the “IS_REPORT_STATS” table. When users execute a report, one new entry is logged into this table with information about execution such as: day, hour, minute, report id, filter id, etc.

Strategy Enterprise Manager is mainly tracking the report execution in the “IS_REPORT_STATS” table. When users execute a report, one new entry is logged into this table with information about execution such as: day, hour, minute, report id, filter id, etc.

ka04W000000Ogs1QAC_0EM440000002Akk.jpeg

If we analyze the report marked in red, we can find that the report is using another report as a filter.

ka04W000000Ogs1QAC_0EM440000002Akc.png
ka04W000000Ogs1QAC_0EM440000002Akm.png

Since the SQL of the report used as a filter is included inside the “main” report, Strategy is not tracking the independent execution. If users re-execute the “main” report, they will be able to see just one new entry. It is also important to note that the “FILTERID” column is not matching the GUID of the report used as a filter. This is working as design, because the report is registered as an embedded filter.

ka04W000000Ogs1QAC_0EM440000002Aki.jpeg

 


Comment

0 comments

Details

Knowledge Article

Published:

June 8, 2017

Last Updated:

June 8, 2017