O'Reilly logo

SAP BusinessObjects Reporting Cookbook by Yoav Yahav

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Using extended syntax

Besides the regular calculations that we can apply and display in tables, we can use a different kind of calculation that uses contexts to perform the calculation.

The calculation engine of Web Intelligence treats measures in two main ways:

  • It projects the measure value in the row level. This is what we will normally do with the measures in the report, drag them with dimensions and get their results per the dimension/s values (dynamic aggregative qualification)
  • It creates a calculation that will display the total, average, min, or max in the table footer as a single cell (a "fixed" aggregative qualification)

Another way to use measures would be to change their context for the following reasons:

  • We need to display a measure, the ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required