How to Create 2 Y-Axis graphs in OBIEE

Nikhila reddy

i created direct data base request and created a report.

the Above graph has accrual and Member_count, my requirement is to one Y-axis should show Member_Count and 2nd Y-Axis should show Accrual as below graph

Anyone please help to create 2 Y-axis graph for Direct database Request.

Thank you

[Deleted User]

a) That is not a "report" but an "analysis". A "report" is a BI Publisher object.

b) Use a line-bar chart type. It has two scales.

Nikhila reddy

It is helpful, Thankyou

can we achieve the same with the bar graph

Gianni Ceresa

It is generally possible using the bar/line chart to have the 2 axis and then switch the line to bars by editing a value in the XML of the analysis.