Topics Map > University of Chicago > IT Services > Business Systems

Business Objects - DeskI / WebI - Location Based Context of Formulas and Variables

This article explains how formulas and variables placed in a Business Objects report are evaluated based on the context of their location in the report structure.

When you create a formula (or variable) in a Business Objects report, it is evaluated based on its location (a.k.a. context) in the document. This limits the data that will be used to calculate the value. This is particularly important keep in mind when using aggregation formulas.

This also applies to most measures, unless specifically built not to, they will automatically sum to the context of where they are placed. This functionally makes them the equivalent to the formula "=sum(<A Measure Object>)".

Context by location:

Location: Context: Example:
Header or the general body of a report
(outside of any sections)
the entire report Report Total
Section header/footer for each value of the section Section Total
Table break header/footer for each value of the table break Break Total
Row of a table for the dimensions included in the table
(including hidden dimensions)
Row Total

Cautions:

  • Be careful what values you aggregate, be aware of the dimensions that determine the context (in particular for rows of a table). Some aggregations that can produce incorrect values:
    • snapshots for a time period (i.e. to date or running totals)
    • overlaps over time (i.e. the same value occurs in different time periods so that the total for both periods is not the sum of the individual periods)

See Also:




Keywords: "Business Objects" BO IRF AURA SDW Financial Payroll Report aggregate advanced GEMS   Doc ID: 17309
Owner: James I.Group: University of Chicago
Created: 2011-03-14 18:00 CSTUpdated: 2013-12-16 12:02 CST
Sites: University of Chicago