Tag Archives: SSAS

A Hello World Custom Assembly in SSAS

This is my second post i a series of entry-level posts, as suggested by Tim Ford (b|l|t) in this challenge. I have not set any scope for the topics of my, at least, twelve (12) posts in this new blog category of mine, but … Continue reading

Posted in Entry Level, Programming | Tagged , , | Leave a comment

Permission Scope in Analysis Services

This is my first post i a series of entry-level posts, as suggested by Tim Ford (b|l|t) in this challenge. I have not set any scope for the topics of my, at least, twelve (12) posts in this new blog category of mine, but I … Continue reading

Posted in Entry Level, Programming | Tagged , , | Leave a comment

Using PowerShell to Discover Temp/Log/Backup and Data Directories of SSAS

Objective: Locate all folders related to SQL Server Analysis Services (SSAS) on disclosed servers. During a massive cleanup on some of our environments, I was asked to point out all the possible locations of SSAS related files on a list of 10+ … Continue reading

Posted in Programming | Tagged , , | Leave a comment

Extracting SSAS Database(s) XMLA w/ PowerShell

For some time, we have been trying to get Informatica’s Metadata Manager to extract information from our SSIS, SSRS and SSAS instances in production. However, we were facing issues with credentials and service account clashes that lead us to just … Continue reading

Posted in Programming | Tagged , , | Leave a comment

How to Change the Service Account for Analysis Services

As part of a routine check, I found that one of our servers had an instance of Analysis Services (SSAS) running under a local service account. As many of our solution pull data from various sources, on other servers, there is … Continue reading

Posted in Programming | Tagged , , | Leave a comment