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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

OBIEE 10g report Navigation

971799Oct 31 2012 — edited Nov 2 2012
Hi, trying to create an OBIEE gauge view report such that clicking on the gauge cause navigation to either two reports base on certain condition. This is what i mean:

The gauge view is based on a condition, say, no of application is 10 or more. clicking on this gauge navigates to a report showing all these application. However, if there are less than 10 applications but majority are not compatible with windows xp, then the navigation should be to a given URL displaying Xp compatibility information.

I hope this makes sense.

Thank you for your prompt responses.

Comments

Rookie_86
User,

Try to do the following:

1. Create a Report by taking 2 columns - Department Type, Number of Employees
2. Now go for Gauge view.
3. You could see Measure (Number of Employees is represented as gauge information for categories department).
4. Now Create another child report.
5. click on Additional Gauge Properties -> Interaction -> Navigate.
6. Select Child Report here.

This will help you to navigate to child report. By Adding another navigation report (you can also navigate to another report)
But, you cannot fulfil the requirment here by writing condition.

Instead add 2 sub reports in additional gauge properties.
So, On Gauge before user navigates - it will show (SubReport1 name , Subreport2 - name them properly so user understands and navigates to the requ. one)

You cannot directly, navigate conditionally from here.

Hope any other view type might help you out.
David_T
968796 wrote:
Hi, trying to create an OBIEE gauge view report such that clicking on the gauge cause navigation to either two reports base on certain condition. This is what i mean:

The gauge view is based on a condition, say, no of application is 10 or more. clicking on this gauge navigates to a report showing all these application. However, if there are less than 10 applications but majority are not compatible with windows xp, then the navigation should be to a given URL displaying Xp compatibility information.

I hope this makes sense.

Thank you for your prompt responses.
How in the world would OBIEE know if a record is compatible with Windows XP or not? Why does "fewer than 10 applications" (or any number of applications for that matter) make a difference? And what compatibility issue are you referring to anyway?
971799
Thanks so much for the suggestion. I'm aware this option exist but the requirement is that the report navigation will be automatic (no option for the user to select from) base on the condition aforementioned.
1 - 3
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Nov 30 2012
Added on Oct 31 2012
#answers, #business-intelligence-applications, #business-intelligence-foundation, #business-intelligence-suite-enterprise-edition-obiee, #dashboard, #obiee, #report
3 comments
277 views