Recently I was asked how to asked your own JavaScript from the OBIEE dashboard. I actually fairly simple.
Step 1: Add your script to Common.JS (this usually file is found in the {OracleBI}\web\app\res\b_mozillahere is an example:
// MY Stuff
function obi_popup()
{
alert("Hello World")
}
Step 1b: If you are using OC4J sync the file with the one in {OracleBI}\oc4j_bi\j2ee\home\applications\analytics\analytics\res\b_mozilla
Step 2: restart the presentation server and you webserver.
Step 3: Add the execution code to your dashboard:
<input type="button" onclick="obi_popup()" value="Click Me!">
Don't forget to check the Contains HTML Markup!
Step 4: Save your dashboard page and test....
Till Next Time
Hi John,
ReplyDeleteWe have a requirement where we have to navigate between reports using javascript and Go URL.
But our table and column names contain spaces, so its only navigating but not passing values to the other report.
Can you please help us out with this?
Hi
ReplyDeleteDid you try replacing the spaces with %20 ?
regards
John,
ReplyDeleteDo you know if it is possible to update a filter on Dashboard report by clicking a value from another Dashboard report. If it's doable, I am guessing it would a matter of formatting a value in HTML that calls a custom JavaScript that would update a Presentation Variable "on-click" of the value selected. I can give you more background it the above description is a little fuzzy.
@Anonymous,
ReplyDeleteWouldn't that overcomplicated that? How about playing around with drillpaths?
Regards
John
hi,
ReplyDeleteis it possible to add survey forms in BIEE dashboards? we can use writeback as a workaround. but, we are trying to explore using html and javascript to create surveys for users to fill up. Since we couldn't create radio buttons or listbox using writeback, maybe we can use html and javascript instead. would that be possible? thanks
@Anonymous,
ReplyDeleteYes, but please use OBIEE for what it is intended. Most incompagny portal have far better capabillty for that.
regards
John
Hi John,
ReplyDeleteThe "OBIEE Executing your own Javascript" post is a good one. I am looking whether is it possible to capture the logical sql of an OBIEE report.
Why don't you add the SQL view to your report, hide it and add a script to read the idLogicalSqlCell
ReplyDeleteRegards
Hi John,
ReplyDeleteThis is what I was exactly looking for. But I donot know how to call the idLogicalSqlCell with in the function. Also, I have noticed that we can hide the columns in the request but the not the View (i,e Logical Sql View) in the compound layout.
Please provide details how to use the idLogicalSqlCell function.
Thanks in Advance
Siva
@Siva,
ReplyDeleteIt's seems you already got your answer from Joe:
http://forums.oracle.com/forums/thread.jspa?messageID=4028795�
Regards
Where could I add a jquery script definition so that I could write jquery? Is this possible?
ReplyDeleteThe reason I want to do this is because I have a requirement to change the colors of the tabs (it is not going to be fun at all since there is just the 2 different classes... it would just be much easier with jquery). Has anyone done this yet? Any tips?
Ok... so, I overlooked the fact that I could just drop in a jquery script definition right inside a Text section in an OBIEE dashboard. My main question is how feasible it is to have say 10 tabs, and color 3 blue, 3 red, 3 green, and 1 purple. I understand the tabs on the dashboard deal with images, so I am fine creating different shaded images, but it seems tricky since there is only 2 main classes: TabDimCell, TabHiCell (and the dang separators of course). Thanks in advance.
ReplyDeleteJohn,
ReplyDeleteI am trying to add JS on the GO button of the prompt. I am not able to access the button. I actually want to add JS to make particular prompt mandatory.
Hi John,
ReplyDeleteI have a scenario where i have multiple column selectors on the report and the 'Go' button for them is going to the right hand side cornor .Now is it possilbe to stack these column selectors vertically using JS?
Regards
Raj
Hi john, here is my question,
ReplyDeletei want show empty show empty dashboard initially. we have prompts in dashboard right. my requirment is when ever we click the go button it will show all the content in the report with out entering any prompt values.
can you please provide the solution for this. my client want this type of methde.
@sirish,
ReplyDeleteDo google for the scripting of Joe Betram, he is a master on manipluating the screen with JS.
regards
Hi - this is a great post, really useful. Thanks you..
ReplyDeleteI have a related problem and cannot find the answer. I want to call a session variable value from within a JavaScript function in the Common.js file. The reason for this, is I want the user to be redirected to another site, and the group session value to be passed but not visible in the html or button/link properties. (It will link to a php which will redirect based on the value in the URL).. I cannot get the javascript syntax right to take the 'nqsession.group' value. Is it possible?
Many thanks (anyone!)
Niamh, Dublin