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

Excluding one particular Level 0 account from Data Exchange export

in Financial Consolidation and Close 16 comments

Summary:


Content (please ensure you mask any confidential information):

We are exporting data from FCCS data exchange feature to a file. 

There is a requirement that we don't want Plug accounts in the file. We have tried conditions like "(@Remove(@ILvl0Descendants("FCCS_Total Balance Sheet"),@list("ELIMOTRREC")))" Also we have tried @Remove(@ILvl0Descendants("[Account].[FCCS_Balance Sheet].[FCCS_Total Balance Sheet]"),(@list("ELIMOTRREC"))) but we are getting error as Essbase Error(1260046): Unknown Member [Account].[@ILvl0Descendants("[Account].[FCCS_Balance Sheet].[FCCS_Total Balance Sheet] used in query. Is there a way I can exclude the Plug accounts from the Balance Sheet hierarchy?

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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