1301
Chapter 58: Creating and Deploying BI Semantic Models
58
Multidimensional Expressions Language (MDX) or Data Analysis Expressions Language
(DAX). MDX has a steeper learning curve than DAX. DAX is the new querying language that
is much easier to learn because it is similar to Excel functions.The Development Environment
BI Semantic Models were fi rst introduced with PowerPivot as two offerings:■ (^) PowerPivot add-in for Excel 2010
■ SQL Server 2008R2 PowerPivot for SharePoint 2010
PowerPivot add-in for Excel leverages on the xVelocity engine to provide the ability to
manipulate and create compelling analyses over billions of rows in a desktop environment.
The development environment of BI Semantic Models in the PowerPivot add-in for Excel
looks and feels just like Excel, as shown in Figure 58-2.
FIGURE 58-2
PowerPivot add-in for Excel 2010.
Alternatively, BI Semantic Models can also be developed using the SQL Server Data Tools
environment. This tool is a rebranding of Business Intelligence Development Studio (BIDS)
found in previous versions of SQL Server based on Visual Studio 2010. Figure 58-3 shows the
SQL Server Data Tools development environment.
c58.indd 1301c58.indd 1301 7/31/2012 10:35:59 AM7/31/2012 10:35:59 AM
http://www.it-ebooks.info