OLAP - COMV - Calcualted Measures
We are doing a POC on Cube Organized Materialized view.
AWM - Version - 11.1.0.6.0
Oracle 11G Enterprise Edition Release 11.1.0.7.0 - 64 Bit production.
We have created a cube and apart from normal measures we created two calucluted measures based on the timeseries.
After maintaining the cube logged into the user to see the view related to cube were created or Not.
Everything looks fine. Materialized veiw was created as we had selected the option to create a Materialized view.
But in the Materialzed view contained only normal measures and dimentsion. The calculated measures was not there.
The calculated measures were part of the cube and not materalized view.