Database DataWarehousing (MOSC)

MOSC Banner

OLAP calculated measure YTD in cube organized MV and Query rewrite

edited Jun 25, 2015 10:05AM in Database DataWarehousing (MOSC) 1 commentAnswered

Hi,

Will appreciate if someone can help me with a question regarding Cube organized MV (OLAP).

Does cube organized materialized view with calculated measures based on time series  Year to date, inception to date  eg.

SUM(FCT_POSITION.BASE_REALIZED_PNL) OVER (HIERARCHY DIM_CALENDAR.CALENDAR BETWEEN UNBOUNDED PRECEDING AND CURRENT MEMBER WITHIN ANCESTOR AT DIMENSION LEVEL DIM_CALENDAR."YEAR")

are eligible for query rewrites or these are considered advanced for query rewrite purposes.

I was hoping to find an example with YTD window function on physical fact dim tables  with optimizer rewriting it to Cube Org. MV but not much success.

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