Menu Items

Wednesday 14 March 2012

New features are available in SSAS Denali(2012) over 2008 R2


·         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