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 exclude intersections of different dimensional members

Accepted answer
edited Nov 8, 2022 12:35PM in Planning 10 comments


How to exclude an intersection of different dimensions within a FIX statement? see example below

Content (required):

Calc Script:

In the FIX Statement is the whole P&L structure (Account) and the whole Group (Entities) via IDescendants selected.

Now I would like to add an EXCLUDE command and specify a couple of accounts and entities which shall not be calculated/copied. However, EXCLUDE removes all intersection where at least one specified member is included. I only want to exclude those intersections where the combination of the specified members appears.

Simplified example:

EXCLUDE (Entity 2 , Account B) -> the row of Entity 2 and column of Account B is ignored.

Howdy, Stranger!

Log In

To view full details, sign in.


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