How to exclude a node from the Hierachy

[Former Member]

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

[former_member186338]

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

[former_member186338]

If you want to exclude from scope - then look on the working sample from my system:

*XDIM_MEMBERSET INACCT AS %R0%=BAS(202020202) //total net sales

*XDIM_MEMBERSET INACCT AS %R1%=BAS(20202020206) //specific type of sales 1

*XDIM_MEMBERSET INACCT AS %R2%=BAS(20202020207) //specific type of sales 2

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

*XDIM_MEMBERSET INACCT=%R%

//result - all base members of total net sales excluding specific type of sales 1 and 2

Vadim

[Former Member]

//%TIME_SET% = 2015.02

*SELECT(%Y%,[YEAR],TIME,ID = %TIME_SET%)

*XDIM_MEMBERSET TIME = TMVL(-12,%TIME_SET%),TMVL(-12,%Y%.12),%TIME_SET%

*XDIM_MEMBERSET ENTITY = %ENTITY_SET%

*XDIM_MEMBERSET RPTCURRENCY = LC

*XDIM_MEMBERSET ACCOUNT = BAS(REVENUE),BAS(VARIABLECOSTS),BAS(FIXEDCOST)

*XDIM_MEMBERSET CATEGORY = %CATEGORY_SET%

*XDIM_MEMBERSET AUDITTRAIL = BAS(AuditTotal)

*FOR %SRC% = BAS(REVENUE),BAS(VARIABLECOSTS),BAS(FIXEDCOST) AND %DEST% = RF00001,RF00002,RF00003

*WHEN ACCOUNT

*IS %SRC%

*WHEN TIME

*IS TMVL(-12,%TIME_SET%) //2014.02

*REC(EXPRESSION = -%VALUE%,ACCOUNT = %DEST%,TIME = %TIME_SET%) //negative!

//*ELSE //2015.02,2014.12

*IS TMVL(-12,%Y%.12),%TIME_SET%

*REC(EXPRESSION = %VALUE%,ACCOUNT = %DEST%,TIME = %TIME_SET%)

*ENDWHEN

*ENDWHEN

*NEXT

This  is my script which is working.However the business want me to exclude the highlighted nodes in red from Fixed cost

This is for Netweaver 10.0

[former_member186338]

Then look on my answer - it was tested and working correctly.

Replace FOR/NEXT loop with 3 sections of code (anyway FOR/NEXT will do the same!)

Vadim

[former_member186338]

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%

[former_member186338]

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

FIXEDCOST

  SOMELEVEL1

    SOMENODE1

      BAS1

      BAS2

    SOMENODE2

      BAS3

    EMPLOYSAL

      BAS5

      BAS6

      ...