Custom Measure data loaded successfully but not showing up in UI
Content
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.
Step1:
SELECT measure_id, granularity_id, creation_date, name
FROM msc_measures_vl
WHERE name like 'XX_Custom_Measure'
order by creation_date desc;
Measure_id=300000015813205, Granularity_id=300000015813206
Step2: Granularity details:
select MGD.GRANULARITY_ID, MGD.LEVEL_ID, MLT.NAME from MSC_GRANULARITY_DETAIL MGD, MSC_LEVELS_TL MLT
where
MGD.LEVEL_ID=MLT.LEVEL_ID
AND MLT.LANGUAGE='US'
AND MGD.granularity_id=300000015813206;
1 Item
41 Business Unit
51 Day
19008 PROV_DEPT
Step3: Find Dynamic tables against the granularity id and plan_id
Tagged:
0