Hardcode %DIM_SET% from a data manager package

[Rene_Moreno1]

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?

[Former Member]

Please refer a similar article. It may be of help.

https://answers.sap.com/questions/11537387/hardcode-dimension-members-in-datamanager-package-.html

Thanks!

Ranjeet

[former_member186338]

ranjeetinusa

Sorry, but your link is pointing to my answer about BPC NW and not about BPC MS.

Absolutely different approach...