Oracle Analytics Cloud and Server

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

how to configure rollovers of graphs

Received Response
1
Views
4
Comments
3427576
3427576 Rank 4 - Community Specialist

Hi There,

I would like to configure the Graph Rollover in the second image just like in the First image. To be clear, even though the no of columns are same in the Layout tab for the both the graphs the output isn't same. For instance, the rollover in the first image has only two measures where as in the second one it is four.

Graph.png

Graph1.png

Answers

  • Thomas Dodds
    Thomas Dodds Rank 8 - Analytics Strategist

    The second one shows 3 dimensional attributes and 1 measure ... that's by design.  The intersection of the measure at the attribute values is essential for analytics - OBIEE is an on-screen analytics tool.

    You want to remove the context of the measure ... why?

  • 3427576
    3427576 Rank 4 - Community Specialist

    Hello Dodds,

    Thanks for your reply. The facts and dimensions in both the images are same. However, the result is not. I don't want to display the fact(supplier name) info on rollover. I have added it for writing a case statement. So, it is not wanted in the output.

  • Why do you keep it? If you used a column in a CASE statement (another column somewhere) you don't need to keep the original column, the reference is done directly to the right object even if not present itself in the analysis.

    It also looks a bit weird that "Supplier Name" is shown as measure, I hardly see what kind of aggregation you want to do on a name.

    More in general: if you have analysis working fine and you want the new one to be the same, compare screen by screen one with the other and set the same settings and it will work (same system, same settings = lot of chances to have the same result). Or you can also do it in the XML of the analysis directly ....

  • Thomas Dodds
    Thomas Dodds Rank 8 - Analytics Strategist

    @Gianni Ceresa  has given what I would point out next ...