Not able to pass OBIEE prompt's All Values to BI Publisher parameter and report

3323115

Hi,

I am trying to pass dashboard prompt values to the BI Publisher parameter where query is in teradata.

It's working for single value for it's not picking "All Column Values" means the dashboard prompt passes one value to the BIP report , but it doesn't pass all values.

OBIEE Dashboard Prompt --> 1)Created prompt for MasterID, selected "All Column Values" choice in prompt

2)defined presentation variable exactly like BIP parameter i.e. pvar_masterpwrid

3) In the BIP report, for pvar_masterpwrid parameter, selected option of "text field contains comma separated values", also in default values, provided (All Column Values)

4)In the data model query, defined the following where clause which I found on one of the blogs which & data model query parsed successfully,but it doesn't pick all values from OBIEE prompt.

(rd.rltn_name in (:pvar_mastername) or '(All Column Values)' in (:pvar_mastername || '(All Column Values)')).

In other project, there is a different where condition which is working fine there

WHERE ((('(All Column Values)') in (:pvar_masterpwrid) and 1 = 1) or (('(All Column Values)') not in (:pvar_masterpwrid) and rd.rltn_pwr_id in (:pvar_masterpwrid)))

But when I provide this where clause referred from other project in my data model query , it fails to load. My query is in teradata, I am not sure about other data model.

It would be great if there is any suggestion on my problem. My end goal is to get all column values from OBIEE dashboard prompt & pas it to BI Publisher.

Thanks

Ram

SriniVEERAVALLI

Are you still looking for solution? let me know based on that I can help you.