Define OLAP Cube Set-Up

Explanation

This activity is used to set-up information related to the target OLAP cube.

Each cube has a unique identity that refers to a specific target OLAP cube in a specific cube database on the SSAS server defined in the Configuration Settings window. The OLAP Cube Name should refer to a cube that is supported by the BI Analysis Package and that thus has been deployed when installing the BI Analysis Package. It is however possible to use another OLAP cube on the same SSAS server as target. This might be the case if it is necessary to test Financial KPI definitions in a cube before publishing the definitions to the main cube. E.g. the ordinary OLAP cube defined during installation of the BI Analysis Package can easily (on the MS SQL Server side) be duplicated under another name (in a separate cube database) and the cube can be processed with the same data as the main cube, i.e. from the current IFS instance that has been setup as the source for the BI Analysis Package installation.

By default a cube definition is active, meaning that all cube related definitions will be transferred to the SQL Server database when performing validation and processing options. If a cube definition is only used for test it is recommended to set the cube as not active as soon as the testing is done to avoid transfer by mistake.

The OLAP Database Name and the OLAP Cube Name refers to the OLAP cube and this information has to be provided by someone. The alternative is trying to use the List of Values, which can work if SQL Server AMO and ADOMD in Microsoft SQL Server 2014 Feature Pack is downloaded to the client machine. However List of Values will show all available cube databases on the SSAS server, so it is still important to know which one to choose.

For a cube it is also necessary to set up the following information:

1. Cube Measures to be used when defining Financial KPI Elements. After downloading SQL Server AMO and ADOMD in Microsoft SQL Server 2014 Feature Pack to the client machine, List of Values functionality is supported, thus simplifying the definition of exiting measure in the target cube.
2. Company Groups that should be used in the current cube.

Prerequisites

This activity has the following prerequisites:

• Configuration Settings must have been done in order to define the database and servers
• Downloading of SQL Server AMO and ADOMD in Microsoft SQL Server 2014 Feature Pack and installation on current client machine if OLAP cube specific List of Values functionality is required.
• The target OLAP Database Name and the OLAP Cube Name in the target cube must be known (even if List of Values is enabled and used)
• KPI Company Groups must have been defined

System Effects

As a result of this activity:

• Financial KPI Elements and Financial KPI definitions for this specific cube can now be defined.

Window

OLAP Cube Set up

Related Window Descriptions

OLAP Cube Set-up
Configuration Settings
KPI Company Group

Procedure

To perform this activity,

1. Open the OLAP Cube Set-up window.
2. Supply a Cube identity and a description of the cube.
3. Choose the Cube Type
4. Enter OLAP Database Name and OLAP Cube Name either manually or by using List of Values.
5. By default the cube definition will be set as active. If the cube definition is not supposed to be transferred anymore to the Data Warehouse database on SQL Server, set the cube as not active.
6. In the Cube Measures tab define the measure items in the OLAP cube that are needed to define Financial KPI Elements. List of Values functionality is supported.
7. In the Company Groups tab connect the company groups for which the Financial KPI Definitions will be made.