230 likes | 356 Views
BI All the way Part II - Analysis Services. Gal Gubesi CEO, Microsoft Regional Director for BI gal@prognosys.com. Microsoft Business Intelligence. Microsoft Business Intelligence. Agenda. Unified Dimensional Model. Dimensions. Key Performance Indicators. Real-time with Proactive Caching.
E N D
BI All the wayPart II - Analysis Services Gal Gubesi CEO, Microsoft Regional Director for BI gal@prognosys.com
Agenda Unified Dimensional Model Dimensions Key Performance Indicators Real-time with Proactive Caching Perspectives Translations Closure
UDM UDM - Unified Dimensional Model • The UDM acts as a bridge between the users and their data • Combines the best of traditional OLAP: • Performance • Rich calculations • End-user model • With the best of traditional Relational based reporting • Real time & Detail level data • Complex schema • Simplified management
Basic Dimensional Model Data Source View Customer ID (PK) Name Age Storage/Caching Policies Order Order# (PK) CustomerID DueDate Calculations End-user model UDM UDM Scope(Customer.Country.USA, *); Sales = 2; End Scope;
UDM - Role of the Data Source View • Relational schema on which the cubes and dimensions are built • Allows schema to be annotated • Relationships • Primary Keys • Named Calculations • Named Queries • Presents a unified view of the underlying data source(s)
Quota CustomerID Quantity Customer ID Name Quota CustomerID Quantity Customer ID Name UDM - Multiple Data Sources • DSV can contain tables drawn from multiple heterogeneous data source DSV • ‘Primary’ data source must be SQL Server • AS will issue OPENROWSET queries
Customer Sales Dimensions • Regular
Customer Sales Dimensions Sold To • Regular • Role Playing Purchased From • Implemented in storage engine • Dimensions stored once, but used multiple times in different roles • Conserves disk, reduces processing times
Customer Trans. Account Customer / Account Dimensions • Regular • Role Playing • Many-to-Many • Complex analytics when dimensions not directly related to fact table • Facts roll up as “Distinct Sum” • Expands the application of the dimension model beyond the star schema
KPIs • Stands for “Key Performance Indicators” • Calculate Value, Goal, Status, Trend, Weight, Gauge • Accessible from client application • Icons can be modified
KPIs • Create KPI’s instantly • Images transmitted using Binary XML • BSM Integrated
New data, New dimension members Auto process Processing Changing Data How often, When? Show old data? Stall? Triggering, Timing Routing Proactive caching Proactive Caching
Cache SQL SQL MDX UDM User RDBMS Analysis Services Proactive caching
Cache SQL SQL MDX UDM User RDBMS Analysis Services Proactive caching
Cache Cache SQL SQL MDX UDM User RDBMS Analysis Services Proactive caching Data updated
Perspectives • Cubes can be complex for users to explore • Use perspectives to reduce complexity • Information reflects analytical needs • Not a security mechanism
Translations • SSAS is multi-lingual using translations • Multi-lingual for data & meta-data. • For example: • Product dimension name • Product name itself • Measure name • Etc.
Closure • Better flexibility • Shorter development cycle • BI for everyone… … analysis services is just part of it
איך ממלאים משוב? ב - email בסוף כל יום ב -Beat Center מה מקבלים? חולצת Feel The Beat השתתפות בהגרלת כרטיסי טיסה מכשירי i-mate ועוד...(לממלאים משוב לכל יום) New York! New York!
Gal Gubesi CEO, Microsoft Regional Director for BI gal@prognosys.com