Category Archives: SSAS

INVENTORY – SQL- SSAS – SSRS – Excel Output – Email

Posted on March 3, 2014 by Prashanth Jayaram

Inventory Inventory is a vital information,whether you’re a consultant or an in-house DBA, you need to have a reliable inventory of the servers you manage.This inventory can take any number of forms but, ideally, will allow some aggregation of information. When … Continue reading →

Posted in PowerShell, SQL, SSAS, SSRS, T-SQL | Tagged , , , , , , , | 2 Comments

SSAS – Automatic Inventory Generation – 24 Columns – HTML Attachment

Posted on June 18, 2013 by Prashanth Jayaram

Inventory is a vital information,whether you’re a consultant or an in-house DBA, you need to have a reliable inventory of the servers you manage. This inventory can take any number of forms but, ideally, will allow some aggregation of information. … Continue reading →

Posted in SSAS | Tagged , , , , , , , , | 1 Comment

SSAS Cube Backup strategies and Step by Step approach to setup and configure backup

Posted on June 5, 2013 by Prashanth Jayaram

There are different ways to take Cube database backups. SQL Agent Job XMLA script for backup ROBOT job ASCMD command SSIS Package SSIS package AMO (Analysis Management Objects) PowerShell Scripts I feel AMO (Analysis Management Objects) does our job much … Continue reading →

Posted in SSAS | Tagged | 8 Comments

SSAS – Find Cube Database Name, Size,Status and Total Size of SSAS Server

Posted on May 15, 2013 by Prashanth Jayaram

We are planning to take SSAS cube database backup since our backup tool does full file system backup in case of recovery, restoration is taking more time and hence as a first step we are started gathering the number of … Continue reading →

Posted in PowerShell, SSAS | Tagged , , | 4 Comments