Skip to Main Content
Forums

Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

KPI Filtering in OBIEE 11g

Vinz MayJan 11 2012 — edited May 25 2013
Hello,
I've successfully installed OBIEE 11.1.1.5 and I'm starting testing the new 11g features.
One problem I've run into is fairly simple in definition: how can I filter a KPI through a watchlist or a strategy map?
I know that in defining watchlists and scorecard one can use the POV bar, and indeed it works perfectly, but when I put the watchlist or scorecard on a dashboard it's not possible to filter KPI results through a filter, and the pov bar control simply doesn't show up.
Can anyone help on this matter?
Thanks in advance!

Vincenzo

Comments

User12626331-Oracle
Hi - don't know if you solved this yet but the way we do this is to place a Prompt on the dashboard. This prompt set a Presentation Variable (click on "Options" when building the prompt) and, when you have the watchlist on the dashboard, you can edit the pinnings and set them to "Presentation Variable" and type the name of the variable in. BE WARNED the variables are case sensitive. Hope this helps
DB
987994
Hi ,
As you have mentioned i have created a column prompt with presentation variable as "presyr"

i have a KPI , where the "target value" should have the value captured in "presyr" . So i have used the expression in target value as @{presyr}

i have put the kpi to a watchlist with "use point of view" option (i cannot use variables here as there is no presentation variable there)

After that i have put prompt and KPIwatchlist to dashboard while putting KPIwatchlist to dashboard i have used "use variable " option and i have selected presentation variable with value as "presyr"

but still the presentation value is not passing to target value in KPI

Did i missed any step please help

Thanks
NN
mbp
Hi,

I have installed Obiee 11.1.6.6 and I have the same problem. Finally did you can resolve this problem ? or somebody to know the solution.

I will appreciate your help

Mbp
1 - 3
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Jun 22 2013
Added on Jan 11 2012
#11g, #answers, #bi, #business-intelligence-applications, #business-intelligence-foundation, #business-intelligence-suite-enterprise-edition-obiee, #dashboard, #filter, #obiee, #prompt, #reports
3 comments
1,102 views