Database DataWarehousing (MOSC)

MOSC Banner

OLAP - COMV - Calcualted Measures

edited Apr 25, 2012 2:05AM in Database DataWarehousing (MOSC) 2 commentsAnswered
Hi

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.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

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

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center