Microsoft® SQL Server® 2012 Bible

1319

Chapter 58: Creating and Deploying BI Semantic Models

58

To schedule automatic data refresh of a PowerPivot workbook follow these steps:

1. Navigate to the SharePoint PowerPivot Gallery to which the PowerPivot workbook is
   deployed.


2. Open the Manage Data Refresh screen. Launch the Manage Data Refresh screen by
   clicking the Calendar icon on the top right of the workbook preview area in the
   Theater, Carousel, or Gallery view. Alternatively, you can also launch the Manage
   Data Refresh screen by selecting the option from the PowerPivot workbook options
   in the All Documents view.


3. In the Manage Data Refresh screen, click the Enable checkbox and confi gure the
   schedule settings such as the frequency, start time, e-mails for notifi cations, data
   source credentials and data source(s) to refresh.


4. Click OK.
   The PowerPivot workbook’s data will be refreshed automatically according to the schedule
   confi gured.

Creating BI Semantic Models Using SQL Server

Data Tools

You can develop BI Semantic Models using the SQL Server Data Tools using a special type

of project called the Analysis Services Tabular project. As mentioned earlier, the develop-

ment environment and development process are similar to that of the PowerPivot add-in

for the Excel 2010 environment. If you read the section “Creating BI Semantic Models Using

PowerPivot,” you can fi nd a lot of similarities.

To create a new BI Semantic Model using SQL Server Data Tools, follow the next steps:

1. Launch SQL Server Data Tools. You can fi nd the shortcut under the default install
   location located at Start ➪ All Programs ➪ Microsoft SQL Server 2012. The SQL Server
   Data Tools launches and displays the default Start Page.


2. On the Start Page, click the New Project option. You can also create a new project
   by clicking Start ➪ New ➪ Project. The New Project dialog window opens.


3. Select the Analysis Services Tabular project template option. Change the
   name of the project to AWTabularProject. Change the solution name to
   AWTabularSolution. You may also change the location to save the project.


4. Click OK. A blank model named Model.bim opens. At this point the model is an
   empty canvas. You need to create a table structure and import data.


5. Click Model menu option. From the menu list, select Import from Data Source,

c58.indd 1319c58.indd 1319 7/31/2012 10:36:05 AM7/31/2012 10:36:05 AM

http://www.it-ebooks.info