OBIEE Pivot Graphs: Columns&lines

Calcioscacchi

Hi!

I use the 11.1.1.9.160419 version.

I've made a Simple analysis in OBIEE and i want to graphicate it.

It would be great if i can use the pivot table view and his graph too.

The analysis is simple: by month, i've to show 4 indicators: Efficiency, Quality, Availability, OEE (in the analysis i put them in this order).

Now: the graph that i choose is a column-line graph, and OBI force the view with 3 columns and one line, but i need 3 lines and only one series with the column view.

I easily obtain it with a normal graph view, but is complicated to filter the data, because if in the table (in the composed view, i need both the table and graph) i want to see the machine 1 infos, i have to filter it separately.

How can i change the pivot graph?

Thanks.

Gianni Ceresa

Hi,

I don't have a 11.1.1.9 available to try, but the chart inside the pivot table view is quite limited in options.

All the things you look for can be achieved with independent views where you have all the settings available. For example using master-detail linking you can change the filter on the chart based on the selection of the pivot etc.

The line-bar chart can be adapted by editing the XML but in the 12c I tested right now the pivot view seems to reset the XML and just ignore changes done by hand, so not much you can do there.

If you really want control over your chart go for separate views and either implement real filters (so not view level prompts but filters for the analysis using dashboard prompts) or use master-detail to connect views together and propagate interactions done in one to the other etc.

Calcioscacchi

Hi Gianni,

Ok, i suppose that the master detail way is the best one, so, first, i tried to learn it .

My situation:

- i filter the "machine" dimension, with the purpose to include in the analysis only some selected machines. So i set my views:

-PIVOT TABLE wich include:

1. months in rows;
2. machine status in column (minutes and percentage incidence on total minutes per status)
3. machine put in the prompt of the pivot table.

- GRAPH (barchart) wich include:

1. machine put in the prompt of the graph;
2. Months put in the section, slidebar view;
3. Incidence in measures;
4. machine status in bars.

I'd like to filter the machine in the pivot table (master view) and update the graph too with the same machine. So that's what i did:

-The master detail is set on "machine" dimension, Column properties, Interaction, Column Heading "none" and Value "send Master Detail event" called "Macchina".

-Then, i set the graph view to listen master detail events with channel "Macchina".

Now, what i except is that, when i change the machine in the pivot, also the graph will update immediately. Unfortunately, that is not what happens: the graph doesn't update.

Questions:

• In all examples that i saw, first the master column is defined, and only after this, the view is created. I set the master column just after the creation of my views. is this a problem?
• I said to the graph to listen master detail events. But who tells the pivot that it should send this event?

Thanks!

Gianni Ceresa

First of all, for your case I would still use a real filter to not retrieve from the database all the "machine" for nothing as you will always display them one by one. So using a dashboard prompt with a real filter would solve all your issues and give you a faster analysis.

If you want to do master-detail the order in which you define things (set first the column as master detail and after creating the view) doesn't matter. As long as everything is defined you will be good.

You need the "machine" column as prompt in the graph view as well, that's how it receive the event. The thing is that your user do not need to change both of them but changing one will update the other.

That's also why a dashboard prompt would match nicely: a single prompt and not 2 of them, and everything will just act accordingly.

Calcioscacchi

Ok, i already use a filter (i have almost 300 machines in my database, but i nedd 30 of them).

I'll try to put my views in a Dashbord.

Stay tuned

Calcioscacchi

Hi Gianni.

I've tried to put my analysis in a dashbord prompt, but it doesn't works. Seems that the master detail event is not sent/listened.