For the most part, creating a dimension for SSAS is an easy wizard driven process. However, there’s some important steps…
Setting up a new SSAS Multidimensional project in SSDT is pretty straight forward. There’s a few things to do before…
There seems to be a bug with SQL Server Data Tools 15.8.1+ and the ODBC Destination task. SSIS reports an error…
My company has several reports on a shared subscription setup to send once a day. Recently, two of these reports…
Backing up an SSAS database is an important part of a data warehouse maintenance plan. The backup process is straightforward…
Relog is a command line tool that you use to convert the file output created by Perfmon. It can convert…
A data collector set is a collection of saved perfmon counters. Once a data collector set is created it can…
Cancelling a query in SSAS is not as straight forward it should be. There’s not an activity monitor for SSAS…
Brief Overview of SSAS DMVs DMVs are really just queries that return information about the server. Introduced in SQL Server…
The counters can be grouped in general categories; OS, Processing, and Query. SSAS is a service running on a Windows OS. …