Cannot use the below code in MDX Query designer because it screams at me saying that I have different dimensionality on columns.
I am assuming that I cannot use measures dimensions and dimensions together in query designer.
So I created an OLE DB data source connection. But the issue with that is the column fields i specified gets clubbed together. Like I get
Questionnaire.Questionnaire Question Order_1_Questionnaire.Question Code.CHILDREN. But I need individual fields to use in the report designer (tablix)
Please give me some ideas to solve this with either through MDX query designer or through using OLE DB source. I will return the favor someday. Thanks.