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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Get the multi select prompt values to send as a parameter to Javascript

kiranhereJun 28 2013

Hi,

I am using OBIEE 10g.

I have 3 column prompts and one prompt is on Quarter column.

We have a  requirement to multi-select quarter values and have to send as a single parameter or separate parameters to a Java script. This Java script passing this string as parameter to one Java servlet.

Till now, we are using dropdown list for  quarter and we are sending as parameter to narrative view and passing to Java script as @1. Now the requirement is changed and we are checking for the possibility using multi select prompt and to pass values to Java script.

Suppose if we select Q1 and Q3, we should be able to send the parameter like Q1,Q2 or by any seperated.

or

we can send two separate values as parameters too and Java guys can handle it.

And with these values, we need to send some other values too and those values will be always same

I know OBIEE 10g presentation variable can hold single selected value at a time. In 11g Presentation variable can hold multiple values as Q1,Q2.

Is there any workaround for it.

Thanks in advance,

kiran

Comments

Isn't the legend in approx_percentile picture incorrect?

Shouldn't it be "Exact | Deterministic | Non-deterministic"?

Dude!

Isn't the legend in approx_percentile picture incorrect?

Shouldn't it be "Exact | Deterministic | Non-deterministic"?

You missed an 'n' in Loooooooooooooooog Names

Hendrik Schmidt

Hello,

for the link: "here's the script" I receive Page Not Found error

Non-deterministic results are around 5x faster than deterministic. And nearly 15x faster than exact results. So if an estimate is all you need, you can save yourself a lot of time using approx_percentile. If you want to check this for yourself, here's the script I used.

Evening,

I'm working on mvc projects using mean stack how can i integrate these projects without using mongodb. take for example using sql server..any tips will be helpful.

Peter Schlaeger

Hallo

I must worn everyone for trusting in Oracle Json Support. I have very very very painfull experiences  with Json in Oracle.

In 12.1 it took more than one year and lots of support calls before I was able to use it without bugs ( including full database crashes ).

And now I test on 12.2 and I am again back at the state  where I was in March 2016. Again the same bugs and the solution still not include in any windows bundle patch.

So I suggest that everyone should carefully test his Oracle Version and Patch level if it is capable of running Json without bugs before you decide to use Json.

blessed DBA

We are going start some project on this JSON So it is more useful for us

martin_olivia

The Oracle Database 12c is a high-performance, enterprise-class database.

1 - 7
Locked Post
New comments cannot be posted to this locked post.