SSAS Synchronization: Across different versions

  Problem Statement: Synchronization between different builds or versions of Analysis Services. Solution: The Synchronize Database Wizard makes two Microsoft SQL Server Analysis Services databases equivalent by copying the data and metadata from a source server to a destination server. This read more

0

SSAS encryption

Description: Customer asking if AS supports TDE like encryption we got in SQL Engine. Solution: SSAS doesn’t support any data encryption on disk, in simple words – SSAS doesn’t do any kind of encryption. What it supports: HTTPS – You can use Analysis Services using PUMP and configure pump with HTTPS Windows File System encryption …

0

SSAS Data Collection: Collecting Perfmon for SSAS

Applies to Windows7, Windows 2008/R2 and Vista SQL Server all builds >= SQL 2005 Generally, for troubleshooting SSAS Issues, we recommend to collect below mentioned Perfmon Counters – All Counters Related to SSAS (MSAS_ or MSOLP$) For default instance SSAS Counter Name suffix with MSAS.n and for named instance it start with MSOLAP$Instance Name –…

0

Getting Deadlock Error During Processing

Issue: Intermittently Getting below mentioned error during processing OLE DB error: OLE DB or ODBC error. Transaction (Process ID n) was deadlocked on thread| communication buffer resources with another process and has been chosen as the deadlock victim. Cause: A deadlock is a circular blocking chain, where two or more spids are each blocked by…

1

SSDT Query Builder: MDX Query returning NULL instead of AllMembers

  *SSDT – SQL Server Data Tools *SSMS – SQL Server Management Studio In SSDT Query Designer getting Null for All members: One of my customers recently reported this issue so thought of sharing with world…… Demo given below will provide an insight…………… Simple query, where we are doing cross join of allmembers from Product…

0

Configuring: PowerPivot for Excel 2013

  For configuring PowerPivot in Excel 2013 you need to follow below mentioned steps: In Excel 2013 By default PowerPivot add-in is disabled and you need to enable it manually – 1) File –> Options –> Add-in –>Manage Select (Com Add-Ins)   2) After Selecting Com Add-in click GO, by default Add-ins are disabled Further…

1

How to use Network Monitor to capture network traffic

  Often I need to share these steps with customers while troubleshooting Connectivity issues, so thought to write an article with screenshots which will ease in collecting traces: Please go to the following URL and install the latest version of Network Monitor 3.4 , make sure you download the right version depending upon your machine’…

1

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…

0

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…

0

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…

0