Retail Predictive Application Server (MOSC)

MOSC Banner

Is it possible to access dynamic parent level in calculation?

edited Oct 1, 2019 9:00AM in Retail Predictive Application Server (MOSC) 6 commentsAnswered ✓

Gents,

We would like to implement our own "extended measure"

What we need is to able to access parent level of currently being evaluated level.

Example:

WeekSharesP [day_recalc]

On day level:

WeekSharesP = WeekSharesP / WeekSharesP.level([clnd].[week])

On week level:

WeekSharesP = WeekSharesP / WeekSharesP.level([clnd].[mnth])

On month level

WeekSharesP = WeekSharesP / WeekSharesP.level([clnd].[qrtr])

(...)

So basically we want expression like:

WeekSharesP = WeekSharesP / WeekSharesP.level([clnd].**UP** / current+1)

How we can achieve it?

One solution is using multisource but it is very dirty solution and requires creating a lot of unnecessary temporary measures at different levels.

Regards

Piotr

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