JVM settings & JDK version
–64 bit JVM/JDK (on a 64 bit OS)
–JDK version 1.6 (update 2) or higher
Memory (RAM for the JVM)
–8 GB on 64 bit JVM is recommended for large, high volume use
–2 GB on 32 bit OS suitable for small to mid volume deployments (2gb limitation for JDK on win OS)
Storage
–Repository: Varies. 30 GB Hard disk space (must be shared for cluster)
–Temp Space: 20 GB (for document processing) not shared
–64 bit JVM/JDK (on a 64 bit OS)
–JDK version 1.6 (update 2) or higher
Memory (RAM for the JVM)
–8 GB on 64 bit JVM is recommended for large, high volume use
–2 GB on 32 bit OS suitable for small to mid volume deployments (2gb limitation for JDK on win OS)
Storage
–Repository: Varies. 30 GB Hard disk space (must be shared for cluster)
–Temp Space: 20 GB (for document processing) not shared
Hi,
ReplyDeleteI have a question about BI Publisher.
I have a multi-select parameter in the data model. How can I pass it to the Event Trigger PL/SQL function?
I tried to defined the parameter as varchar2 in the package. Only single selection works.
Thanks
when you pass multiple values from single parameter,then that parameter will become multiple bind parameters and placed into where clause.
ReplyDeletefor example, if you select two values for parameter Param_X ,then it will become two bind parameters like Parm_x110,Param_X111 etc.
write your package logic in that way to receive values from publisher.
Regards,
Aravind
I tried several approaches to handle multi-select parameters and finally found a solution.
ReplyDeleteIt is okay to define the parameter as varchar2. The tricky part is dealing with the string format.
If only one item is selected, say 'Item1', the parameter is the original string value, Item1.
If multiple items are selected, say 'Item1', 'Item2', the parameter would be 'Item1','Item2', additional comma and single quotes are added.
Thanks, Aravind. Your posts are really great!