data package with a dynamic selection

[michele_medaglia5]

Hi Bpc Friend

We have a data package with the selection for the dimension Time hard coded.

I have been asked if it is possible to have a dynamic selection but not imputable from the user, something like this, using a property of the dimension Time

*SELECT(%MYTIMEFX%,ID,TIME,BUD_FCST_DRS=IN_BPF).

is something achievable?

[former_member186338 · Accepted solution]

Yes, why not?

*SELECT(%MYTIMEFX%,ID,TIME,BUD_FCST_DRS=IN_BPF).

Will fill the variable %MYTIMEFX% with member id's having property BUD_FCST_DRS=IN_BPF.

[michele_medaglia5 · Accepted solution]

great

I thought that was only for a script logic

Thanks

[former_member186338 · Accepted solution]

Not clear!

But *SELECT(%MYTIMEFX%,ID,TIME,BUD_FCST_DRS=IN_BPF). is a script logic statement...

Please explain exactly what you mean!

[michele_medaglia5 · Accepted solution]

at the moment in the data package the selection for the dimension time is fixed, I would like to be dynamic reading the time from the dimension

[former_member186338]

I see that your DM package is running script logic. In this case just fix the scope in script logic aND don't fix anything in advanced script.

We have to use filter in the adanced script only when DM package is not running script logic (COPY,MOVE,CLEAR...)

[michele_medaglia5]

thanks Vadim

but is ok to have a select input for the dimension entity even if we run a script logic?

[former_member186338]

Sorry, but I don't understand what do you mean!

For sure you can use SELECTINPUT to allow user to select entity members. Then in the script %ENTITY_SET% will contain the selected members (if ENTITY is you real name).

[former_member186338]

It's a different story!

You can create a filter and use it in the advanced dm script!

But the filter is user dependent.

[former_member186338]

Please read https://archive.sap.com/discussions/thread/3702142

[michele_medaglia5]

thanks Vadim

[former_member186338]

But I have to repeat - this filter has to be created for each user that will be running the DM package individually 😞

[michele_medaglia5]

ok so it could be better to leave the dimension Time imputable or calling a script with this filter

*SELECT(%MYTIMEFX%,ID,TIME,BUD_FCST_DRS=IN_BPF).

what do you think?