Hyperion Essbase (MOSC)

MOSC Banner

@sumVs@sumrange

edited Apr 24, 2015 9:12AM in Hyperion Essbase (MOSC) 1 commentAnswered

Hi,

first of all i want to wish you merry Christmas and a happy new year.

Product Hierarchy

G1 product
G2 100
G3 100-10,100-20,100-30

@sum (Sales, product)
Sales ->100-10 =100
Sales->100-20=200
Sales->300-20=300

The values should display Sales->100 =600 and then it has to roll up to top. Sales->product=600
@sum (Sales, Product)--> 600 and I am writing this values to budget sales but not going why?
Budget->Sales=@sum (Sales, product);

Q2) @sum (Sales, product) Vs @Sumrange (Sales, Relative (product, 0)
are these both the functions will return same values or not?

As per above equation(my assumption) @sum

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