Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Daniel98
Starting Member
2 Posts |
 Posted - 2010-06-14 : 11:32:55
|
| 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.SELECT {( ([Questionnaire].[Questionnaire Question Order].CHILDREN) * ([Questionnaire].[Question Code].CHILDREN )* ([Questionnaire].[Question Code Suffix].CHILDREN) * ([Questionnaire].[Question Response Code].CHILDREN), [Measures].[Survey Count] )} ON COLUMNS, NON EMPTY { ([Demographic].[Gender].CHILDREN * [Customer].[First Name].CHILDREN * [Customer].[Last Name].CHILDREN * [Customer].[Last Name2].CHILDREN * [Customer].[Address1].CHILDREN * [Customer].[Address2].CHILDREN * [Customer].[Address3].CHILDREN * [Customer].[Address4].CHILDREN * [Customer].[Postal Code].CHILDREN * [Customer].[Phone Number1].CHILDREN * [Customer].[Phone Number2].CHILDREN * [Customer].[Phone Number3].CHILDREN * [Customer].[Email].CHILDREN * [Customer].[Language Code].CHILDREN * [Customer].[Iso Country Code].CHILDREN * [Transaction Date].[Date].CHILDREN * [Dealer].[Dealer Code].CHILDREN * [Vehicle].[Vin].CHILDREN * [Sample].[Registration Number].CHILDREN * [Receipt Date].[Date].CHILDREN * [Cati Start Time].[Time].CHILDREN * [Cati End Time].[Time].CHILDREN )} ON ROWS FROM ( SELECT ( { [Report Period].[Report Period Type].&[Month] } ) ON COLUMNS FROM ( SELECT ( { [Report Period].[Report Period Name].&[Apr-10] } ) ON COLUMNS FROM [PET CO])) WHERE [Questionnaire].[Questionnaire Type].&[Sales] |
|
|
Daniel98
Starting Member
2 Posts |
Posted - 2010-06-16 : 08:35:44
|
| Yet to fix the broken code. Ideas please |
 |
|
|
|
|
|
MDX Ideas needed