Skip to Content
0
Mar 24, 2020 at 06:28 AM

Hardcode %DIM_SET% from a data manager package

212 Views

Hi,

Does anyone know how to hardcode any of the %DIM_SET variables from within a Data Manager package? I don't want to hardcode the script logic executed with the package because it is big. I want to create multiple packages with a prompt for ENTITY and dimension AREA hardcoded to different values for each package. For example:

Package 1:

PROMPT(SELECTINPUT,%ENTITY%,,,"%ENTITY_DIM%")

INFO(%AREA_SET%,A101,A105)

Package 2:

PROMPT(SELECTINPU,%ENTITY%,,,"%ENTITY_DIM%")

INFO(%AREA_SET%,A234,A235)

Using INFO(%AREA_SET%,<multiple values>) does not work. I also tried the solution described here, using TASK(Execute formulas,FORMULASCRIPT,*FUNCTION %AREA_SET%=A101,A105) but the %AREA_SET% is not recognized as a variable.

Using REPLACEPARAM doesn't work either because of that only works for BPC NW. I'm working with BPC MS.

Any ideas on how to hardcode dimension members from a package?