SQL BI
My Experience - Troubleshooting SQL BI Stack
Add a BI Semantic Model Connection Content Type to a Library (PowerPivot for SharePoint)
I had hard time in performing these steps in the absence of Screen Shots, so thought of...
Author: Karan Gulati (SSAS Maestro) Date: 01/27/2012
Excel: How to Enable Multi Thread in Excel 2010
Can get great performance during Excel Operations by enabling Multi Thread in Excel. How to Set...
Author: Karan Gulati (SSAS Maestro) Date: 01/26/2012
DAX-SUMMARIZE (ROLLUP)
The following example adds roll-up rows to the Group-By columns of the SUMMARIZE function...
Author: Karan Gulati (SSAS Maestro) Date: 01/11/2012
What is a Windows Azure Boot Camp?
Windows Azure Boot Camp is a two day deep dive class to get you up to speed on developing for...
Author: Karan Gulati (SSAS Maestro) Date: 01/11/2012
SQL Server 2012 Virtual Labs
One place where you can learn all new features of SQL 12 without even installing single component on...
Author: Karan Gulati (SSAS Maestro) Date: 01/07/2012
You can also find me on wordpress…..
Few of my friends have been blogging on WordPress and I heard good feedback about it. So, here I am…...
Author: Karan Gulati (SSAS Maestro) Date: 01/07/2012
It takes 4 Clicks to Build a Model (Cube) in Denali Tabular Mode
Click 1 – Create a Tabular Project Click 2 – Import Tables (Master / Facts) from DW Click 3 – Adding...
Author: Karan Gulati (SSAS Maestro) Date: 12/17/2011
PowerShell: Getting Cube XMLA
Problem Description: Automate the steps of 1. Connecting to SSMS 2. Select Cube 3. Right click and...
Author: Karan Gulati (SSAS Maestro) Date: 11/30/2011
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:Handling division by zero errors
WITH MEMBER [Date].[Calendar Year].[2006VS2007] AS [Date].[Calendar].[Calendar Year].&[2007] /...
Author: Karan Gulati (SSAS Maestro) Date: 11/28/2011
Top 10 products with Lowest Reseller Order count of at least 400.
This shows how to use Head, Order, Filter & TopCount Function. Reseller Order...
Author: Karan Gulati (SSAS Maestro) Date: 11/10/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: 09/30/2011
SSAS 2005 Backup/Restore Limitation
In SQL 2005, you may get below mentioned error after restoring SSAS Database using .abf file...
Author: Karan Gulati (SSAS Maestro) Date: 05/19/2011
Different Kinds of SSAS Processing in simple words…..
Often time I been asked this quest - what will be the impact of processadd on indexes or...
Author: Karan Gulati (SSAS Maestro) Date: 01/25/2011
Enabling SSAS Clustered Instance to listen on Multiple IP Addresses
On a clustered instance, Analysis Services will listen on all IP addresses of the cluster...
Author: Karan Gulati (SSAS Maestro) Date: 11/18/2010
YTD Based on Current System Date
with member [Date].[Calendar].[currentyear] as...
Author: Karan Gulati (SSAS Maestro) Date: 10/25/2010
During ETL detecting dirty records from Fact
Attribute Key Not found Error occurs in SSAS due to the following reasons : Dimensions processed...
Author: Karan Gulati (SSAS Maestro) Date: 10/02/2010
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: 09/29/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
Well one of my peer from Consulting team had asked this question tried looking for MSDN article but...
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
Updated SSAS Profiler Trace Scheduler Tool
Well few weeks back I had developed a tool with which we can Schedule SSAS Profiler Trace, based on...
Author: Karan Gulati (SSAS Maestro) Date: 04/30/2010
SSAS Profiler Scheduler
I have been asked by many customers and seen in many social sites, many people were asking about the...
Author: Karan Gulati (SSAS Maestro) Date: 03/30/2010
Moving Data Directory of Analysis Services (SQL 2005 / 2008)
Applies to (Data,Backup,Log & Temp) You cant move Bin and Config Directory Manually, recommended...
Author: Karan Gulati (SSAS Maestro) Date: 01/19/2010
Why do we need SPN for File Server (NAS / RAS / File Share System) DNS Alias (Cname)
Very often we use UNC location while taking backup of SQL or Analysis Services Database or try to...
Author: Karan Gulati (SSAS Maestro) Date: 12/12/2009
SQL 2005 (SQL 2008) Analysis Services Server Side Tracing
With Analysis Services 2005 (2008) you can collect traces without using gui this feature is known as...
Author: Karan Gulati (SSAS Maestro) Date: 11/02/2009
How to Warm AS Cache using SSIS Package
By following below mentioned steps we can warm AS Cache using SSIS Package by using Process Execute...
Author: Karan Gulati (SSAS Maestro) Date: 11/01/2009
Tampering master.vmp file may result in losing all Analysis Services Databases
The master.vmp file is the master version map that contains the GUIDS for all of the objects and the...
Author: Karan Gulati (SSAS Maestro) Date: 11/01/2009
Analysis Services Preallocate Memory Setting – Insight
Q: What is Preallocate Setting? Answers: Preaallocate Setting specifies a certain percentage of...
Author: Karan Gulati (SSAS Maestro) Date: 11/01/2009
SQL Server Analysis Services Port (SQL 2005 / 2008)
Default Port:2383 You can change default Port for AS in msmdsrv.ini file of the Instance. Port Used...
Author: Karan Gulati (SSAS Maestro) Date: 09/05/2009
Gemini (In-Memory Business Intelligence)
The key question behind Gemini is: how much value can an Excel user derive from Microsoft’s BI stack...
Author: Karan Gulati (SSAS Maestro) Date: 09/03/2009
SQL 2005 SPN (SSAS/SSRS/SQL)
What is SPN? An SPN is a unique identifier for a service on a network that uses Kerberos...
Author: Karan Gulati (SSAS Maestro) Date: 12/12/2008
SSAS(64 Bit) and Oracle Client Issues
While trying to create an Analysis Service Data Source that connects to Oracle using ORAOLEDB...
Author: Karan Gulati (SSAS Maestro) Date: 12/11/2008
SSAS Performance Counter Error while collecting BLG file Reference error message: Access is denied.
While Creating BLG file for SSAS counters getting below mentioned error message: System Log:Event...
Author: Karan Gulati (SSAS Maestro) Date: 12/11/2008
Configuring Datapump in IIS 7
Configuring HTTP Access to SQL Server 2005 or SQL 2008 Analysis Services on Microsoft Windows Server...
Author: Karan Gulati (SSAS Maestro) Date: 11/12/2008
SSAS 2005:Performance
Which Engine (Storage / Forumal) causing MDX Performance Issue? Improve MDX Performance
Author: Karan Gulati (SSAS Maestro) Date: 11/08/2008
Which Engine (Storage / Formula) causing MDX Performance Issue?
Follow below mentioned steps: -Set Profiler with Query Begin and Query End Event, Run Profiler Trace...
Author: Karan Gulati (SSAS Maestro) Date: 11/08/2008
SSAS:Informative Links
Links Related to Analysis Services: SQL Server 2005 Analysis Services Tutorial...
Author: Karan Gulati (SSAS Maestro) Date: 11/08/2008