Custom Measure data loaded successfully but not showing up in UI
Created XX_Custom_Measure and loaded data(aggregated level) Item Category, Business Unit, Day & Province. Data loaded successfully but could not see the data in UI tables.
SELECT measure_id, granularity_id, creation_date, name
WHERE name like 'XX_Custom_Measure'
order by creation_date desc;
Step2: Granularity details:
select MGD.GRANULARITY_ID, MGD.LEVEL_ID, MLT.NAME from MSC_GRANULARITY_DETAIL MGD, MSC_LEVELS_TL MLT
41 Business Unit
Step3: Find Dynamic tables against the granularity id and plan_id