Data Manager package adding additional prompt selections

[Former Member]

We have been working on adding script logic to calculate some of our KPI's and I would like to be able to select our Productline within the promot of the data manager package but I can't figure out what I need to update within the data manager package to allow this as part of the prompt selection.

Currently this is our script with PRODUCTLINE as part of the script:

     *XDIM_MEMBERSET ACCOUNT = BAS(REV_SUB_MNTHLY),BAS(REV_SUB_ANNUAL),BAS(REV_SUB_METERED),BAS(REV_SUB_MULTI)
     *XDIM_MEMBERSET AUDITTRAIL= INPUT
     *XDIM_MEMBERSET COMPANY= C_100
     *XDIM_MEMBERSET COSTCENTER=CC_299_0
     *XDIM_MEMBERSET FLOW=NOFLOW
     *XDIM_MEMBERSET INTERCO=NON_INTERCO
     *XDIM_MEMBERSET PARTNERCC= BAS(PCC_TOT)
     *XDIM_MEMBERSET PRODUCTLINE=BAS(SSB)
     *XDIM_MEMBERSET RPTCURRENCY=LC
     *XDIM_MEMBERSET MEASURES=PERIODIC

     *WHEN ACCOUNT

     *IS BAS(REV_SUB_MNTHLY),BAS(REV_SUB_ANNUAL),BAS(REV_SUB_METERED),BAS(REV_SUB_MULTI)

     *REC(FACTOR=12,ACCOUNT="STAT_10160")

     *ENDWHEN

     *COMMIT

Prompt selection of data manager package, in attachments.

I figured out where I can add ENTITY(our COMPANY dimension) to the package selection so I can remove that from our script above but can anyone point me in the right direction for adding a selection for our PRODUCTLINE? We want this package to be able to run based on different selections and sometimes we might not need to update for all products. Since this is a User Defined dimension I didn't know if %DIMS% needed to be used so that is why you currently see that selection within the screen shot.

[Former Member]

I was able to get it to work. I continued making different adjustments and finally got the package to run according to the needs. The attached screen shots show what it looks like now.

Thanks for the help

[damovand]

Hi,

You can add many dimensions to your selection in one statement with the following format.

PROMPT(SELECTINPUT,%SELECTION%,,,"DIMNAME1,DIMNAME2,DIMNAME3")

Instead of entering the prompts through the GUI, click the advanced button and add it manually to the script. In your case, assuming you still want to keep ENTITY AND COMPANY the selectinput will be like below

PROMPT(SELECTINPUT,%SELECTION%,,,"ENTITY,COMPANY,PRODUCTLINE")

I hope this is helpful information.  Please let me know if you have further questions.

Best Regards,

Leila

[Former Member]

Leila,

Thank you for the information. I have updated the package through the advanced button as you suggested. The options are still not appearing in the package. See attached screen shots.

What else am I missing?

Thanks,

Michelle

[Shrikant_Jadhav]

Hi Michelle,

Are you sure that provided screen shots are of same advance script and pop up.

As suggested by Leila, it should work.

For reference go through the below link

BPC 7.5 NW - DIM UserDefined in PROMPT when usi... | SCN

Shrikant

[damovand]

Hi,

Please make sure that you save the changes, by clicking Save all the way.

[Former Member]

Shrikant , yes those are the screen shots based on what was suggested by Leila.

Leila, I am saving this all the way through and still get the same prompts through the data manager package. Does something need to be updated within the script logic to account for these changes?

We are on 10 NW I see that the link provided above is for 7.5 does the same code work for both?

Thanks,

Michelle