Action link on Performance tile

aPsikus

Hi,

Our dashboard has main tab with dashboard prompt, and additional tabs with analysis.

On one of the tabs we have performance tiles, for which I'm trying to add Action links.

As I have noticed, for Performance tile only action link created for Value will be visible/active.

And now the question: does it mean that it will be possible to pass via action link only single value for the filter?

Because what I have noticed, is that:

• if target report has "is prompted" filter, than none value is passed, and target report displays all data.
• if target report has presentation variable in filter, than single value can be passed

But how to pass more than one value for presentation variable?

I'd like to mention that I have found this post on forum, but proposed solution do not work, as target report returns syntax error.

Robert Angel

You might want to have a look into Go URL functionality, or clarify further your requirement further with more detail if I am not understanding your requirement correctly.

You might also want to rename your user id, the long timers on the board are suspicious of those who do not rename their accounts as being time wasters who ask a lot of questions but who never mark answers or close their questions.

Joel

Does the column which you have the is prompted filter have exactly the same formula in both analyses? Even a subtle difference like a space will mean the is prompted filter won’t work.

aPsikus

@Joel,

Performance tile do not contain any formula. Based on selected filters displays one of the facts in total (YTD Hires).

I would like to connect via action link or maybe URL with parameters additional report/dashboard which will display the details (in other words drill down report) presenting hired employee details.

I have done it (added action link for performance tile and created details report).

But I have noticed unexpected behavior described in initial post. And I'm wondering is it standard behavior in case of action link for performance tile or I have set something wrong?

I have also tried to add action links for standard table, and I have noticed similar. If action link is added on column header, than value from prompt is not passed, and we see all the date. If it is set on the value, that results are filtered correctly.

aPsikus

@Robert,

Could you please provide some more details? I'm not familiar with Go URL option (does it mean to create link using go to web page and use parameters in it?).

Robert Angel

Hi,

the link is a little old, if you have 12c (you don't say) you might find it easier; -

https://gerardnico.com/dat/obiee/obips/go_url

It is heavier syntax, but much more powerful in terms of what you can achieve with it.

Typically drill down behaviour just uses the current row of data to filter the target report, if you find otherwise experiment with 'Is Prompted' filters on your target columns.

Robert Angel

Kindly also note that without using alternative means (presentation variables for filters, GO URL etc) the source and target must be in the same subject area or the standard filtered drill will not work.