Custom Measure data loaded successfully but not showing up in UI — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register
Get Started with Redwood: Oracle Cloud SCM and Purchasing

Custom Measure data loaded successfully but not showing up in UI

edited Aug 21, 2019 2:32PM in Supply Chain Planning and Collaboration 1 comment

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

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!