Mining Structure: Issue while Processing when DataSource is OLAP Cube

  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 Full Permission on OLAP Cube then processing will fail with below mentioned error: Errors and Warnings…

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 adding this post with Screen Shots. A BI semantic model connection is created in SharePoint and provides redirection to business intelligence semantic model data in a PowerPivot workbook or Analysis Services tabular model database on a network…


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 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",([Internet Total Tax Amount])) Red Box shows the sub-total of Categories further Brown Box shows Total of all Categories across all years.



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>[, <name>, <expression>]…) Demo – The Following example returns summary of the Internet Sales grouped around Country, Category…

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 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. ABC is more than just a…

SQL Server 2012 Virtual Labs

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 that you can complete in 90 minutes or less. There is no complex setup…


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… starting my new blog on My this blog  is still alive and will do cross posting there.