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

Other People Are Reading

Instructions

  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

Filter:
  • All types
  • Articles
  • Slideshows
  • Videos
Sort:
  • Most relevant
  • Most popular
  • Most recent

No articles available

No slideshows available

No videos available

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