DMP LInk

[nicky_hays]

Hi,

How can I create a dynamic filter to select all the base members of a particular hierarchy in a DMP Link which I am scheduling to run? I am using the data manager package based on process chain /CPMB/EXPORT_TD_TO_APPL to export transactional data.

When I select the base members of a particular heirarchy in the DMP link, BPC brings all the base members and the list is static. Now after I have scheduled the package to run and a new base member is added to the hierarchy later then this new base member does not get picked up.

For example if my Product Hierarchy is like the following, and I select the base members for P1 while setting up the prompts in the DMP link then it brings A,B,C,D. After I have scheduled it, supposed a new base member E is added to P2 then the scheduled DMP Link will not pick up E until I manually go and set the prompt again.

P1

     P2

          A

          B

     P3

          C

          D

P4

...

How can I select the base members with a dynamic filter?

Sincerely,

Nicky

[Former Member]

Hi Nicky,

Is this a custom package or standard package?

If you are using custom package then you can use script logic to determine all the basemembers of a top node.

Andy

[nicky_hays]

Hi Andy,

It is a standard package. Even if it I copied it and made it custom then also where can I specify the script logic file.

PROMPT(SELECT,,,,"%DIMS%",0)

PROMPT(MEASURELIST,%MEASURES%,"Please select measures")

PROMPT(TRANSFORMATION,%TRANSFORMATION%,"Transformation file:",,,Import.xls)

PROMPT(TEXT,%FILE%,"Please enter an output application file",)

PROMPT(RADIOBUTTON,%ADDITIONINFO%,"Add other information(Environment,Model,User,Time)?",1,{"Yes","No"},{"1","0"})

INFO(%DIMVALUE%,E=24)

INFO(%TEMPNO1%,%INCREASENO%)

INFO(%TEMPNO2%,%INCREASENO%)

INFO(%SELECTION_KEYDATE%,)

TASK(/CPMB/APPL_TD_SOURCE,SELECTION,%SELECTION%)

TASK(/CPMB/APPL_TD_SOURCE,DIMENSIONVALUE,%DIMVALUE%)

TASK(/CPMB/APPL_TD_SOURCE,MEASURES,%MEASURES%)

TASK(/CPMB/APPL_TD_SOURCE,OUTPUTNO,%TEMPNO1%)

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

TASK(/CPMB/EXPORT_TD_CONVERT,INPUTNO,%TEMPNO1%)

TASK(/CPMB/EXPORT_TD_CONVERT,TRANSFORMATIONFILEPATH,%TRANSFORMATION%)

TASK(/CPMB/EXPORT_TD_CONVERT,SUSER,%USER%)

TASK(/CPMB/EXPORT_TD_CONVERT,SAPPSET,%APPSET%)

TASK(/CPMB/EXPORT_TD_CONVERT,SAPP,%APP%)

TASK(/CPMB/EXPORT_TD_CONVERT,OUTPUTNO,%TEMPNO2%)

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

TASK(/CPMB/TD_APPL_SERVER_TARGET,INPUTNO,%TEMPNO2%)

TASK(/CPMB/TD_APPL_SERVER_TARGET,FULLFILENAME,%FILE%))

TASK(/CPMB/TD_APPL_SERVER_TARGET,ADDITIONALINFO,%ADDITIONINFO%))

[Former Member]

Hi Nicky,

Custom package as in using an LGF file, in the LGF file you can read base members.

Andy

[former_member186338]

Hi Nicky,

The only thing you can do is to create a named filter by property and use it in the member selection... This filter will be valid for a single user...

Vadim

[nicky_hays]

Hi Vadim,

Is there any way I can retrieve the base members for a multi tier hierarchy using properties (dynamic filters) such as HLEVEL, PARENTH1 etc or do I have to create a custom property to mark all the members that I want to bring in?

Sincerely,

Nicky

[former_member186338]

Just try to experiment yourself!

Vadim