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

How to take level zero export of dense dimension

Received Response
edited Aug 2, 2018 2:36AM in Essbase 13 comments


How to take level zero export of dense dimension



I would like to take the level zero export of my account dimension. If we use DataExportLevel LEVEL0 in options,  it takes export for all the level zero sparse blocks combination which contains all cells in that block.  So, my query here is how to limit the cells in the block?

I tried it using fix statement as  FIX( Relative("Accounts",0), Year, Period) and ran the script. But still, it exports the higher level members in the account. Even my period is dense. But as I have fixed my month, it works only for my month. And not working with my account and simply ignore the fix on the script.

Howdy, Stranger!

Log In

To view full details, sign in.


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