Working with variables

A variable is simply a formula turned into a local object that can be viewed and used from the Available objects pane and treated just as any other object that exists in the report and was retrieved by the query.

Another way to define a variable is that it is a formula that has a name.

During creation, a formula inserts its result into a specific and usually a single column; to build a variable is just like saying that we have created a global formula in the report that can easily be used in every report tab, table, and chart.

There are several advantages to creating a variable compared to a formula:

  • We can reuse a variable easily without needing to copy and paste or recreate the formula
  • Variables can be used in filters, ranking, ...

Get SAP BusinessObjects Reporting Cookbook now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.