SSAS Cube Creation
To implement an Analysis Services database, you need to take, at a minimum, the following steps: 1. Create a data source. 2. Create a data source view. 3. Create one or more dimensions. 4. Create a cube. 5. Deploy the database . Data Source: Your data warehouse is likely made up of disparate data sources such as Microsoft SQL Server, Oracle, DB2, Teradata, and so forth. Analysis Services can easily deal with retrieving relational data from various relational databases. Data source objects contain information needed to connect to a data source such as server name, catalog or database name, and login credentials. You establish connections to relational servers by creating a data source for each one. 1. Now open Visual Studio 2010 . 2. Then go to File –> New –> Project . 3. A New Project Window opens. In that select Business Intelligence from Installed Templates . Then select Analysis Services Multidimensional and Data M