For enabling Verbose Logging follow these steps - Go to Central Admin and Click on Monitoring Click on Configure Diagnostic Logging Enable Verbose Logging as shown below – Here I have enabled Logging for Excel and PowerPivot Set  Least Critical Event...

ProcessUpdate applies only to Dimension. It is the equivalent of incremental dimension processing in Analysis Services 2000. It sends SQL queries to read the entire dimension table and applies the changes—member updates, additions, deletions. ...

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: Using Excel 2010 when try to save a file to SharePoint Gallery it fails with error stating: Excel 2010 –>File –>Save to SharePoint Error Resolution - When accessing these files from a SharePoint document library, the ACE provider will attempt...

  When processing SSAS Data Mining Structure which is based on a Cube (DataSource is Used as Cube) in such a case Analysis Services uses service Startup Account while processing Mining Structure. If Analysis Services Startup Account doesn’t have...

  I had hard time in performing these steps in the absence of Screen Shots, so thought of adding this post with Screen Shots. A BI semantic model connection is created in SharePoint and provides redirection to business intelligence semantic model...

Can get great performance during Excel Operations by enabling Multi Thread in Excel. How to Set Number of Threads - Office Button=> Excel Options=>Advanced=>Formulas ' Enable multi = threaded

  The following example adds roll-up rows to the Group-By columns of the SUMMARIZE function call. EVALUATE SUMMARIZE( 'Internet Sales', ROLLUP ('Date'[Calendar Year],Product[Product Category Name]), "Sales", ([Internet Total Sales]), "Tax"...

SUMMARIZE function returns a summary table for the requested totals over a set of groups. Readers familiar with T-SQL SELECT statement, this is the equivalent of writing a query using the GROUP BY clause. Syntax - SUMMARIZE(<table>, <groupBy_columnName>...

Windows Azure Boot Camp is a two day deep dive class to get you up to speed on developing for Windows Azure. The class includes a trainer with deep real world experience with Azure, as well as a series of labs so you can practice what you just learned...

One place where you can learn all new features of SQL 12 without even installing single component on your machine. Virtual Labs enable you to quickly evaluate and test Microsoft's newest products and technologies through a series of guided, hands-on labs...

Few of my friends have been blogging on WordPress and I heard good feedback about it. So, here I am… starting my new blog on http://karanspeaks.com My this blog http://blogs.msdn.com/karang   is still alive and will do cross posting there.

Click 1 – Create a Tabular Project Click 2 – Import Tables (Master / Facts) from DW Click 3 – Adding Measure As you can see I have added 2 Measures - Sum (TotalProductCost) Sum of TotalProductCost:=SUM([TotalProductCost]) Sum of SalesAmount:=SUM([SalesAmount...

Problem Description: Automate the steps of 1. Connecting to SSMS 2. Select Cube 3. Right click and generate XMLA “Create Cube” 4. Schedule from SQL Job agent For last few days I was playing around with PowerShell so thought of achieving this using PS...

  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...

WITH MEMBER [Date].[Calendar Year].[2006VS2007] AS [Date].[Calendar].[Calendar Year].&[2007] / [Date].[Calendar].[Calendar Year].&[2006], FORMAT_STRING = 'Percent' SELECT { [Date].[Calendar Year].[Calendar Year].&[2006], [Date].[Calendar Year...

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 shows how to use Head, Order, Filter & TopCount Function.   Reseller Order Count Classic Vest, S 514 Short-Sleeve Classic Jersey, XL 495 Hitch Rack - 4-Bike 468 AWC Logo Cap 460 Long-Sleeve Logo Jersey, L 451 Water Bottle - 30 oz...

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...

  By default, sets are evaluated within the context of the cube that contains the members of the set. The Existing keyword forces a specified set to be evaluated within the current context instead.   with member [Measures].[k] as ([Product]...

  Issue: If you have a partition file, which is larger than 2GB in size and you may receive below error when you try to run a MDX query against this particular partition (> 2GB) AFTER restoring this database from the backup. You want to move ...

Often time I been asked this quest - what will be the impact of processadd on indexes or aggregations, do I need to recreate aggregations or Indexes after creating Process Update or what is the right approach of handling processing, so thought of writing...

  On a clustered instance, Analysis Services will listen on all IP addresses of the cluster group, but only on TCP port 2383. You cannot specify an alternate fixed port for a clustered instance Steps of making AS Clustered Instance Listening on Multiple...