OBIEE Pivot Graphs: Columns&lines

Question

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.

Calcioscacchi · Answer

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.

Calcioscacchi · Answer

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

Gianni Ceresa · Answer

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.