The Metrics and Scorecards module provide access through the Meridium Enterprise APM application to the cubes that exist in SQL Server Analysis Services, and allows you to develop Metric Views and KPIs using the data that is stored in those cubes.
Before you can access Analysis Services cubes through Meridium Enterprise APM, you will need to complete various configuration tasks. Configuring cubes for use with Meridium Enterprise APM Metrics and Scorecards functionality consists of the following tasks:
Create cubes in Analysis Services. Cubes are Analysis Services objects that can be created, modified, and managed using tools that can be installed with SQL Server Analysis Services. The first step in enabling Meridium Enterprise APM Metrics and Scorecards functionality is to create the desired cubes in Analysis Services.
For details on creating and managing cubes in Analysis Services, consult the documentation that was included with your SQL Server Analysis Services installation.
Create Analysis Services Cube records in Meridium APM. After you have created the desired Analysis Services cubes, you can create Meridium Enterprise APM objects (i.e., Metric Views and KPIs) that are based upon those cubes. Before you can do so, you must first establish a link between the cubes and Meridium Enterprise APM. To establish this link, you will create an Analysis Services Cube record in Meridium Enterprise APM to contain all the identifying information for the cube. Doing so will allow Meridium Enterprise APM to connect to the appropriate Analysis Server to access the information associated with that cube.
Configure privileges for Analysis Services Cube records. After you have created the necessary Analysis Services Cube records to make the desired cubes available in Meridium Enterprise APM, you will need to configure privileges for those Analysis Services Cube records. In addition to Meridium Enterprise APM standard family-level security, Metrics uses entity-level security to control access to individual records. Users must be able to access Analysis Services Cube records in order to access and manage the Meridium Enterprise APM objects (i.e., Metric Views and KPIs) that are based upon the associated cubes.
