How to Create 2 Y-Axis graphs in OBIEE

Question

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

Gianni Ceresa · Answer

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.

Nikhila reddy · Answer

It is helpful, Thankyou

can we achieve the same with the bar graph

[Deleted User] · Answer

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.