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
Skip to content
  • Register

    • Want to exclude 9* Accounts from Source Filter

    in Financial Consolidation and Close 1 comment

    Hi Everyone

    In GL to FCCS Data Integration we want to exclude 9* Accounts from Source Filter, We don't want to Exclude through Mappings as we don't want this data in Workbench (We have Flat Hierarchy in GL where we don't have separate parent for 9*). Does anyone have any idea how can we do this ? We have tried following but it is not working. 

    (@Remove(@ILvl0Descendants("[Account].[All Account Values]"),@list("[Account].[All Account Values].[911001]","[Account].[All Account Values].[912001]","[Account].[All Account Values].[913001]")))

    Tagged:

    Howdy, Stranger!

    Log In

    To view full details, sign in.

    Register

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