Hyperion Essbase (MOSC)

MOSC Banner

ASO MDX formula optimization or different method

edited Feb 25, 2019 3:40PM in Hyperion Essbase (MOSC) 4 commentsAnswered

Hello All,

We have an ASO application where we have  requirement that level zero members should be mulitply the value according to formula and the parent member should be summed .for Example

in the below formula it shows for the level zero members it is should perform cu cumulative * Production units for the extended cost up and for the parent level it should sums the level 0 data to the Extended cost up

case

when

islevel(period.currentmember,0) and

islevel([Destination].currentmember,0) and

islevel([ModelYear].currentmember,0) and

islevel([Version].currentmember,0) and

islevel([Parts].currentmember,0) and

islevel([Supplier].currentmember,0) and

islevel([PMSCategory].currentmember,0) and

Tagged:

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