If all the tasks above are completed, then it is now possible to create the cube on the Analysis Services server. Right-click the OLAP Cube name and then select Create (Alter) Cube.

WhereScape RED checks that key components of the cube are correct, before it proceeds to issue the create command.

The create cube menu option will perform the following tasks on the Analysis Services server:

  • Create an Analysis Services database if the name specified is not already present.
  • Create a Data Source with connection information back to the data warehouse based on the cube source information in the Data Warehouse connection.
  • Create a Data Source View to support the cube objects defined.
  • Create the dimensions used by the cube as database shared dimensions if they do not already exist.
  • Create the cube if it does not exist.
  • Create a partition for the cube.
  • No labels