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

KB442412: No data returns when trying to list all tables and columns accessed in a certain project and table IS_REP_COL_FACT is empty in Enterprise Manager warehouse tables in Microstrategy 10.4 and newer


Maria Lourdes Rodriguez Pedrido

Manager, Technical Support • Strategy


This article explains why no data returns when trying to list all tables and columns accessed in a certain project and table IS_REP_COL_FACT is empty in Enterprise Manager warehouse tables in Microstrategy 10.4 and newer

SYMPTOM
When trying to list all tables and columns accessed in a certain project the report has no data.  Also the Enterprise Manager warehouse table IS_REP_COL_FACT is empty.
CAUSE
The option "Report job tables/columns accessed" in Project configuration / Statistics needs to be selected so that the table STG_IS_REP_COL_STATS is populated.   

ka02R000000kb0LQAQ_0EM44000000RXlg.png

Once STG_IS_REP_COL_STATS gets populated, running a new Data load will render data in IS_REP_COL_FACT and the report will show the list of tables and columns accessed in a certain project.
Note: The data collected once the option above is activated will be from when it was activated, so no historical data will be loaded.
ACTION

  • Please select the option "Report job tables/columns accessed" in Project configuration / Statistics to populate the table STG_IS_REP_COL_STATS.
  • Please run a Dataload to populate the table IS_REP_COL_FACT.


KB442412


Comment

0 comments

Details

Knowledge Article

Published:

December 19, 2018

Last Updated:

January 4, 2019