SSAS Design Best Practices & Incremental Processing (presented by Dan English) - So you built a SSAS cube or are planning on it...now what? Just deploy, process, and let the users go at it? Maybe and maybe not. During this presentation we will talk about and explore Analysis Services design best practices and talk about a method for incremental processing.
Want to know what PerformancePoint Server (PPS) 2007 Monitoring & Analytics is all about? Get ready for an overview of this portion of the product and a demonstration creating a dashboard solution. I am looking to demonstrate building a BI Dashboards example from the Code Magazine Mar/Apr issue (article id 0803051 if you want to check it out in advance on the code-magazine site).
The new Gauge data region is most often used to provide a high-level summary of your data by highlighting key performance indicator (KPI) values. The gauge uses a pointer to show a single value. You can add a range to highlight a subset of values on your scale and control the size and positioning of the scale on the gauge to create different visual effects.
SQL Server 2008 includes Dimension Designer Enhancements, new attribute relationships designer, and additional Best Practice Alerts. The Dimension Wizard within BIDS 2008 (VS 2008) for Analysis Service Projects has been simplified and introduces a new attribute relationship designer. The wizard has reduced the number of screens and includes an auto-detection for parent-child hierarchies.
SQL Server 2008 includes GROUPING SETS: Grouping Sets is an extension to the GROUP BY clause that lets users define multiple groupings in the same query. Grouping Sets produces a single result set that is equivalent to a UNION ALL of differently grouped rows, making aggregation querying and reporting easier and faster.