Newbie to MDX and cube

Question

Hi all

I have been developing reports in report builder 2.0 for the last year using SQL but I am being moved on to a cube so I going to have to re-write about 20 reports. I am fairly new to the concept of MDX and I am slowly getting my head around it by using the adventure works but of course there is nothing quite like seeing it in relation to your own work.

I have a report where I want to bring back specific Merchants and their Category code whilst returning the transaction amount for them.

The cube would consist if this.

[measure].[transactionamount]

Dimension [merchantname]

Dimension [Merchant Category Code]

 

so for example I would want to bring back the following details.

[merchantname]         [merchant cateogry code]    [transactionamount]

Vodafone                        4814                                 >0

Argos                             7599                                 >200

Ryanair                          3031                                 >500

 

I am not sure of the best way to go about doing this?

 

Regards

Answer 1

The report rdls can be added to the report designer and the queries on cube can be built using the MDX query designer.

 

---

Happy to help! Thanks. Regards and good Wishes, Deepak. In a revamp of my Blog!

Answer 2

So what would be the best way to produce the report setting up parameters for the different merchants etc? The merchants have set transactionamounts that I would require bringing back so am wondering how this would be achieved

Answer 3

Further the report can be extended to include the parameters in the report designer. The MDX query can be take input parameters in the form of expressions. Check  this : http://social.msdn.microsoft.com/Forums/en-US/sqlreportingservices/thread/cf0ef6ba-d128-4acf-899d-48df71c60296

---

Happy to help! Thanks. Regards and good Wishes, Deepak. In a revamp of my Blog!

Answer 4

So what would be the best way to produce the report setting up parameters for the different merchants etc? The merchants have set transactionamounts that I would require bringing back so am wondering how this would be achieved

Hi aivoryuk,

It seems that you want to pass the parameter value to the MDX to filter the records belonged to this special merchant, right? If that is the case, I would recommend you read this document about how to define a query parameter in MDX for reporting servcies http://technet.microsoft.com/en-us/library/ms156303.aspx

If I misunderstand you, please feel fee to let us know.

---

Please remember to mark the replies as answers if they help and unmark them if they provide no help.