Oracle Business Intelligence Applications

Home› Oracle Analytics› Oracle Analytics Forums› More Solutions› Oracle Business Intelligence Applications

Categories

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

Issue with Line-Bar Graph

Received Response
21
Views
4
Comments
3427576
3427576 Rank 4 - Community Specialist
in Oracle Business Intelligence Applications

Hi,

I want the % of Compliance PO measure as a line representation just like % of Non-Compliance Pos. I am using Pivot table.

pastedImage_0.png

pastedImage_1.png

I also tried using Table, However the results are strange. even though the column has data in table view the graph is not representing it. Whether it is table or pivot table, I need both the % columns should be represented as line and the other two as bars.

pastedImage_2.png

pastedImage_3.png

Answers

  • Gianni Ceresa
    Gianni Ceresa Mod

    What version of OBIEE?

    The chart related to the pivot doesn't like when you change the format to line in the XML, by default it makes all bars and the last measure a line.

    If you want to have the option to configure what is what (line and bar) you need to have a real chart by itself.

    You seems to say that in that case your result doesn't match the data, which sounds a bit absurd as it's the same query returning the values for both the table and the chart ...

    Is the formulas for the % "weird" ? (exotic or anything along that line)

  • 3427576
    3427576 Rank 4 - Community Specialist

    Hello Gianni

    Thanks for your reply.

    Here are the formulas I used for the % columns

    (("Fact - Purchasing - Invoice"."Non-Compliance Spend")/ SUM("Fact - Purchasing - Invoice"."Non-Compliance Spend"))*100

    (("Fact - Purchasing - Invoice"."Compliance Spend")/SUM("Fact - Purchasing - Invoice"."Compliance Spend"))*100

  • Gianni Ceresa
    Gianni Ceresa Mod

    Aren't "Fact - Purchasing - Invoice"."Non-Compliance Spend" and "Fact - Purchasing - Invoice"."Compliance Spend" measures?

    Because they are called "Fact" but you do a SUM without setting any dimensional attribute (using "by") or by using an aggregation at a different level. So it sounds a bit strange to me and could indicate that you maybe have some issues with aggregation rules etc. And maybe that's also what confuse OBIEE and that's why your graph just doesn't show things as you expect ...

  • 3427576
    3427576 Rank 4 - Community Specialist

    Hello Gianni,

    Thanks for your support.

    The issue got resolved by modifying the formula just like mentioned hereunder

    (1.0*("Fact - Purchasing - Invoice"."# of Non-Compliance POs")/("Fact - Purchasing - Invoice"."# of POs")*1.0)*100.

    As you suggested we used chart but not the pivot table as we need two measures to be represented as lines.

    pastedImage_0.png