This discussion is archived
7 Replies Latest reply: Dec 4, 2012 12:54 AM by 913864 RSS

Unable to generate graph in OBIEE 11g

Ronny Newbie
Currently Being Moderated
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

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points