Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Problem using MODIFY SCRIPT

Hi all.

we are trying to implement an SSIS package that performs some SQL tasks, depending on the selection of members from the following dimensions : Account, Entity and Category.

In the Data Manager Dynamic Script (SAP BPC 5.0 version), we are using the following syntax (that worked on Outlooksoft 4.2 version) in order to allow selection of members from different dimensions:

PROMPT(SELECT,%UserSelection%,,"Select members :","Entity,Category,Time")

When we run the package, only the first dimension selection (Entity) window is presented.

If anyone could suggest the correct syntax for BPC 5.1 - or a workaround to solve this issue - we would really appreciate it.

Thanks.

Guido Giandonato

replied

Hi Guido Giandonato,

The syntax is correct.

Try this..If you leave the last parameter blank( Entity,Category,Time) by default it will prompt for Entity, Category,Time. or if your dimension names used are different from Entity,Category,Time, try using %Entity_dim%,%Category_Dim%,%Time_Dim%

Hope it Works,

Kranthi

0 View this answer in context
Not what you were looking for? Ask a question