Skip to Main Content

Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Dynamic Parameter with Multiple Values takes only first value??

ocp9iMar 13 2006 — edited Nov 14 2006
I have a report with the following condition:

some_column LIKE :par

here :par is set to accept multiple values at run time. Now for each record i wanted to show the some_column data group it belongs to, for that i created a calculation & set the source to :par. I am assuming that the value of :par will change for each record, that's how it works. But the result i get is surprising, it shows me only first value.
E.g. if i enter values as: 'VAL1','VAL2','VAL3'

now the record set is correct but my calculation fields shows me only first value i.e. 'VAL1' for each row, although it should be different for records where some_column has 'VAL2' OR 'VAL3'.

I am using Dis 4.

Can anyone give any idea, what's happening here??
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Dec 12 2006
Added on Mar 13 2006
15 comments
1,184 views