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

Remove shared members from XRANGE

Received Response
62
Views
3
Comments
edited Oct 10, 2019 9:50AM in Planning 3 comments

Summary

@REMOVE in @XRANGE not working as expected

Content

Hi experts,

we have the following custom calculation which counts the members of Period dimension in a given range:

@XRANGE(
@CURRMBR(ContractYear)->@CURRMBR(Period),Year->Period)

The second part of the XRANGE function is always a fix value based on variables. The issue comes because there is a new set of shared members inside the Period dimension (new hierarchy in blue):

Period

|_ Year Total

    |_ Jan

    |_ Feb

    ....

    |_ Dec

|_ Year Total_Quarter

    |_Q1

        |_ Jan (Shared)

        |_ Feb (Shared)

          ....

    |_Q4 

       ....

        |_ Dec  (Shared)

Now, the custom calculation adds 12 members on the XRANGE function everytime the year changes:

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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