Learn about Redwood and be one of the first to join the conversation

Visit Redwood Community
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

Custom Measure data loaded successfully but not showing up in UI

Received Response
33
Views
1
Comments
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!