Skip to Content
0
Sep 18, 2014 at 03:35 PM

Modify package: Prompt Text and Pass to Scripts

215 Views

Hi Experts,

I'm trying to setup a package list to allow users enter a value (A,B,C) of a Dimension [COSTCENTER] Property [BU] and then pass this value to the script as scoping/filter, but have some issues. We are using NW10, SP15.

The Prompt setting is: PROMPT(TEXT, %BU%, "Select Business Unit to run",,,,,")

I have two script scoping and both of them have some issues:

Scoping 1 uses Select function; This one works, but it works on ALL COSTCENTER, i.e. if I enter "A", the calculation is performed for ALL COSTCENTER member

*SELECT(%BU_SEL%,"ID","COSTCENTER",BUSINESS_UNIT=%BU%)

*XDIM_MEMBERSET COSTCENTER=%BU_SEL%

Scoping 2 doesn't pass the script validation. The error is "No member found in Dimension "COSTCENTER" for condition "CALC"="N". But there are base members with the property properly tagged.

*XDIM_FILTER COSTCENTER = [COSTCENTER].properties("BU")="%BU%"

Any suggestion? Thanks in advance.

Ben