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

Report Writer - Extracting Level 0, but Only Those that are Input

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

Summary

Report Writer - Extracting Level 0, but Only Those that are Input

Content

We have an ASO cube and I want to export level 0 accounts, but only those that are input (not those with formulas attached).  Is that possible?  I tried <DIMBOTTOM, but it pulls level 0 accts with formulas attached and it also cannot be narrowed down to only pull level 0 for a particular member of the account dimension.  I get an error when I try using <LEAVES saying 'LEAVES command has an invalid member which is attribute/calculated/dynamic member'.  The account that I used with LEAVES is a parent member of the account dimension.  I tried <LINK (LEV0,Account AND <DESCENDANTS("OPEX")),

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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