Wednesday, September 24, 2014

Missing SSIS toolbox

The other day I couldn't find the toolbox to add a component, so I followed these instructions. Basically a right click is enough, but I'm still learning the ropes:

Friday, September 5, 2014

Debugging MDX queries

To put it simple, IT IS NOT POSSIBLE. I came across this tool but it didn't help me a lot. What helped me was this article which talks about using the Generate aggregate function to generate "logs".

It helped me find an incorrect sum in an mdx query, so I highly recommend this technique.

Tuesday, September 2, 2014

An MDX alternative to DistinctCount in SSAS

I got started using SSAS and SSIS, and needed to implement a DistinctCount in an MDX query. Eventually (after a few hours) I came up with a solution, and a few days later found the solution here: