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:

http://geekswithblogs.net/AskPaula/archive/2013/07/11/153385.aspx

Friday, September 5, 2014

Debugging MDX queries

To put it simple, IT IS NOT POSSIBLE. I came across this tool http://www.sqlbi.com/tools/mdx-studio/ but it didn't help me a lot. What helped me was this article http://blogs.adatis.co.uk/blogs/jeremykashel/archive/2013/06/14/debug-mdx-with-generate.aspx 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:

http://richardlees.blogspot.mx/2008/10/alternative-to-physical-distinct-count.html