Hey Zahid Here is an example query that will return some user information. SELECT :xdo_user_name AS USER_NAME, :xdo_user_roles AS USER_ROLES, :xdo_user_ui_oracle_lang AS USER_UI_LANG, :xdo_user_report_oracle_lang AS USER_REPORT_LANG, :xdo_user_ui_locale AS USER_UI_LOCALE, :xdo_user_report_locale AS USER_REPORT_LOCALE,…

Can you just send them to /analytics/ and OBIEE will sort the rest out based on the portalpath variable?

Pretty sure all I've ever had to do was get it out of my local cache. So if it hasn't updated I'll just have the css file open and hit ctrl-f5 on it and then go back to OBIEE and refresh

This doesn't really have anything to do with OBIEE and I'm pretty sure is something that can be easily googled. https://www.google.com.au/search?q=execute+stored+procedure+from+javascript

That is referring to Visual Analyser

oops yeah the X/X wouldn't work.. didn't really think enough about that. How about X/X*X. Was just thinking of an alternative to a CASE. If X=0 then X/X*X should return null and otherwise X? No idea whats faster

Wonder how the CASE statement would compare to if (assuming column is X) you changed formula to X/X and then used the number format #,#.00;-#,#.00;- So X/X would return null for x=0 and then be formatted as - </random thought>

Thinking out loud here. Could you use javascript to change a prompt (perhaps in a hidden section) which had a presentation variable attached. Hoping changing the selected value of a prompt with JS would kick off a refresh of the analyses.

When you edit the dashboard, next to the cross to remove an analysis there is an 'xyz' button to edit some properties. Selecting Report Links and ticking Refresh will allow you to add the refresh link under the analysis. You can also make the change for all analyses in the dashboard options.

Maybe it is just going to the cache only and not hitting the DB. Try clearing/disabling the beforehand. https://gerardnico.com/wiki/dat/obiee/obis/query_cache_purging

Yeah sorry forget to mention PDF. Was thinking it might also let me pull into Smartview as well. I seem to have fetish for trying to beat the system when it comes to OBIEE

Are you trying it on an actual dashboard rather than just the prompt editor? Don't hold me to it but from memory you won't see the values refresh unless it's on a dashboard

From memory the SampleApp implements this : https://bl.ocks.org/mbostock/4061961 I prototyped a version of that here but the business here weren't that keen on it (actually some were very keen and some were not at all). I'm still a big fan of the chart and the amount of information it can contain in one line though. I like…

It'll be a combination of padding and cellspacing and perhaps widths/stretching. All overridable through CSS.

Have you got any hidden pages? When I first tried 12c I noticed a bug with dashboards occurring if you had hidden pages located anywhere except as the last pages. I can't remember exactly what was happening now to be honest but I think it was other pages not appearing.

I have done this before, originally inspired by Pop up effect in OBIEE using jQuery ClearPeaks Blog but used qTip2 instead of Tipped

Oracle has updated info at https://support.oracle.com/epmos/faces/DocContentDisplay?id=2186968.1

Or what about just using variables?

You can view most of the logs in Enterprise Manager in the log viewer if you can access it. The reality is you're not going to be able to do much without the access.. hopefully you can get into EM.

Nope sorry. See the first part of my message.