Analysis Services Quick Start
One quick way to start with both data warehousing and Analysis Services is to let the Business Intelligence Development Studio build the Analysis Services database and associated warehouse tables for you. Begin by identifying or creating a SQL Server warehouse (relational) database. Then open Business Intelligence Development Studio, and create a new Analysis Services project.
Right-click the Cubes node in the Solution Explorer, and choose New Cube to begin the Cube Wizard. On the Select Creation Method page of the wizard, choose Generate Tables in the Data Source, and choose the template from the list that corresponds to your edition of SQL Server. Work through the rest of the wizard choosing measures and dimensions that make sense in your business.
At the Completing the Wizard page, select the Generate Schema Now option to automatically start the Schema Generation Wizard. Work through the remaining wizard pages. At the end of the Schema Generation Wizard, all the Analysis Services and relational objects are created. Even if the generated system does not exactly meet a current need, it provides an interesting example. You can modify the resulting design and regenerate the schema by right-clicking the project within the Solution Explorer and choosing Generate Relational Schema at any time.
Get Microsoft SQL Server 2012 Bible now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
