Skip to Content
avatar image
Former Member

How to exclude a node from the Hierachy

Hi Experts,

I have a requirement to calculate Fixed Costs excluding 3 nodes under the Fixed Cost Hierachy.

*XDIM_MEMBERSET ACCOUNT =BAS(FIXEDCOST)

These must be excluded:

EMPLOYSAL

EMPLOYEXP

EMPLOYBEN

I am not sure how to exclude them.

Regards

Lawrence

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Oct 27, 2015 at 01:26 PM

    Can you show a screenshot of you account hierarchy? Is it like

    FIXEDCOST

      SOMELEVEL1

        SOMENODE1

          BAS1

          BAS2

        SOMENODE2

          BAS3

        EMPLOYSAL

          BAS5

          BAS6

          ...

    Add comment
    10|10000 characters needed characters exceeded

  • Oct 27, 2015 at 01:27 PM

    And what do you mean by "calculate" 😊 ???

    Add comment
    10|10000 characters needed characters exceeded

    • Code for your id's:

      *XDIM_MEMBERSET ACCOUNT AS %R0%=BAS(FIXEDCOST)

      *XDIM_MEMBERSET ACCOUNT AS %R1%=BAS(EMPLOYSAL)

      *XDIM_MEMBERSET ACCOUNT AS %R2%=BAS(EMPLOYEXP)

      *XDIM_MEMBERSET ACCOUNT AS %R3%=BAS(EMPLOYBEN)

      *SELECT(%R%,[ID],ACCOUNT,[ID]=%R0% AND [ID]<>%R1% AND [ID]<>%R2% AND [ID]<>%R3%)

      *XDIM_MEMBERSET ACCOUNT=%R%