Implementing Custom Calculated Measure in 11g AWM OLAP
613119Mar 26 2008 — edited Apr 22 2008How do we go about implementing a custom Calculated measure in 11g OLAP?
The measure has to be available in the all_cube_measures view.
We need something similar to the following:
...
Measure Name = HOW_IS_MARGIN
Equation = If SALES.PROFIT.MEASURE/SALES.SALES.MEASURE gt .2 then 'GROOVY' else if SALES.PROFIT.MEASURE/SALES.SALES.MEASURE lt .1 then 'YIPES' else 'WHATEVER'
Data Type = TEXT
...
Source: Keith Laker's blog article (http://oracleolap.blogspot.com/search/label/Calculated%20Measures)
We plan to create an Account Dimension (with more than 2000 members spanning 5 levels). The Custom Calculated measure would allow us to be able to calculate Ratios, Balance sheet, P/L type Account dimension members on the fly.