Skip to content

Instantly share code, notes, and snippets.

@rmoff

rmoff/notes.md

Last active November 19, 2015 19:32
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save rmoff/7e88aa213e86d3e4cdaf to your computer and use it in GitHub Desktop.
Save rmoff/7e88aa213e86d3e4cdaf to your computer and use it in GitHub Desktop.
Download ZIP
OBIEE Dashboard - Create Prompted Link - not all values applied / variable prompts don't work when Currency Prompt present
Raw
notes.md

If you created a Prompted Link in OBIEE and there is a currency prompt, there is a problem with the generated URL.

Details of [prompted links can be found here], with the pattern being a set of fields defining a column or variable to be set. The usual pattern is along the lines of :

col1=foo,val1=bar,var2=bing,val2=bong

To set the filter / variable values being passed.

Eg:

http://server:7780/analytics/saw.dll?Dashboard&PortalPath=%2Fshared%2F07.%20Semantic%20
Layer%20Design%2F_portal%2F7.10%20Logical%20Modeling&Page=Currency&Action=Navigate&
col1=foo,val1=bar,var2=bing,val2=bong

The problem is that the currency prompt specifies the val key, but no value, which breaks the URL (because the request parameter has a name but no value) and causes OBIEE to (understandably) ignore the rest of the values being passed in the URL:

http://server:7780/analytics/saw.dll?Dashboard&PortalPath=%2Fshared%2F07.%20Semantic%20
Layer%20Design%2F_portal%2F7.10%20Logical%20Modeling&Page=Currency&Action=Navigate&
col1=AUD&op1=currencySelectorOp&val1=&col2=foo,val2=bar

(note that before &col2 there is no value specified after val1=)

Solution - remove the currency from the prompted URL, and be sure to renumber the remaining values.

(For Google hits : MaxPromptedURLParams has nothing to do with this, but with a long URL it could seem related - it's not)

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment