Tabular: .Net Provider supported by Tabular Mode

  Yes, tabular server supports .Net Provider but only for those Data Sources which are mentioned in this article –  Data Sources Supported (SSAS Tabular) Take an example of Oracle, if you select Oracle in “Table Import Wizard” and click on Next, you will find Connect to an Oracle Database Windows -> on that windows…


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: Tabular models hosted in SQL Server 2012 Analysis Service provide a comparatively lightweight, easy to build and deploy solution for business intelligence. However, as you increase the data load, add more users, or run complex queries, you need to have a…


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, we are getting the following  error; however, preview shows the data correctly: Error Message: OLE DB or ODBC error: [Microsoft][ODBC Driver Manager] The specified DSN contains an architecture mismatch between the Driver and Application; IM014….


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 Power View reports against existing Cubes. Refer this blog for further information:


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 CalendarYear,color,sum(SalesAmount) from [DimProduct] join FactInternetSales on DimProduct.[ProductKey]=FactInternetSales.[ProductKey] join DimDate on dimdate.datekey=FactInternetSales.OrderDatekey Group by CalendarYear,color Having sum(salesamount)>5000 order by CalendarYear,color   Equivalent Dax of achieving same is: evaluate( filter (summarize (‘Internet Sales’, ‘Date'[Calendar Year], ‘Product'[Color] ,"Sales Amount",sum(‘Internet…


PowerShell:How to List Database Roles and their Members

1: [Reflection.Assembly]::LoadWithPartialName("Microsoft.AnalysisServices") 2: $ServerName = ".\sql2008r2" 3: $DB = "Adventure Works DW 2008" 4: $Server = New-Object Microsoft.AnalysisServices.Server 5: $Server.Connect($ServerName) 6: $SSASDatabase = $Server.Databases.Item($DB) 7: $SSASDatabase.Roles | Select Name, Members


SSAS Crashing Intermittently: Caused by Monitoring / AV Scans

Problem Description: Analysis Services is crashing intermittently and also producing min-dumps. Assessment: This could be one of the issues. For getting full analysis of Mini-Dump you can involve Microsoft Customer Support Services and ask them to analyze dumps. In this case we found: The issue is SMS client (CcmExec) does software inventory periodically, and it…


Hardware Sizing a Tabular Solution (SQL Server Analysis Services)

Applies to: SQL Server 2012 Analysis Services, Tabular Solutions Summary: Provides guidance for estimating the hardware requirements needed to support processing and query workloads for an Analysis Services tabular solution. Download from here (Hardware Sizing a Tabular Solution (SQL Server Analysis Services) Word document.