Microsoft® SQL Server® 2012 Bible

1322

Part IX: Business Intelligence

3. Click the column header titled SalesAmount. The entire column is highlighted.


4. Click the Column menu option, click the AutoSum submenu, and select Sum from
   the list. An aggregated column measure named Sum of SalesAmount is created.
   At this point a basic BI Semantic Model is complete. In the next section, you deploy the
   Tabular Project to an Analysis Services Tabular Mode instance.

Extending a BI Semantic Model with SQL Server

Data Tools

BI Semantic Models developed with SQL Server Data Tools support all the features available

in the PowerPivot Excel Add-in. The steps to add these features with SQL Server Data Tools

are very similar to the steps already covered earlier in this chapter under the section titled

“Extending a BI Semantic Model with PowerPivot.”

In addition, SQL Server Data Tools allows you to defi ne security roles, a feature not avail-

able in the PowerPivot Excel add-in. The next sections describe the steps to add this func-

tionality to a BI Semantic Model using the SQL Server Data Tools.

Creating Roles in SQL Server Data Tools

Roles provide the ability to limit access to Windows users by allowing specifi c rows that

match the DAX. The permissions available include:

■ (^) None
■ Read
■ (^) Read and Process
■ Process
■ (^) Administrator
To create a new role in SQL Server Data Tools follow these steps:

1. Follow steps 1 to 12 of the section titled “Creating BI Semantic Models Using SQL
   Server Data Tools.”


2. Click on the Model menu option and select Roles. The Role Manager window opens.


3. Click on New to add a new role.


4. Type BicycleProductManagers in the new role’s name.


5. Select the Read option in the Permissions column.


6. In the description textbox, type Read Access to Bicycle Category Product Managers.

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

http://www.it-ebooks.info