The first thing you need to consider when creating a new analysis is your Source Data. The data that are available through the TARGIT client would normally originate from one or more of your company´s ERP systems, e.g. a Navision database.
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 example above, we are looking at a DemoData Database connection, containing a Sales Cube, made up from a number of Dimensions and Measures.