XDIM_MEMBERSET

[Former Member]

Dear Expert,

I have this very simple script. However it fails due to the large dimensions HCLIENT/HPRODUIT we have.

When user selects as %HCLIENT_SET% the total hierarchy, the script fails.

If the user selects a smaller node, script runs ok

*SELECT(%YEAR%, "[YEAR]","CATEGORIE","[ID] = 'BUDGETV0' ")

*XDIM_MEMBERSET CATEGORIE=BUDGETV0

*XDIM_MEMBERSET DEVISE_RPT=LC

*XDIM_MEMBERSET SITE_EXPEDITION=BAS(TOTAL_SITE_EXPEDITION)

*XDIM_MEMBERSET CODE_USAGE=CODE_USAGE_NA

*XDIM_MEMBERSET HCLIENT=BAS(%HCLIENT_SET%)

*XDIM_MEMBERSET HPRODUIT=BAS(%HPRODUIT_SET%)

*XDIM_MEMBERSET NATURE=VVQ03

*XDIM_MEMBERSET ORGANISATION=%ORGANISATION_SET%

*XDIM_MEMBERSET SOURCE_DONNEES=IMPORT_APS   

*XDIM_MEMBERSET TEMPS=BAS(%YEAR%.TOTAL)

*WHEN NATURE

*IS VVQ03

*REC(FACTOR=([NATURE].[PMV_REF],[SOURCE_DONNEES].[CALCUL],[SITE_EXPEDITION].[SITE_EXPEDITION_NA]),NATURE=VV010,SOURCE_DONNEES=CALCUL)

*ENDWHEN

If I change the memberset by:

*XDIM_MEMBERSET HCLIENT=<ALL>

*XDIM_MEMBERSET HPRODUIT=<ALL>

The script runs fine.

So my question is: is there a way, like in BPC MS, to use a *SELECT that will pick up BASE members of the user selection?

So I can leave the MemberSet to ALL and still filter the calculations.

Thanks in advance

Camille

[former_member186338]

Hi Camille,

*WHEN/*ENDWHEN will loop only base members anyway!

It means that the following statements are equivalent:

*XDIM_MEMBERSET HCLIENT=BAS(ROOT_NODE)

*XDIM_MEMBERSET HCLIENT=<ALL>

Please show some screenshots of error message!

By the way your WHEN/ENDWHEN is strange, you loop some scope, read data from another scope and write data to different destination. I don't understand the logic!

Vadim