It is a common requirement in BI reporting to do certain calculations
“on the fly” at query run time. Sometimes these calculations have to be
based on query input parameters. Usually formulas and virtual
characteristics are used for calculating values dynamically. In this
post I will look at an example where we have to produce a calculation
for each report line, using query lines as an input parameter together
with query variable values.
Business Case
Let’s look at a business case where we are dealing with a vast volume of
customers signing up for service contracts with an organization. When
we analyze customer contracts one of the analysis objects in BI
reporting is customer’s age. As contracts usually last for several years
customer’s age has to be defined as of a certain date.
