Qlikview is for "personal" analytics. SSAS is for designed for a broader range : from "workgroup" analytics up to "enterprise" level.

I have just helped a client (Fortune 100) recover from...

Late comment, but for people looking at this post.... Pyramid Analytics is the best Analysis Serivces (SSAS) client tool on the market today for browsing OLAP cubes.

😎

The answer is that Excel produces overly complex and generally inefficient MDX. Its primarily designed to fit the somewhat "offbeat" requirements of the Excel Pivot Table - rather than the...

Actions are "extended" functions added to cubes by cube designers. They can be attached to many aspects of a cube: members, levels, dimensions, cells and the cube itself. They are...

Look for a book by "George Spofford" (http://www.amazon.com/MDX-Solutions-Microsoft-Analysis-Services/dp/0471748080)

You should also find yourself some good supporting tools that can help you generate MDX.

You'll need a viewing tool: Excel...

Check out Pyramid Analytics.

Possibly the best tool for viewing an Analysis Services cube... by far.

🙂

Your approach would be overly cumbersome.

The piece you're missing is that SSRS really sucks as means for viewing cubes. You need to get your hands on a better application that...

just thought I'd add my 2 cents:

Pyramid Analytics.... a super OLAP tool.