OBIEE 11g Dynamic graph based on report

Question

Hi guys, I have a question about Graphs on OBIEE.

I was requested to create several reports using Usage Tracking info. Everything is setup and running, but I have problem creating a Dynamic graph.

We were requested to create a report that shows by user the total number of reports they access.

Also the user needs a graph with the following behaviour:

- Click on User Name, and display a graph netx to the table, showing in a bargraph all the reports accesed by that user.

e.g. : Click on "admin" and the graph will display all the reports accessed by the user.

Is this possible?.

We have setup usage tracking following oracle documentation. The table use is S_NQ_ACCT, with this table there are 4 logical tables created:

Measures : count reports accessed, query count, etc

Time - Start_date, start hour minute.

Topic - Subject Area, report path, Dashboards, etc

Users: - User info

No hierarchies created.

Really need your help. Thank you

User_4ITW9 · Answer

This was exactly what I was looking for. Thank you

Gianni Ceresa · Answer

As Christian said that's called Master-Detail in OBIEE.

I would just question the choice: a pie chart?

You don't want that, trust me!

Your pie chart looks great when a user open only 3-5 different analysis/pages, it will be totally useless with more than that and just a nightmare for a user who opened 20-30 objects.

If they said the pie chart is a requirement, tell them you will do it only if they can read a pie chart with 30 values and tell you each % just by looking at it.

[Deleted User] · Answer

4205400 wrote:But as I said before, the dont want to filter the graph using a Prompt. They want to be able to click on the user name on the report (left side) and with that click then the graph will be refresh.

That's what master-detail configuration with listening channels is for:

https://datacadamia.com/dat/obiee/obips/master_detail