·
The new release is based on the vision to reach
a broader user base
·
SSAS brings together the existing multi-dimensional model with the new tabular
model pioneered by PowerPivot under a single unified platform – the BI Semantic
Model
·
Data Mining Component remains the same
·
The BI Semantic Model promises one model for all
end user experiences
o End
Users/Personal BI – PowerPivot for Excel
o Team
BI – PowerPivot for SharePoint
o Coporate
BI – Analysis Services
·
What is The BI Semantic Model? It is just
another term for a Data Model hosted within Analysis Services
·
There are three approaches in developing a BI
Semantic Model
o PowerPivot
Workbook
§ Design
Type: Tabular
§ Tool:
Excel 2010
§ Biz
Logic: DAX
§ Data
Access-Cache Passthrough: In Memory
§ Deployment:
SharePoint Library/Analysis Services/PowerPivot
o Tabular
Project
§ Think
of this as PowerPivot for the IT Pro. End user hands off the PowerPivot
workbook to IT department.
§ Design
Type: Tabular
§ Tool:
SQL Server Data Tool
§ Biz
Logic: DAX
§ Data
Access-Cache Passthrough: In Memory Direct Query
§ Deployment:
Analysis Services Tabular Mode
o Multidimensional
Project
§ Design
Type: Multidimensional
§ Deployment:
SQL Server Data Tools
§ Biz
Logic: MDX
§ Data
Access-Cache Passthrough: MOLAP/ROLAP
§ Deployment:
Analysis Services Multidimenional
o Front
End Clients
§ PowerView
(uses DAX to query the BI Semantic Model)
§ 3rd
party apps
§ Reporting
Services
§ Excel
§ PowerPivot
§ SharePoint
Insights (PerformancePoint Services)
·
Note that Tabular Models understand both DAX and
MDX
·
DAX is new SQL Server 2012 and only works
against tabular models
·
The advantage of a tabular model is that we can
now work with:
o Files
o OData
Feeds
o Cloud
Services
o Relational
Databases etc
·
BI Sematic Model supports Fine-grained security
row and cell level
·
The following templates are available through
SQL Server Data tools:
o Analysis
Services Multidimensional and Data Mining Project
o Import
from Server (Multidimensional and Data Mining)
o Analysis
Services Tabular Project
o Import
from PowerPivot
o Import
from Server (Tabular)
·
Multidimensional Model New Features
o 300+
improvements
o New
Developer tool: SQL Server Data tools (Visual Studio 2010)
o Removal
of 4G string limit for attributes
o New
events for monitoring locks and attributes
o Support
for XEvents for low overhead eventing support
o PowerShell
support
·
Installation and Configuration
o Services instances are installed with SQL
Server Installer
§ Server
modes: Multidimensional and Tabular – both can be installed on the same server
o PowerPivot
Configuration tool is used to configure/repair a PowerPivot instance
·
New PowerShell cmdlets for AMO for command-line
connectivity, navigation and discovery of SSAS databases
·
Existing apps – every UDM
becomes (can be upgraded to) a BI Semantic Model
No comments:
Post a Comment