SSAS-Info.com website update information for June, 2012
Message from our sponsors
Get SSAS and MDX training from experts at Technitrain. These courses are taught by top consultants who have a wealth of hands-on experience to share and who can answer all of your difficult questions. You'll acquire the practical skills you need to do your job as well as learn the tips and tricks that only the experts know.
Next available courses:
- Real World Cube Design and Performance Tuning with Analysis Services - July 2012, Manchester
- SQL Server Analysis Services 2012 Tabular Workshop, September 2012, Dublin
The following information was added to the SSAS-Info.com website during the month of June.
News
- SSAS News - June 19, 2012 - Microsoft released Cumulative update package 2 (CU2) for SQL Server 2012
- SSAS News - June 18, 2012 - Microsoft released Cumulative update package 7 (CU7) for SQL Server 2008 R2 SP1
Software
- SSAS Client Tools - PivotGrid Designer
- SSAS Client Tools - Kyubit AnalysisPortal – Web based SSAS front-end tool (commercial)
Articles
- Uncategorized - How to Choose the Right Reporting and Analysis Tools to Suit Your Style
- MDX - Problems with MDX's STDEV Function
- MDX - Tuning Queries with the WITH CACHE Statement
- MDX - LastNonEmpty in Tabular mode : Part 1
- MDX - SSAS: MDX Calculated Measures that Require Date Comparison
- Reporting Services - MDX Query Parameterization for displaying Last 12 month's SSRS Report
- Reporting Services - Parameterized SSRS reports sourced from OLAP cube with a dimension having set a default member
- Design - N/A For Subtotals
- Management - Using a Custom Assembly to search an Analysis Services dimension
- Management - X-XMLA: iv. Deploying Databases with XMLA
- Management - Analysis Services Cube processing fails with error "OLE DB error: OLE DB or ODBC error: Operation canceled; HY008."
- Management - SQL 2012: XMLA Change Connection Command Missing
- Management - How to Refresh a Cached Excel Services Report
- Management - SSAS Monitoring Tool- ASTrace
- Management - CoordinatorExecutionMode and Process MaxThreads
- Management - Writeback bug or feature in SSAS 2008 R2
- Performance Point - Leveraging PerformancePoint in HTTPS Enabled Sites
- Tabular - Too many PowerPivot Connections?
- Tabular - Tabular AMO 2012
- Tabular - Choosing an Analysis Engine
- Tabular - New SQL Server Tabular Projects for Analysis Services
- Tabular - Tabular query modes: DirectQuery vs In-Memory
- Tabular - Optimize Many-to-Many Calculation in DAX with SUMMARIZE and Cross Table Filtering
- Tabular - Using Images in Power View, PowerPivot and Tabular Models
- Tabular - Row security and hierarchies-part 2
- Tabular DAX - OR Selections in DAX
- Tabular DAX - Comparing Any Two Time Periods in DAX
- Tabular DAX - Ebook - QuickStart: Learn DAX Basics in 30 Minutes
- Tabular DAX - Using IFERROR/ISERROR in your DAX formula
- Tabular DAX - FILTER() - When, Why, and How to Use It
- Tabular DAX - Non-Unique Relationships and how to tune them
- Tabular DAX - LastNonEmpty in Tabular mode: Part 2, Last Ever Non Empty in DAX
- Tabular DAX - Tabular Model: Why is the 'Create KPI' button grayed out?
- Tabular DAX - DAX - Making the "Case" for SWITCH()
- Tabular DAX - Handling SSRS Multi-Valued Parameters in DAX Queries
Webcasts
- SSAS Webcasts - Video - Building an infrastructure to support real-time OLAP
- SSAS Webcasts - Video - Business Intelligence with Excel 2010
- SSAS Webcasts - Video - Memory Management for Analysis Services with SQL Sentry
- SSAS Webcasts - Video - Time Intelligence in DAX
- SSAS Webcasts - Video - Temporal Snapshot Fact Table
- SSAS Webcasts - Video - Advanced Security with Analysis Services Multidimensional
- SSAS Webcasts - Video - Load Testing Analysis Services
- SSAS Webcasts - Video - PowerPivot and QlikView 101
- SSAS Webcasts - Video - iPad and Powerpivot-Mobile Business Intelligence in action
- SSAS Webcasts - Video - Building Great Models for Crescent
- SSAS Webcasts - Video - Optimizing Your BI Semantic Model for Performance and Scale
- SSAS Webcasts - Video - BISM: Multidimensional vs. Tabular
- SSAS Webcasts - Video - Developing and Managing a BI Semantic Model in Microsoft SQL Server 2012 Analysis Services
- SSAS Webcasts - Video - Enriching Your BI Semantic Tabular Models with DAX
- SSAS Webcasts - Video - Data Mining 2012 with Microsoft Excel 2010 and PowerPivot
- SSAS Webcasts - Video - Building the Perfect BI Semantic Tabular Models for Power View
- SSAS Webcasts - Video - Many-to-Many Relationships in BISM Tabular
- SSAS Webcasts - Video - Building Self-Service BI Applications Using PowerPivot
- SSAS Webcasts - Video - Optimizing Microsoft SQL Server Analysis Services for Big Data
- SSAS Webcasts - Video - Deploying and Managing a PowerPivot for SharePoint Infrastructure Using Microsoft SQL Server 2012
- SSAS Webcasts - Delivering KPIs with Microsoft SQL Server Analysis Services
- PowerPivot - Video - Killer Real-World PowerPivot Examples
Comments
- Comments - Finally I understand why my calculation
- Comments - Thx......it is very helpfull for me.....
- Comments - For the "Drop Partitions" component I'm
And thank you for rating the articles!