Using Power Pivot can provide insight into your data from sales to system monitoring. Your users can use Power Pivot to quickly create dashboard-like reports that show trending on your data over time. Additionally, with the use of KPIs (Key…
Monthly Archives: July 2014
Cannot Show Requested Dialog Error – SQL Server Management Studio
by Alan Faulkner • • 0 Comments
Problem After a recent installation of SQL Server 2012, I encountered an error I haven’t run into before. The error “Cannot show requested dialog.” Cause When you check database properties (in my case SSAS Mutlidimensional instance), SSMS runs queries against…
Installing SQL Server 2012 SSAS Tabular Mode
by Alan Faulkner • • 0 Comments
In this post we will cover the step-by-step process to install SQL Server 2012 Analysis Services in Tabular Mode. This post assumes that you have already gone through the process of installing a SQL Server 2012 Analysis Services multi-dimensional instance.…