Power View Infrastructure Configuration and Installation: Step-by-Step and Scripts

Power View implementation paper is out and covers major scenarios of implementing Power View with PowerPivot and Tabular Server including Kerberos. Power View Infrastructure Configuration and Installation: Step-by-Step and Scripts http://msdn.microsoft.com/en-us/library/jj591528 Scenario 1: Install a SharePoint 2010 Farm, Add the Power View and PowerPivot Infrastructure, and an Analysis Services Tabular Instance Scenario 2: Add the…


SSAS:Informative Links

  SSAS 2012 Links Free SQL 2012 EBook SQL 2012 Virtual Labs DAX in the BI Tabular Model Whitepaper and Samples SSAS Administration Analysis Services 2008 R2 Operation Guide Automating SSAS Backup SSAS Performance Analysis Services 2008 R2 Performance Guide Tutorials SQL Server Analysis Services Tutorial (2008R2) SSAS 2012 – Multidimensional Modeling SSAS 2012 -Tabular…


SSAS: All Possible Scenarios of Changing SSAS Data Folder

Title – All Possible Scenarios of Changing SSAS Data Directories Scenario 1: Recreating a New Data Folder in New Drive / Same Drive Creating a New Data Folder and changing the Data File Location in configuration files as shown below – 1. Connect to your Analysis Server in SSMS with a user that is a…


SSAS Monitoring Tool– ASTrace

Guys, We have noticed customers asking a tool for  Monitoring SSAS Activities;  So we have added new features to an existing ASTrace of SQL 2005 and introduced a new version for SQL 2008/R2 & SQL 2012(MOLAP and Tabular). With this tool you can monitor minimum to maximum SSAS Information.  Architecture is pretty simple, ASTrace runs…


PowerPivot–Enable Logging

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 to report to the Event Log and Trace Log to Verbose as shown below…



  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. Since ProcessUpdate reads the entire dimension table, it begs the question, “How is it different from ProcessFull?” The difference is…


XMLA– Clear Analysis Services (SSAS) database cache

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> </ClearCache>   How to clear cache of a Database <ClearCache xmlns="http://schemas.microsoft.com/analysisservices/2003/engine"> <Object> <DatabaseID>Adventure Works DW</DatabaseID> </Object> </ClearCache>


SSAS Tip – IndexBuildThreashold

<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>, with a default of 4096. Partitions with fewer rows will not have indexes built. Which means if you have less than 4096 records in a Partition you will…


Step by Step Guide of Installing Power View with PowerPivot 2012

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  SP2010 , Apply SP1, Apply Latest CU (guess latest released in Jan 2012)…


PowerPivot: Error while saving a file to PowerPivot Gallery

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 to connect to the library using a WebDAV client connection, which is not available…