Bar chart grouping by 2 dimensions

c8523899-d78b-4c63-8c3f-a581895b306a

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

bskumar.obiee

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..

Gianni Ceresa

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 ...