Our SSAS Experience

Prodata developed their first enterprise SSAS model in 1999 using OLAP 7.0 to analyze high volumes of data in the Telco sector.

We build all of our semantic models (whether Tabular or MOLAP) as a true craftsmen with careful attention to detail such as hierarchies, key/name pairs, referential integrity, naming conventions, flexible and automated star schema modelling, expert DAX knowledge and innovative design patterns for Finance and other verticals.

We have been at the forefront of Analysis Services in Ireland. with highlights such as:

  • First and only SSAS Maestro Certified Architect in Ireland. This was Microsoft’s highest certification for Analysis Services achieved by only a handful of people globally.
  • Only MS Partner to achieve “Expert GOLD” status in Business Intelligence and SSAS. Microsoft recognized BI partners delivering the very highest quality experts via the Maestro certification.
  • Presented at PASS Global Summit on Load Testing Analysis Services at massive concurrency
  • Helped design and Build Europe’s largest SSAS Farm
  • Presented at SqlBits on Optimizing Cube Processing
  • Brought world class DAX and SSAS training to Ireland with our friends in SQLBI and Chris Webb.

We have build semantic models in Tabular, PowerBI and MOLAP engines to support tens of thousands of users over multiple TB’s of data in sub second response time.

Some of our public presentations available online are below

Load Testing Analysis Services

Optimising Cube Processing

Blog Posts on SSAS

Should I use HideMemberIf for Tabular Model

With a “ragged” hierarchy we often need a way to make sure that the hierarchy is displayed in a user friendly fashion when measures can be linked to any level (including parents). There are two established solutions 1) The Pure…

Solved: slow SSAS connections on Hyper-V

Over the last few months we have been developing reporting services reports on top of a SSAS tabular model. One of the banes of my life has been the unusable performance of our reports, especially if they open a lot…

Load Testing SSAS in Oslo

Thanks for everyone who made it to my SQL Saturday Session in Olso today on load testing Analysis Services. If you are interested in getting started to building a load test harness in visual studio, I have attached the source…

Capturing a Service Side Trace for MDX<

When you need to do load testing for Analysis Services its common to need to capture and “replay” MDX queries. I’ll go into replay tools later – the first step is to capture the queries. You will need An XMLA…

Optimising Cube Processing @SqlBits

Thanks to everyone who made it to my session at SqlBits. I’m hanging around the event so feel free to ping my on twitter (@bob_duffy) if you want to chat about Cube Processing over a beet at the event. I…

How to turn off/on bitmap indexes in SSAS

Bitmap Indexes (*.map files) play an important role within Analysis Services. They provide a mechanism for the storage engine sub cube event to efficiently locate the relevant segments within the fact file without having to scan the whole thing. This…

Cube Processing Deep Dive

Thanks to everyone who came to the Dublin SQL UG last night! here’s a link for the slides from the session Best Regards, Bob

Tool for baselining MOLAP Processing

You are given a cube you have never seen before and need to make it process faster – where do you start ? Do we add indexes to the data warehouse, add faster disks, delete some aggregations, add more memory, or start…

#sqlsat278 Budapest Load Testing SSAS Content

In my session on load testing analysis services we cover a few areas: How to create unit tests for Analysis Services using a variety of tools How to capture and analyse a workload using a service side trace How to…

Tabular Model Partitioning to help Developers

Developing Tabular models in Visual studio can be super painful as the interface gets very “sluggish” as tables get larger. in some cases customers have told me they wait 5-10 minutes a go to say change the name of a…

Disk Space Analyser for Analysis Services (MOLAP)

When reviewing design or performance of a MOLAP analysis services database we need to determine where the space. Common problems are: We have too many or too large aggregations If we have too many bitmap indexes Large attributes with string…

Load Test Tools for Analysis Services

When evaluating load test tools for Analysis Services, there are number of tools available on codeplex or you can roll your own using a load testing suite such as Visual Studio Test Edition. What do you need out of a…


Something went wrong. Please refresh the page and/or try again.