Quick Start - Initial Setup of Application and Data

Here is a high level look at the steps for initially setting up your Stratum.Connector for Viewer Analysis Services database and cube. Before you proceed with this set up and perform an initial process of the database and cube, you need to make sure that Stratum.Server master file commands have been run and an OLAP parameter/switch has been enabled. See Run Master File Commands and Enable OLAP Parameter/Switch.

Define the Stratum.Server Data Source

  • Right-click the Stratum.Server Data Source node , and select Define Stratum.Server Data Source.

  • Use the Define Stratum.Server Data Source window to specify the location and name of the Stratum.Server database that will be the data source.

 

 

 

Define the Analysis Services Database

 

 

Define the Stratum.Viewer Data Source

 

Make Dimension Selections

 

Make Measure Group Selections

 

Make Calculated Member Selections

 

Customize Parameter Settings

  • Right-click the name of the Stratum.Connector for Viewer SQL Server database , and select Parameters.

  • Use the Parameter Settings window to customize several settings including those for the handling of key errors and the batch processing of Stratum.Connector for Viewer updates.

 

Process the Database

  • Right-click the name of the Analysis Services database , and select Full.

  • Use the Full window to initiate a full process of the database. You will be asked to confirm that you want to proceed with a Full process.