SQL Business Intelligence
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
Tabular: .Net Provider supported by Tabular Mode
Yes, tabular server supports .Net Provider but only for those Data Sources which are...
Author: Karan Gulati (SSAS Maestro) Date: 09/10/2013
SQL 2012 TABULAR: Performance Tuning of Tabular Models in SQL Server 2012 Analysis Services
Most Awaited Tabular Performance Tuning Paper is out…………. Applies to: SQL Server 2012 Summary:...
Author: Karan Gulati (SSAS Maestro) Date: 08/02/2013
Tabular: Error while using ODBC data source for Importing Data
Issue When using ODBC as a Data Source in the Table Import Wizard to add data to a Tabular Server,...
Author: Karan Gulati (SSAS Maestro) Date: 07/25/2013
Power View for Multidimensional Model is Finally Here
I am pretty excited about this feature with SQL 2012 SP1 Cumulative Update 4, you can create...
Author: Karan Gulati (SSAS Maestro) Date: 06/03/2013
Terms: Data Warehouse and SSAS
Data warehouse and ssas terms from Karan Gulati
Author: Karan Gulati (SSAS Maestro) Date: 04/29/2013
DAX: Using filter and summarize in same Query
In this SQL Query we are grouping Sales by Year and Color plus adding a filter of 5000 select...
Author: Karan Gulati (SSAS Maestro) Date: 04/29/2013
PowerShell:How to List Database Roles and their Members
1: [Reflection.Assembly]::LoadWithPartialName("Microsoft.AnalysisServices") 2: $ServerName...
Author: Karan Gulati (SSAS Maestro) Date: 04/29/2013
HDInsight on Windows: Building PowerPivot Report from Hive in a Few Easy Steps (PDF)
Download Step by Step PDF from Slide Share HDInsight on Windows: Building PowerPivot Report from...
Author: Karan Gulati (SSAS Maestro) Date: 04/29/2013
SSAS Crashing Intermittently: Caused by Monitoring / AV Scans
Problem Description: Analysis Services is crashing intermittently and also producing min-dumps....
Author: Karan Gulati (SSAS Maestro) Date: 04/10/2013
Hardware Sizing a Tabular Solution (SQL Server Analysis Services)
Applies to: SQL Server 2012 Analysis Services, Tabular Solutions Summary: Provides guidance for...
Author: Karan Gulati (SSAS Maestro) Date: 01/11/2013
SSAS Synchronization: Across different versions
Problem Statement: Synchronization between different builds or versions of Analysis Services....
Author: Karan Gulati (SSAS Maestro) Date: 10/24/2012
SSAS encryption
Description: Customer asking if AS supports TDE like encryption we got in SQL Engine. Solution: SSAS...
Author: Karan Gulati (SSAS Maestro) Date: 10/23/2012
SSAS Data Collection: Collecting Perfmon for SSAS
Applies to Windows7, Windows 2008/R2 and Vista SQL Server all builds >= SQL 2005 Generally, for...
Author: Karan Gulati (SSAS Maestro) Date: 10/01/2012
Getting Deadlock Error During Processing
Issue: Intermittently Getting below mentioned error during processing OLE DB error: OLE DB or ODBC...
Author: Karan Gulati (SSAS Maestro) Date: 09/27/2012
SSDT Query Builder: MDX Query returning NULL instead of AllMembers
*SSDT – SQL Server Data Tools *SSMS – SQL Server Management Studio In SSDT Query Designer...
Author: Karan Gulati (SSAS Maestro) Date: 09/19/2012
Configuring: PowerPivot for Excel 2013
For configuring PowerPivot in Excel 2013 you need to follow below mentioned steps: In Excel...
Author: Karan Gulati (SSAS Maestro) Date: 09/19/2012
How to use Network Monitor to capture network traffic
Often I need to share these steps with customers while troubleshooting Connectivity issues,...
Author: Karan Gulati (SSAS Maestro) Date: 09/17/2012
Power View Infrastructure Configuration and Installation: Step-by-Step and Scripts
Power View implementation paper is out and covers major scenarios of implementing Power View with...
Author: Karan Gulati (SSAS Maestro) Date: 08/15/2012
SSAS:Informative Links
SSAS 2012 Links Free SQL 2012 EBook SQL 2012 Virtual Labs DAX in the BI Tabular Model...
Author: Karan Gulati (SSAS Maestro) Date: 08/06/2012
SSAS: All Possible Scenarios of Changing SSAS Data Folder
Title - All Possible Scenarios of Changing SSAS Data Directories Scenario 1: Recreating a New Data...
Author: Karan Gulati (SSAS Maestro) Date: 07/30/2012
XMLA– Clear Analysis Services (SSAS) database cache
How to clear cache of a cube <ClearCache...
Author: Karan Gulati (SSAS Maestro) Date: 04/26/2012
SSAS Tip - IndexBuildThreashold
<IndexBuildThreshold> Index creation is controlled by the number of rows, specified in the...
Author: Karan Gulati (SSAS Maestro) Date: 04/20/2012
Step by Step Guide of Installing Power View with PowerPivot 2012
Install Win 2008 R2 + SP1 Roles IIS Add .Net Framework 3.5 Features Features Add Desktop Experience...
Author: Karan Gulati (SSAS Maestro) Date: 04/19/2012
SSAS Cluster: Issue with Mount Points while Performing Administrative Tasks
Issue: Environment consists of 2 nodes, SQL and SSAS 2008 can failover between the 2 nodes,...
Author: Karan Gulati (SSAS Maestro) Date: 11/29/2011
MDX Descendant Function
This example shows how to use Descendant function with Desc_Flag as self_before_after which means...
Author: Karan Gulati (SSAS Maestro) Date: 10/19/2011
Connecting Project Server with SQL Analysis Services from External Domain.
Environment Domain A Server A - Project server and Web Server Server B- SQL Analysis Services...
Author: Karan Gulati (SSAS Maestro) Date: 09/12/2011
Excel Report was not passing right user id to SQL Server Analysis Services
Background: Windows 2003x64, SQL 2005 SSAS with Dimension Security Enabled In this scenario when we...
Author: Karan Gulati (SSAS Maestro) Date: 12/28/2010
Excel report with SSAS taking more time to refresh over Wan
We had seen scenarios where Excel Sheet with Pivot table takes less time locally but over Wan it...
Author: Karan Gulati (SSAS Maestro) Date: 12/28/2010
YTD Based on Current System Date (Now() Function), based on same date pulling value for Last Year too.
In this example we are trying to pull ytd based on current date using Now Function. ...
Author: Karan Gulati (SSAS Maestro) Date: 10/25/2010
Dealing with Slowly Changing Dimension using SSIS
Surrogate Keys Also known as meaningless keys, substitute keys, non-natural keys, or artificial...
Author: Karan Gulati (SSAS Maestro) Date: 10/02/2010
During ETL detecting dirty records from Fact
Attribute Key Not found Error occurs in SSAS due to the following reasons : Dimensions...
Author: Karan Gulati (SSAS Maestro) Date: 10/02/2010
SQL Server Deployment Property (Retain Configuration Setting)
Well one of my customers had asked the as significance of this property as he didn’t find...
Author: Karan Gulati (SSAS Maestro) Date: 08/16/2010
How to Deal with Corruption in Analysis Services
I had seen few scenario where you perform any action on Analysis Services you get weird Error...
Author: Karan Gulati (SSAS Maestro) Date: 08/11/2010
Migrating OLAP SSAS 2005 Database to SQL 2008
This blog talks about different procedures of moving SSAS 2005 Databases to SQL 2008...
Author: Karan Gulati (SSAS Maestro) Date: 08/10/2010
Running AS Command(XMLA / MDX) as a Batch Job Using SSIS Package
- Get ASCMD for right version 2008 2005 -Create a file with XMLA / MDX Command and give extension as...
Author: Karan Gulati (SSAS Maestro) Date: 07/17/2010