Categories
- All Categories
- Oracle Analytics and AI Learning Hub
- 44 Oracle Analytics and AI Sharing Center
- 20 Oracle Analytics and AI Lounge
- 278 Oracle Analytics and AI News
- 56 Oracle Analytics and AI Videos
- 16.2K Oracle Analytics and AI Forums
- 6.4K Oracle Analytics and AI Labs
- Oracle Analytics and AI User Groups
- 103 Oracle Analytics and AI Trainings
- 20 Oracle Analytics and AI 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