Business Objects charts does not have Base line feature in line chart. This is much needed. However we can workaround this in WebI report. Please see below the step-by-step process to get base average baseline in revenue by year report.
- Add the Year, Quarter and Revenue object in query panel.
- Click on run Query to view the result. Add only Year and revenue object in report.
Note: Quarter Object is required for this workaround to work in Drill mode.
- In above image you can see there is no baseline in chart as it is not supported in BO.
To get it we need to create a Average variable as shown below.
Average := Average([Sales revenue]) ForAll([Year];[Quarter])
- View the result.
- Now Turn table to line chart. You will see a Average Base Line.
Subscribe to Email to receive all the FREE updates and Business Objects Interview Questions and Answers FREE!!
Related posts:
