7 Replies Latest reply: Dec 4, 2012 2:54 AM by 913864 RSS

    Unable to generate graph in OBIEE 11g

    Ronny
      Hi All,

      I have four columns in the report, one dimension and three fact columns

      Dim.Col1
      Fact.Col2
      Fact.Col3
      Fact.Col4

      Fact.Col4 is nothing but I am dividing Col2 and Col3 like this, so in the formula for Fact.Col4, I have this

      Fact.Col2/Fact.Col3

      and these are the settings I have done for Fact.Col4

      1. I have overridden the default data format from number to percentage
      2. aggregation rule is default
      3. have checked "Treat as an attribute column"

      So My Fact.col4 has values like this

      2.5%
      4.5%
      6.2%

      Now when i am trying to built a graph using the columns dim.Col1 and fact.Col4, then the graph is not getting displayed. It shows me blank. But When I change the data format from percentage to default ( means uncheck the box) then graph comes up. So we can't create a graph on the column for which we have set the data format to percentage.? Can anybody please let me know what am I missing here

      Thanks,
      Ronny