Obtaining a member based on property in the DMP prompt

[Former Member]

Hi Experts,

I have multiple forecast cycles (F1 to F12) in my Category dimension and would like to dynamically bring the active one based on a property ISFORECAST=Y into the data manager package link. How can this be done in the DMP?

Regards,

Shariq

[former_member186338 · Accepted solution]

Can you provide more information:

What packages are used in the Package link, advanced scripts etc...

It's possible to fix a member based on property in the package advanced script!

Vadim

[Former Member · Accepted solution]

Hi Vadim,

It's a custom script logic which has been used in the package. I am aware of how script logic can be written to bring in the property dynamically but was wondering how could we do it in the advanced script section in the DMP itself.

Regards,

Shariq

[former_member186338 · Accepted solution]

If it's a logic script then it's better to select members by property inside script. You need to perform customization of advanced script only if it's a DM package to COPY, MOVE etc... - not script logic! Why are you talking about package link?

[former_member186338 · Accepted solution]

Sample advanced script for Clear package to Clear data based on filter (everything is fixed):

INFO(%SELECTION_KEYDATE%,)

TASK(/CPMB/CLEAR_CUBE,CHECKLCK,0)

TASK(/CPMB/CLEAR_CUBE,SELECTION,SELECTION,@@@SAVE@@@@@@EXPAND@@@|DIMENSION:PERIODS|[FILTER:NODY]|)

TASK(/CPMB/CLEAR_CUBE,DUMPLOADMODE,3)

TASK(/CPMB/CLEAR_CUBE,KEYDATE,%SELECTION_KEYDATE%)

TASK(/CPMB/CLEAR_COMMENTS_FOR_CLEAR,SELECTION,@@@SAVE@@@@@@EXPAND@@@|DIMENSION:PERIODS|[FILTER:NODY]|)

TASK(/CPMB/CLEAR_COMMENTS_FOR_CLEAR,ENABLETASK,1)

TASK(/CPMB/CLEAR_COMMENTS_FOR_CLEAR,CHECKLCK,0)

TASK(/CPMB/CLEAR_COMMENTS_FOR_CLEAR,CHECKJOUR,0)

The filter has to be previously defined in the DM package member selector:

Vadim

[Former Member · Accepted solution]

Hi Vadim,

I am talking about package link because I want to be using that DMP inside a package link with other DMPs' along with it, but whenever I set the prompt on the dynamic filter then even though if there is a change in the current forecast cycle in the property, it still shows the old value. The dynamic property doesnt work in the package link but only when I run the DMP indicdually and set that filter.

Regards,

Shariq

[Former Member · Accepted solution]

Hi Vadim,

I understand what you are saying now. First set the dynamic filter based on the property and then pass this in the DMP advanced script right?

DIMENSION:PERIODS|[FILTER:NODY]|)

[former_member186338 · Accepted solution]

Why do you want to use DMP inside package link? Please provide details... Why you can't simply use single DMP instead of link??

Can you list all packages in the link you want to execute?

[former_member186338 · Accepted solution]

Yes! I made it bold!

You can add other dimensions and members to fix a selection!

[Former Member · Accepted solution]

Those are custom script logics written and they have to be executed one after the other. So there are multiple DMP's and to make it easier for the user we wanted to put it in one package link.

[Former Member · Accepted solution]

Thanks Vadim. This really helps!

[former_member186338 · Accepted solution]

If you are talking about number of script logic files then package link is not a good idea! You can combine all lgf files into single lgf using *INCLUDE. Package link is used for other things!