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 […]
Tag: SSAS
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 […]
Continuous Delivery w/ Analysis Services and Visual Studio Online
Recently I have unlocked a new and long-awaited achievement and I felt so happy about it, that I had to do a blog post on it. I’ve known a couple of developers through my career, including myself, who was dreading the moment when they had to release/deploy a new version of the cube into production. In […]