Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 17 Oracle Analytics Lounge
- 218 Oracle Analytics News
- 44 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 81 Oracle Analytics Trainings
- 15 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
OBIEE Pivot Table custom Grouping Values
Hi,
I have a special case,
I have a Product Dimension and values are as below, i am struggling to arrange Product Name according to my Requirements. I try to Use CASE Statements which is working fine For Table View but It is not Arranging Product Names for Pivot table can you please help on this,
Current Product Pivot Table
| Product Name | Amount |
|---|---|
| Keyboard | 120 |
| Mouse | 80 |
| Chair | 970 |
| Tables | 2100 |
| Window Glass | 1800 |
Want to Achieve: in Pivot table
| Name | Amount |
|---|---|
| Keyboard | 120 |
| Mouse | 80 |
| Total (key,mouse) | 200 |
| Window Glass | 500 |
| Tables | 1000 |
| Chair | 1500 |
| Total | 3000 |
Answers
-
Pull another ProductName column and use case statement for grouping required products.
In the product hide this and set aggregation ie. sigma
0 -
Time for some Jeopardy: What are "Groups and Calculacted Items" in OBIEE? ==> http://docs.oracle.com/middleware/1221/biee/BIEUG/filter.htm#BIEUG1033
0 -
@ Christian You allways there for us to correct us, thank you.
My wording is wrong Group i mean
case when "Time"."Year"<2005 then 'Year <2005' else 'Year>=2005' end
this would show up as
0 -
Hi Srini,
Thanks, i tired this but problem is Sorting on Pivot table you can sort ASC or DESC but i want to arrange according to my needs for Product Name
Want to Achieve: in Pivot table
Name Amount Keyboard 120 Mouse 80 Total (key,mouse) 200 Window Glass 500 Tables 1000 Chair 1500 Total 3000 0