How to clear cache of a cube <ClearCache xmlns=" http://schemas.microsoft.com/analysisservices/2003/engine "> <Object> <DatabaseID>Adventure Works DW</DatabaseID> <CubeID>Adventure Works DW</CubeID> </Object>...

<IndexBuildThreshold> Index creation is controlled by the number of rows, specified in the msmdsrv.ini (default location of msmdsrv.ini file – ?: \Program Files\Microsoft SQL Server\MSAS10_50.SQL2008R2\OLAP\Config\msmdsrv.ini ) file as <IndexBuildThreshold>...

Install Win 2008 R2 + SP1 Roles IIS Add .Net Framework 3.5 Features Features Add Desktop Experience (needs reboot) Install SQL Server 2012 (default instance) Note: Few things which we need to keep in mind during installation – (New Farm) - Install ...

  Issue: Environment consists of 2 nodes, SQL and SSAS 2008 can failover between the 2 nodes, and accessible for queries. All the drives and mount points come online on the nodes after failover. SQL Server Fails over perfectly. The Windows Cluster...

Nonempty Returns the set of tuples that are not empty from a specified set, based on the cross product of the specified set with a second set. NONEMPTY(set_expression1 [,set_expression2]) set_expression1 A valid Multidimensional Expressions (MDX) expression...

This example shows how to use Descendant function with Desc_Flag as self_before_after which means this will show all members at level - Subcategory_Category_Product. and to prove that we are getting correct result I am using Member Property - Level which...

  Environment Domain A Server A - Project server and Web Server Server B- SQL Analysis Services server Domain B Clients  / Users Users accessing Project Server via. HTTP Domain Relationship Both the domains (Domain A & B) are on Intranet...

Background: Windows 2003x64, SQL 2005 SSAS with Dimension Security Enabled In this scenario when we were opening an Excel Report deployed on  SharePoint it hangs the report when we try to expand the user hierarchy Resolution To work around this issue...

We had seen scenarios where Excel Sheet with Pivot table takes less time locally but over Wan it takes more than hour to refresh. The issue which we fixed was on Excel 2007 with SQL 2008 AS (Cube had Cell Level Security Enabled) The resetting of the connection...

  In this example we are trying to pull ytd based on current date using Now Function.   with member [Date].[Calendar].[currentyear] as aggregate(ytd((strtomember("[Date].[Calendar].[Date].&["+format(now(),"yyyyMMdd")...

Surrogate Keys Also known as meaningless keys, substitute keys, non-natural keys, or artificial keys. A surrogate key is a unique value, usually an integer, assigned to each row in the dimension. This surrogate key becomes the primary key of the dimension...

  Attribute Key Not found Error occurs in SSAS due to the following reasons : Dimensions processed after measure groups (This one is simple, just process Dimension before processing a Cube) Presence of Orphan Records in Fact Table  (This one...

Well one of my customers had asked the as significance of this property as he didn’t find anything on net so thought of writing an article about it. http://blogs.msdn.com/b/karang/archive/2010/08/16/sql-server-deployment-property-retain-configuration...

  I had seen few scenario where you perform any action on Analysis Services you get weird Error Message like some store is corrupted Sample Error: An error occurred when instantiating a metadata object from the file, '\\?\J:\Program Files\Microsoft...

  This blog talks about different procedures of moving SSAS 2005 Databases to SQL 2008 Databases Question: How to Migrate Database from SQL 2005 to SQL 2008 Scenario 1 - Moving SSAS Databases from SQL 2005 SSAS to another Server where we have SSAS...

- Get ASCMD for right version 2008 2005 -Create a file with XMLA / MDX Command and give extension as xmla/mdx -Create one batch file with command with text as d:\asjob\ascmd -S karan2k8-64\sql2005 -i d:\asjob\backup.xmla In my instance...