You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Essbase BSO outline formula

edited Aug 2, 2018 2:36AM in Essbase 4 comments

Summary

Essbase BSO outline formula

Content

Hi,

I'm struggling for a long time with a not too complicated formula in a BSO outline.

First dimension is the Measures dimension.

It contains "overstock" and "depreciation".

For "obsolete stock" a formula is used on product level 0. (dynamic calc)

Product is a sparse dimension with complete hierarchy containing several levels.

The formula which works fine on product level 0 is the following:

IF(@ISLEV(Product,0))

IF ("depreciation"  > 0)
"obsolete stock" = "overstock" ;
ELSE
"obsolete stock" = 0 ;
ENDIF

ENDIF

However, for upper levels I don't succeed to find the right one because it does not automatically aggregate level 0. I tried with SUM and SUMRANGE.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!