Report with Union

 have a report with UNION of 3 criteria and the result i am getting is one of the columns is a union of 3 columns like Age Group,Gender and Race and here the problem is i need to show them in order Race first, Age Group, Gender now it is showing in sorting order even though i cleared sort on all the columns 65+,75+,85+, Asain, Black,Female,Hispanic,Male instead i want the column to show me Asian, Black,Hispanic, 65+,75+,85+,Female, male also in that table i want to make the table line thicker after race category and Age Group




1) In each of your three separate queries, add another column.

2) Create BINS according to how you want the final report be sorted: Asian = '1', Black = '2', etc...

3) Sort on this column in the combined query.

Since each query will have the proper number assigned to the group, the report will sort as you wish...

Aging report

How to create ageing report by using following columns in below provided format.Pleaselet me know the solution.

Columns:Customer,Debit,Credit,Days past due

Format:
Days(0 to 180) |Days(180-365) | Days(>365)|

---

Customer|Credit|Debit|Credit|Debit|Credit|Debit|

---

abc | 3344 |12000 |400 |36000 |100 |12000 |
xyz | 1340 |12300 |400 |3600 |300 |11000 |

case when cast(Days as int) <180 then 'Days(0-180 days)'
when cast(Days as int) >= 180 and Days < 365 then 'Days(180-365 days)'
when cast(Days as int) >365 then 'Days(>365 days)'
end

Display percentage on stacked bar graph

Can anyone please tell me as to how to display percentages on a stacked bar chart. All the time it displays actual values.
For example ..

	18%

3000 | | | | | 

70%

2000 | | | | |

12%

1000 | | | | |

---

Q1 Q2 

I hope I could depict it. 

Thanks

Answers


1) Did you try altering the PCXML file?
http://obiee101.blogspot.com/2008/01/obiee-xy-and-data-in-mouse-over-label.html

Regards
John
http://obiee101.blogspot.com

2) The one in {OracleBI}\web\app\res\s_oracle10\popbin. Did you restart the presentation server and javahost?

regards

John
http://obiee101.blogspot.com