As a response to a comment on a previous blog post on how to extract SSAS Multidimensional [MD] databases with PowerShell, I decided to write a new blog post, to address the tabular version [Tab]. The main differences working with MD and Tab, programatically, is that MD is represented by XML for Analysis and Tab […]
Tag: SSAS
SSAS(MD) Time Intelligence w/ a Twist
Introduction There are a lot of great examples out there on how to build your own custom Time Intelligence into Analysis Services (MD). Just have a look at this, this, this, this and this. All good sources for solid Time Intelligence in SSAS. One thing they have in common though, is that they all make […]
T-SQL Tuesday #85- SSAS(MD) Backup Galore
This months T-SQL Tuesday is hosted by Kenneth Fisher(b|l|t) and the invitation is found following this link. T-SQL Tuesday was started by Adam Machanic (b|t), and this is the SQL Server community’s monthly blog party, where everyone is invited to write about a single common topic. This time, the topic is Backup (and Recovery). Admitted, […]
How to fire up Azure Analysis Services
This is my twelfth (12th) post in 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 blog category of mine, but I can assure, it’ll be focused on SQL Server stuff. This time it’s going to be about […]
Testing your SSAS partitioning strategy w/ PowerShell
During a presentation of mine, there was a discussion going on, about what partitioning strategy to use when partitioning cubes. Most frequently it seems people are partitioning by some form of period, e.g. by Years, Months or Weeks. Rationally it may seem like a good idea, at the time. But wouldn’t it be a more fact based approach […]