Not Able to View Custom Measure Data in Dashboard

(Doc ID 2352809.1)

Last updated on MARCH 05, 2018

Applies to:

Oracle Sales and Operations Planning Cloud Service - Version 11.13.17.09.0 and later
Information in this document applies to any platform.

Symptoms

Using Oracle Sales and Operations Planning Cloud Service / SOP Analytics

When attempting to view a custom measure in the Sales and Operations Planning dashboard, the following error occurs:

ERROR
-----------------------


-- Steps To Reproduce:

1. Create custom measure MyCompany EOL Shipment Forecast defined as a number expression of Case(Attr(Item,Life Cycle Phase) When 'Phase_out' Then 100 Else 50)
2. Add the above custom measure MyCompany EOL Shipment Forecast to the Measure Catalog named MyCompany Custom S&OP Catalog
3. Define and Run a S&OP plan named S&OP for P1.7 using the Measure Catalog named MyCompany Custom S&OP Catalog
4. Define a UI table named MyCompany EOL Shipment Table to be displayed in the work area for the S&OP for P1.7 plan using the Executive Review Page Layout.
5. Observe the noted error.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms