Use this window to define an OLAP cube set-up, i.e. a definition that is associated with a BI Analysis Package OLAP cube in an Analysis Services database on a MS SQL Server. The general connection settings will define the server where Analysis Services resides. For each cube set-up, the target OLAP cube database name and cube name must be defined, to make it possible to validate and transfer measure information towards a specific target OLAP cube. The cube set-up also includes definition of cube measures to be used when defining Financial KPI Elements. List of Values functionality can be enabled by downloading SQL Server AMO and ADOMD in Microsoft SQL Server 2014 Feature Pack to the client machine and install. The List of Values functionality simplifies the definition of measures but it can also be done manually. The cube set-up also includes the definition of Company Groups, i.e. groups of companies with the same follow-up structure that could be analyzed together.
Define OLAP Cube SetUp
Process OLAP Cube
Run OLAP Cube ETL and Process Cube
Validate All Financial KPI Definitions
Publish Financial KPI Definitions