OBIEE 11g Dynamic graph based on report

User_4ITW9

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

Gianni Ceresa

So you have a question about a chart in an analysis (instead of a graph in a report).

You need an analysis showing the total number of opened "things" (UT tracks analysis executed or pages of dashboards).

Next to that you want a bar chart showing analysis by what? What is your Y-axis?

User_4ITW9

Hi Gianni,

I managed to create an analysis with the total number of reports executed by user.

And next to it, they want a pie chart (sorry, not a barchart) showing by user the most opened reports.

The tricky part is that the user want the following behaviour:

-Click on the user name on the report, and the pie chart will refresh with the most opened reports by that user. Dont know if its possible to do that.

Here is what I managed to build:

I created this using a prompt, and then filter the graph with the user selected on that prompt.

BUT, they dont want that. They want to be able to click on the user name on the report and with that click, have the graph refreshed.

I dont know if this behaviour is even possible.

Any ideas? Hope I make myself clear.

Thankyou in advance for your help.

User_4ITW9

Here is a screenshot of what I managed to build:

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.

[Deleted User]

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

Gianni Ceresa

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.

User_4ITW9

This was exactly what I was looking for. Thank you