The Curious Engineer

All blogs / Databases

SQL Business Intelligence

learn.microsoft.com/en-us/archive/blogs/ssasfaq

This blog contains a plethora of information spread across various aspects of troubleshooting commonly encountered issues with SQL BI Technologies. This blog presents the Blog writer's own view and this posting is provided "AS IS" with no

DatabasesMicrosoft blogsMSDN archive

’10’15’20’25
Posts
35 from 17 Jul 2010 to 10 Sep 2013
Posting
archived, read-only
Kind
personal blog
Feed
https://learn.microsoft.com/en-us/archive/blogs/ssasfaq/feed.xml

2013 10

  1. Tabular: .Net Provider supported by Tabular Mode
  2. SQL 2012 TABULAR: Performance Tuning of Tabular Models in SQL Server 2012 Analysis Services
  3. Tabular: Error while using ODBC data source for Importing Data
  4. Power View for Multidimensional Model is Finally Here
  5. Terms: Data Warehouse and SSAS
  6. DAX: Using filter and summarize in same Query
  7. PowerShell:How to List Database Roles and their Members
  8. HDInsight on Windows: Building PowerPivot Report from Hive in a Few Easy Steps (PDF)
  9. SSAS Crashing Intermittently: Caused by Monitoring / AV Scans
  10. Hardware Sizing a Tabular Solution (SQL Server Analysis Services)

2012 13

  1. SSAS Synchronization: Across different versions
  2. SSAS encryption
  3. SSAS Data Collection: Collecting Perfmon for SSAS
  4. Getting Deadlock Error During Processing
  5. SSDT Query Builder: MDX Query returning NULL instead of AllMembers
  6. Configuring: PowerPivot for Excel 2013
  7. How to use Network Monitor to capture network traffic
  8. Power View Infrastructure Configuration and Installation: Step-by-Step and Scripts
  9. SSAS:Informative Links
  10. SSAS: All Possible Scenarios of Changing SSAS Data Folder
  11. XMLA– Clear Analysis Services (SSAS) database cache
  12. SSAS Tip - IndexBuildThreashold
  13. Step by Step Guide of Installing Power View with PowerPivot 2012

2011 3

  1. SSAS Cluster: Issue with Mount Points while Performing Administrative Tasks
  2. MDX Descendant Function
  3. Connecting Project Server with SQL Analysis Services from External Domain.

2010 9

  1. Excel Report was not passing right user id to SQL Server Analysis Services
  2. Excel report with SSAS taking more time to refresh over Wan
  3. YTD Based on Current System Date (Now() Function), based on same date pulling value for Last Year too.
  4. Dealing with Slowly Changing Dimension using SSIS
  5. During ETL detecting dirty records from Fact
  6. SQL Server Deployment Property (Retain Configuration Setting)
  7. How to Deal with Corruption in Analysis Services
  8. Migrating OLAP SSAS 2005 Database to SQL 2008
  9. Running AS Command(XMLA / MDX) as a Batch Job Using SSIS Package