Usually these data will have to be modified before they can be used for analytical and reporting purposes in TARGIT – or any other Business Intelligence system for that sake.
The modification takes place in intermediate Data Warehouses, typically by structuring the data into multidimensional databases, also known as cubes.
Each cube is then defined with a number of measures (quantitative data, KPIs) and a number of dimensions (which are used to categorize and filter the measures).
In the screenshot below, we have taken a closer look at the Customer dimension.
The Customer dimension has been expanded to reveal that it contains a four level hierarchy (also shown expanded) and a number of attributes.
The first crosstab uses the hierarchy down to the second level to show Revenue per Territories and Countries. The second crosstab uses the Country attribute to produce a list of countries with their revenues.