Setting Cube Properties
The properties of the cube must be completed before we can create the cube in the Analysis services database. Most of the elements in the properties screen will be defaulted, but each of the following columns will probably need to be completed.
1 The connection to the Analysis services server must be defined within the cube properties. This connection is a connection object. If no such connection exists then a new connection of type must be created and configured. SQL Server 2005 or 2008 Analysis Services use a connection type of "Analysis Server 2005+". This connection name must then be chosen in the cubes properties.
2 A cube database name must be selected. A new database name can be created by clicking the 'new database' button. This database name is the database that the cubes will reside in on the Analysis services server.
3 The data source connection must be defined and the three derived values shown under this connection must be present. If there is nothing in the three fields below the data source connection then the connection object will need to be modified. The provider type will normally be MSDAORA if the data warehouse is an Oracle database or SQLOLEDB if the data warehouse is SQL Server. The Server is either the SQL Server database server, or the Oracle TNS name. The database is the data warehouse database name.
Inspecting and Modifying Advanced Cube Properties
Now that the basic OLAP Cube has been defined, various properties of the OLAP Cube can be inspected or modified: