Planning Percent History measure is causing an error
Summary: CTO measures are causing tables to fail. Digging into the measure expressions the core measure which looks to be causing the issue is Planning Percent History.
Content (required): Initial issue occurring in measure 'Option Demand Forecast'. Upon drilling into the measure's expressions and adding the contributing measures one at a time to the table, the problematic measure looks to be 'Planning Percent History' which simply references another measure. The expression is Safe_Division(nvl(Aggregated Planning History,0),nvl(parent(Aggregated Planning History),0),null).
The referenced measure 'Aggregated Planning History' can be added to the table without issue and runs fine.
Tagged:
0