Problem using MODIFY SCRIPT
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.
Kranthi Kumar 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,