How to create a variable group in web intelligence

Written by sarah sammis
  • Share
  • Tweet
  • Share
  • Email

Web Intelligence is the reporting of an analysis portion of SAP's BusinessObject's suite. The Web-based interface gives users the flexibility they need to quickly generate reports. The Reporting Toolbar has the Variable Editor for defining variables to group data as needed.

Skill level:
Moderately Easy


  1. 1

    Click on the Variable Editor button from the Reporting Toolbar.

  2. 2

    Type a name for your new variable below the "Variable Definition" section.

  3. 3

    In the Formula box type the "If" statement that the program will use to group data if certain conditions are met.

    For example: If(Match([Binding];"Hard*");"Hardcover")

  4. 4

    Nest more "If" statements to further subdivide the data.

    For example:

    If(Match([Binding];"Hard");"Hardcover"; If( Match([Binding];"Soft");"Softcover";If (Match([Binding];"Library*");"Library" )))

  5. 5

    Click the check-mark to validate your formula's syntax. Make changes if necessary.

  6. 6

    Click "OK" once your formula is validated.

  7. 7

    Click on the Data tab in the Data Manager to find your new variable and use it in your reports.

Don't Miss

  • All types
  • Articles
  • Slideshows
  • Videos
  • Most relevant
  • Most popular
  • Most recent

No articles available

No slideshows available

No videos available

By using the site, you consent to the use of cookies. For more information, please see our Cookie policy.