Categories
- All Categories
- Oracle Analytics and AI Learning Hub
- 42 Oracle Analytics and AI Sharing Center
- 20 Oracle Analytics and AI Lounge
- 277 Oracle Analytics and AI News
- 54 Oracle Analytics and AI Videos
- 16.2K Oracle Analytics and AI Forums
- 6.4K Oracle Analytics and AI Idea Labs
- Oracle Analytics and AI User Groups
- 103 Oracle Analytics and AI Trainings
- 19 Oracle Analytics and AI Challenge
- Find Partners
- For Partners
Bar chart grouping by 2 dimensions
Dear all,
Please help me to create a stacked bar chart in Analysis in OBIEE like the picture below
I have a table data like this
| Fail_Reason_Code | Period | Direct_reason | Indirect_reason |
| AI | ThisPeriod | 10 | 3 |
| AI | LastPeriod | 12 | 4 |
| TA | ThisPeriod | 7 | 2 |
| TA | LastPeriod | 10 | 4 |
| WE | ThisPeriod | 15 | 5 |
| WE | LastPeriod | 11 | 3 |
| RA | ThisPeriod | 13 | 9 |
| RA | LastPeriod | 7 | 5 |
I think I should create a dimension with level-based hierarchy in RPD. I tried but seems I am on wrong way.
Please help me.
Thanks in advance.
Pham
Answers
-
Do you have this table data in Database or in Excel? In any case, you have to build your RPD... and Create chart view.. Not sure of the exact problem you are mentioning... Please elaborate on the exact issue..
0 -
Hi,
What's your starting point? Do you have the data already in OBIEE and the "table data" you posted is how your analysis currently look like?
You just have a random Excel file with these columns and want to create a chart?
What tool are you exactly using / want to use? (OBIEE Answers, DV/VA etc.)
The better you ask your question ( ) the more the answer will be helpful ...
0
