Oracle Communities

Oracle Analytics and AI

Child Item

Multiple Text Value Presentation Variable

Hi Experts,

I am facing a strange situation and need your comments . I have two Pages on my Dashboard, Page1 and Page2. Ttrying to pass the Prompts values selected in Page1 via Narrative View to Page 2, do not want to show two separate page hence controlling the flow via Narrative View.

Now target report prompted for Country column as @{VariableName} is receiving the values e.g as ('India,Australia,USA') while it should have done is receive values as ('India','Australia','USA') .

Any workaround or tips to get this working may be of great help.

Thanks,

Anurag

Find more posts tagged with

Accepted answers

All comments

Pedro F

Hi,

Instead of using the syntax @{VariableName} use this: @{VariableName}['@']{'Default'}

AAwas-Oracle BI-Oracle

Thanks for the response but I do not think this is solving the scenario specific and inspite of format target report is firing the concat operation on the values

Below is the code I am using in my narrrative view ;

"Attributes-Store.Store Country" is the column to be filtered and Country is my variable name.

Target report is getting the below clause, and still does concat which is causing problems (here CAN and USA are the two values chosen in Dashboard prompt which are setting up the variable Country)

"Attributes-Store"."Store Country" LIKE concat(concat('%','''CAN'',''USA'''),'%'))

Martin van Donselaar

Not sure if I understand your question correctly, but why you are using presentation variables here?

Did you try to use Dashboard prompts with the scope set to Dashboard? That will apply the prompt to all pages in your dashboard.

Just make sure all reports on both pages have an "Is Prompted" filter on Country.

AAwas-Oracle BI-Oracle

Hi Martin, You are right but I do not want the individual tabs of the Dashboard to be exposed to users, I want the flow to different pages of the same dashboard , to be guided from inside pages hence I am passing control via Narrative (shown as button), along with the user chosen values in prompt.

Martin van Donselaar

Not sure what you mean by not exposing individual tabs to user? You can hide dashboard pages if that is what you want. They will become visible after you navigate there through an action link.

If you create an action link to navigate to other content (Dashboard page, analysis,..) then Dashboard prompts values will be taken to this content provided the analysis that you are navigating to have the "Is Prompted" filters. What is preventing you from doing this?

ArijitC

The answer that @Pedro F provided is correct and works with the filter.

I think the issue is with html link from narrative view. So, instead of using that you can use dashboard action link. Use same column in both page 1 and 2 prompt. multiple values will be carried. for example below...I have page 2 as action link(highlighted) and it carries all 3 prompt values 2 Page 2.

In report I used this ....

pv is my presentation variable.

Thanks

Martin van Donselaar

My question still is: why would you use Presentation variables when you can use Dashboard prompts that will carry over values?

Sure, this will work, however I'm not certain it is the best or easiest way to achieve the requirement.

Robert Angel

There seems to be an on going trend for over-engineered BI where the client wants very specific look and feel to be 'X' so the developers wind up hand crafting code which is expensive to create, more complex to understand, frequently results in sub-optimal query performance and is far from best practise.

My preference is to explain to the client the consequences of what they are asking for, tell them the standard alternative and let them make an informed decision.

I cannot say it always works, but I do feel clients respect this approach and come the day you can say hand on heart that 'you were advised against this'...

[Deleted User]

Can't support Martin's statement loud enough: WHY?

Yes it can work but 90% of times where this is an issue it's simply because it's the completely wrong thing to do and things can be done a lot more easily and especially CLEAN with out-of-the-box technologies.

AAwas-Oracle BI-Oracle

Right again, actually I was trying to avoid hard coded text which cannot be avoided in Action Links, In narrative, I was able to use column value which was replaced with session variable. From requirement perspective, action links does satisfy the requirement, though I may have to use External String internationalization with the same .

So requirement is fulfilled but presentation variable pass via URL is definitely a bug it seems as it is not able to handle multiple values in right way.