Action links - passing presentation variable using Navigate to Web Page

aPsikus

Hi,

Can you please provide me tutorial or links how I can create own link with parameters using Navigate to web page option for Action links?

I would like to pass multiple values for presentation variable from dashboard prompt to target report.

Robert Angel

On your dashboard prompt you make the prompt populate a presentation variable; MyMonthPrompt; for example

On the target analysis you reference the presentation variable in the filter; -

Is Equal To / Is In '{MyMonthPrompt}{Jan-18}'

In my example the value in the second {} is the default value if nothing is passed.

If this is not what you are looking for then please provide fuller detail of your requirement.

Note also the scope of the presentation variable, global or page.

aPsikus

@Robert

First things first.

How to set scope of presentation variable? Is it based on the dashboard prompt scope?

You are right, I can set it '@{PV_NAME}{Default}', but it will pass only single value or string will be concatenated into 'A,B,C' which do not exist in data, and I would like to have it as 'A', 'B', 'C'.

I'm wondering if using Navigate to Web page (instead of Link to BI Content) and defining parameters, I can pass more than one string value in presentation variable. In other words, how to seperate them

Filter in the prompt has option multi selection and All values.

Robert Angel

Hi,

Yes, based on dashboard prompt scope.

On your multiple text values in a presentation variable see =>

https://www.obieetips.com/2014/05/obiee-11g-using-multiple-value-for.html

Hope this helps?

aPsikus

I have tried this using SQL in Filters:

Works when we check Results, but executed from Action link returns this error:

Robert Angel

Your speech marks are incorrect, they need to not be in the second set of parenthesis, but instead thus; -

'@{YourPrompt}{YourDefault}'

aPsikus

I set it the same as it was mentioned in the article which you have linked.

I have updated it with your suggestion:

"CC - Business Unit"."Business Unit - OpCo" IN ('@{PV_SELECTEDOPCO}['@']{A}')

but now there is two much speech marks in SQL:

("CC - Business Unit"."Business Unit - OpCo" IN ('''A'',''B'''))

Robert Angel

Mmm - think this might be '@' doing, try losing the speech marks around '@ ...... A}' and see what happens...

aPsikus

I have tried different options.

('@{PV_SELECTEDOPCO}['@']{A}') - works for default, but no data from dashboard as too many speech marks

('@{PV_SELECTEDOPCO}[@]{A}') - works for default, but no data from dashboard as value will be empty

(@{PV_SELECTEDOPCO}['@']{A}) - error for default, Nonexistent column: A, but works from dashboard for single and multiple selection. Do not work for All Column Values returning same Nonexistent column error.

I have tried to remove default value and play with speech marks, but didn't found working solution.

Robert Angel

All Column values is another factor, from memory this returns some strange collection of characters, the only way I have found to make that work is by using a case or similar logic switch to substitute the combination of characters with the obiee column you are filtering (i.e. it will always equal itself!)

I don't have access currently to try it to get you the exact combination of weird characters, but if you view the physical SQL generated then you will see what I mean and can copy it into a sql based filter.

Not following if you are saying that the presentation value, when validly populated with a single or multiple choices is now working or not, can you clarify please?

aPsikus

Works for default/ error for default - I meant Results tab in report itself.

Works from dashboard for single and multiple selection - I meant single and multiple selection in the dashboard prompt for testing

I can't check SQL for All Column Values, as it is not generated, and error is generated before sensing SQL.

I also wanted to check what it sends.

All Column Values has interesting behavior, because if we have link directly on dashboard, it will correctly pass the selection to target report. But between reports (action link) it is not passed.

How to add the case in filter?

"CC - Business Unit"."Business Unit - OpCo" IN CASE @{PV_SELECTEDOPCO}

WHEN (All Column Values) THEN ('A','B','C','D','E')

ELSE (@{PV_SELECTEDOPCO}['@']{A})

END

Doesn't look like working filter.