Web Intelligence : Getting Baseline in charts

by BIDW Team on May 9, 2009

Share on TwitterSave on DeliciousShare via email

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:

  1. Web Intelligence : limitations
  2. Understanding Web Intelligence Document Structure
  3. Using Alerters to Highlight Information on Web Intelligence Report

Leave a Comment

Previous post:

Next post: