Script and default help

[Former Member]

Hi expert

Im in trouble,

can you help on this ?

*XDIM_MEMBERSET CATEGORY = %CATEGORY_SET%
*XDIM_MEMBERSET AUDITTRAIL = Input
*XDIM_MEMBERSET CUSTGRP = CG_NA
*XDIM_MEMBERSET CUSTSALES = CS_NA
*XDIM_MEMBERSET rptcurrency = LC
*XDIM_MEMBERSET material = %MATERIAL_SET%
*XDIM_MEMBERSET plant = <ALL>
*XDIM_MEMBERSET salesdis = <ALL>
*XDIM_MEMBERSET salesoff = <ALL>
*XDIM_MEMBERSET salesorg = <ALL>
*XDIM_MEMBERSET time = %TIME_SET%
*XDIM_MEMBERSET INDICATORS=I001,PMF
//
*WHEN TIME
*IS %TIME_SET%
*WHEN CATEGORY
*IS %CATEGORY_SET%

*WHEN MATERIAL
IS %MATERIAL_SET%
*WHEN INDICATORS
*IS I001
*REC(EXPRESSION=%VALUE%*([INDICATORS].[PMF]),INDICATORS=PL1011)
*ENDWHEN
*ENDWHEN
*ENDWHEN
*ENDWHEN
*COMMIT

-> If set material in the scope to <ALL> , default take a while, and do not calculate nothing

-> in the case above, logic does not pass validation -> material_Set not recognized

Tks for your help,

[Former Member · Accepted solution]

Ok, I correct the logic : problem of member.

Now, How can I restrict the Scope to avoid long calculation in the default ?

Material is a big dimension

tks for your help

[former_member186498 · Accepted solution]

Hi Olivia,

have you tried with a *SELECT ?

Regards

     Roberto

[former_member186338 · Accepted solution]

Hi Olivia,

Please read my document:

In general it's not a good idea to change scope in default.lgf using XDIM_MEMBERSET...

You have to work with members sent by input form.

Can you explain the logic of your script:

What user enter

What have to be calculated

Where to be stored

Vadim

[Former Member · Accepted solution]

Tks a lot guy.

Always valuable advice from you