Skip to Content

data package with a dynamic selection

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?

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Best Answer
    Nov 16, 2016 at 01:50 PM

    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.

    Add comment
    10|10000 characters needed characters exceeded

  • Nov 16, 2016 at 04:13 PM

    It's a different story!

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

    But the filter is user dependent.

    Add comment
    10|10000 characters needed characters exceeded

  • Nov 16, 2016 at 05:31 PM

    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...)

    Add comment
    10|10000 characters needed characters exceeded

    • 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).