SQL Server Analysis Services 2005/2008 articles,blogs,scripts,FAQs,tools,books

News

- SSAS News - On July 18, 2011 Microsoft released cumulative update package 1 (CU1) for SQL Server 2008 R2 Service Pack 1
- SSAS News - July 12, 2011 - Microsoft Released Service Pack 1 (SP1) from SQL Server 2008R2
- SSAS News - July 12, 2011 - Microsoft released Community Technology Preview 3 (CTP3) for SQL Server Code name "Denali"

Articles

- MDX - MDX Root() function doesn't support multiselect
- MDX - Assign bucket types dynamically with MDX and dynamic sets in Analysis Services
- MDX - It just works–but why?
- MDX - The rather-too-many ways to crossjoin in MDX
- MDX - Using the IF Operator in Scope Assignments
- MDX - MDX Subselects - Some Insight
- MDX - Colour Codes in SSAS
- Excel - Custom Groups in Excel 2007 - Error
- Reporting Services - SSAS/SSRS : Building a graph for analyzing a subset related to the whole set
- Data Mining - Automation of Data Mining Using Integration Services
- AMO - Get SSAS objects with AMO using C#
- AMO - SSAS: AMO Coding Tips
- Design - How do you create a cross tab report using a SSAS OLAP cube
- Design - The Last Non Empty Dilemma
- Design - "Gotchas" With Using an SSAS Default Member
- Design - SSAS/Kimball : building a multivalue dimension construction in SSAS
- Design - Same measure in different granularity
- Design - Parent-Child Dimensions in Analysis Services - Performance Walkthrough
- Management - Linked Server for Analysis Services
- Management - Moving SSAS Databases (Detach)
- Management - SSAS Myths Dispelled
- Management - SSAS: Troubleshooting this exception - "An unexpected error occurred (file 'mdinfo.cpp', line nnnn, function 'MDInfo::Init')"
- Management - SSAS: What could be wrong if you get - A fact relationship cannot be defined?
- Management - Query Performance and Partition Scans in SSAS
- Management - Error Processing a Cube: Key cannot be null. Parameter name: key
- Management - New trace events in 2008R2 SP1
- Management - SSAS Error - The LocaleIdentifier property is not overwritable and cannot be assigned a new value
- Management - Can you query a SSAS cube while it is processing?
- Management - Find and Measure Relationships in Your OLAP Cubes
- Performance Point - Analysis Services Translations in Performance Point Services (SharePoint 2010)
- Performance Point - Using Project Server 2010 with PerformancePoint Services
- Performance Point - SharePoint 2010 SP1 is here, what's in it for BI
- Performance Point - PerformancePoint Analytic Chart showing unformatted value of SSAS measure
- Tabular - Cube vs. VertiPaq Query Performance
- Tabular - About the Relativity of Large Data Volumes
- Tabular - Denali : Installing the SSAS Tabular Model project AdventureWorks
- Tabular - Getting up and running with SQL Server Denali for Business Intelligence (Crescent and PowerPivot in CTP3)
- Tabular - Parent/Child Hierarchies in Tabular with Denali
- Tabular - Change default workspace and deployment server in #Tabular #SSAS #Denali #CTP3
- Tabular - Detect Tabular or Multidimensional Version in #ssas #denali #ctp3
- Tabular - Creating a Tabular Model with AMO
- Tabular - Problems with the SSAS Tabular Model Projects Denali CTP3 samples
- Tabular - Welcome to Tabular Projects

Comments

- Comments - great job .... keep it up :)
- Comments - Nice article...Thank you
- Comments - I have a measure with aggregation as Dis
- Comments - Me too ^^
- Comments - Tryng to implement this code but iam con
- Comments - Thanks for sharing ! Interesting idea t
- Comments - Thank you~ problem resolved
- Comments - The link goes to the wrong site, please
- Comments - I think it makes sense and I love your r
- Comments - Thaaaanks!!!!!
- Comments - Thank you, this worked to fix the build

And thank you for rating the articles!