I this post I will discuss creating Calculations in Oracle Analytics on an EPM Data Source. My previous posts related to Oracle Analytics with EPM Data can be found at the following links:
In Part 2, I showed how to make 2 performance tiles using filters at the visualization level.
EPM and Essbase data sources treat the data to be displayed as an intersection of the dimensions. A single Value.
This causing difficulty in trying to display a dimension across two different measures.
Butterfly Charts and Scatter Plots are two types of visual displays that do not work when there is a single value.
So how does one create 2 values / measures?
It is quite easy. On the left panel below the data source is an option to create calculations.
Below are 2 new measures I created so that I could create the Butterfly Chart and Scatter Plots shown above.
This 3 part series was meant to demystify the nuances of creating awesome visualizations off EPM data.