debugging isprompted problems

Bill S3

Are there any tools to see isprompted values or session metadata available in a report using javascript?

I have a number of pages on a dashboards that drill to common data, single key to single key.  The drills go a report based on one subject area to another and the common column is in the same folder and has the same name in every subject area.  Some of these navigations work fine and other do not pass a value.  I'm trying to figure out the best way to debug.

Thanks

obiee 12.2.1.3

Gianni Ceresa

You can look at the queries generated in the logs as it will contains both the logical query and the physical one, so there you see exactly what values are used instead of "is prompted".

It isn't in javascript as logs are in log files, but still give you a good idea. I guess there is still a view in the analysis which also shows you the logical query or something like that but can't remember if it's useful, never really used it.

For the "session metadata" not sure what you mean by that. If you are after all the session variables set for a given user session there is a piece of code listing them which is inside Sample Application and you can also find .... can't remember the link. @Christian Berg didn't you post it on GitHub or your blog or somewhere?

Robert Angel

Like this for viewing variables on the page; -

https://blogs.oracle.com/exalyticsobiee/how-to-pass-presentation-variable-to-the-title-view-using-dashboard-prompt

Robert Angel

Show sql view is also useful, as well as catching the values in a presentation variable and displaying in title view.

Prompt area on analysis will interfere with drill in 'is prompted'

[Deleted User]

Yes. The gist is here: https://gist.github.com/Nephentur/d539ac2191ad435f67674ff0cb374643

Bill S3

This helped by figure it out.  In one of my subject areas I had a case issue with 1 word in the column name...... :-(