Using Dynamic MDX in Reporting Services: Part 2

re: Using Dynamic MDX in Reporting Services: Part 2

Omar — Sat, 09 Oct 2010 10:31:33 GMT

Awesome work Stacia, very useful information indeed!

re: Using Dynamic MDX in Reporting Services: Part 2

oti — Sat, 09 Oct 2010 19:02:21 GMT

This is powerful...thank you!!!!

re: Using Dynamic MDX in Reporting Services: Part 2

Vussy — Wed, 13 Oct 2010 12:22:34 GMT

Great Stuff ...Many thanks ☺

re: Using Dynamic MDX in Reporting Services: Part 2

Sneha — Wed, 09 Feb 2011 11:03:31 GMT

Gr8 help...thanks a lot

re: Using Dynamic MDX in Reporting Services: Part 2

Pravin Patel — Mon, 21 Feb 2011 12:47:57 GMT

It is really usefull,

Thanks.

re: Using Dynamic MDX in Reporting Services: Part 2

anthony — Thu, 29 Sep 2011 21:17:35 GMT

I'm trying to simply find a way to place a value from my cube into the cell of a report. For example. There is a measure called employee hours, and it is in a hierarchy of CATEGORY >> TYPE.

How do I create an expression for the cell that says just choose the value of type "PTO", etc.?

I can't find any reference anywhere?

re: Using Dynamic MDX in Reporting Services: Part 2

smisner — Wed, 19 Oct 2011 21:27:02 GMT

Anthony,

That's not an easy question to answer. In general, you create a dataset that queries the cube, which then provides you with a set of fields that you can then place into your report. You will have to construct your query so that you have one field for your measure and one field for the type. You can filter the query to get only type PTO, or filter the tablix containing the cell. Or use an IIF expression to display the measure value in the cell when the type is PTO.

re: Using Dynamic MDX in Reporting Services: Part 2

Dave Lowe — Sat, 11 Feb 2012 11:11:44 GMT

This was really helpful thanks Stacia. I eschewed VB (and VBA) a number of years ago so going back was a bit of pain but the techniques you demonstrated here helped me immensely. Hoping 2012 will support c#. Thanks Stacia

re: Using Dynamic MDX in Reporting Services: Part 2

smisner — Sat, 11 Feb 2012 19:25:10 GMT

Glad to help, Dave. No support for C# in 2012 - at least not directly. You could always use a custom assembly in Reporting Services if you really need to do something in C#, but that wouldn't make sense to do so if there were a built-in way to accomplish the same thing.

re: Using Dynamic MDX in Reporting Services: Part 2

Lidou123 — Fri, 01 Feb 2013 13:19:34 GMT

Thank U for this post.

very Intesting. So Is it possible to put parameters in the MDX Script ?without using the SSRS query builder ?

re: Using Dynamic MDX in Reporting Services: Part 2

smisner — Tue, 05 Feb 2013 04:24:07 GMT

Hi Lidou123 - Do you really mean MDX script? That term applies to the calculations, named sets, and KPIs that one adds to the cube definition and doesn't involve the SSRS query builder in any way. Is that what you mean or do you mean something else? If you mean the MDX script, the answer is no - it is not possible to use parameters there.

Now if you mean the text editor (type it in yourself) for the query rather than the query designer (drag and drop), the answer is yes you can. There is a button in the toolbar that you can use to map a default value to the parameter.