This type of object is useful, fast, and it is calculated on the Intelligent Server side so it doesn't put load on the database. As the name suggests, it serves the purpose of consolidating row values. This means not only adding one row to another, but also doing row-to-row calculations.
Remember from previous chapters that there are multiple
Paris elements in the
City attribute, the schema was designed this way to respond to a specific requirement: allow the reports to display separate ZIP codes in large cities. Now we want to have a look at how much we sell in the entire city of London, but we don't have such an element in the
So, we create our own virtual attribute to show, ...