Bar chart grouping by 2 dimensions

Question

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_CodePeriodDirect_reasonIndirect_reasonAIThisPeriod103AILastPeriod124TAThisPeriod72TALastPeriod104WEThisPeriod155WELastPeriod113RAThisPeriod139RALastPeriod75

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

Gianni Ceresa · Answer

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

bskumar.obiee · Answer

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