MDX query using measure groups from a ssas cube not giving me any values

Hi All,

I have a SSRS report that has dataset which contains MDX query that goes off against a SSAS cube I created. This report was an existing report with the same MDX query. Now when I run the report it does not give me any data. I have same measure groups name and I have it aggregated the same way as report is using those measure groups.  Question is do i have to rewrite MDX query again since cube is newly created and connections might have broken or something else? My understanding was that as long as both cube and report measure groups have same name, the report should work. I was trying to write SQL code instead of using MDX but I guess then why did I spend time creating cube when I will not use it.

Any help would be greatly appreciated.  

WITH MEMBER [Measures].[AutoInsPropertyThreshold] AS (([AceOpoly Goals].[Metric].&[Auto Insurance SMN]),[Measures].[Expected Goal]) MEMBER [Measures].[HomeInsPropertyThreshold] AS MAX((([AceOpoly Goals].[Metric].&[Home Insurance SMN]),[Measures].[Expected Goal])) MEMBER [Measures].[LifeInsPropertyThreshold] AS MAX((([AceOpoly Goals].[Metric].&[Life Insurance SMN]),[Measures].[Expected Goal])) MEMBER [Measures].[TravelPropertyThreshold] AS MAX((([AceOpoly Goals].[Metric].&[Travel SMN]),[Measures].[Expected Goal])) MEMBER [Measures].[AARPropertyThreshold] AS MAX((([AceOpoly Goals].[Metric].&[AAR]),[Measures].[Expected Goal])) MEMBER [Measures].[AssociateAddOnPropertyThreshold] AS MAX((([AceOpoly Goals].[Metric].&[Associate AddOn]),[Measures].[Expected Goal])) MEMBER [Measures].[AutoPayMembershipPropertyThreshold] AS MAX((([AceOpoly Goals].[Metric].&[Auto Pay Membership]),[Measures].[Expected Goal])) MEMBER [Measures].[CBSPropertyThreshold] AS MAX((([AceOpoly Goals].[Metric].&[CBS]),[Measures].[Expected Goal])) MEMBER [Measures].[CreditCardPropertyThreshold] AS MAX((([AceOpoly Goals].[Metric].&[Credit Card]),[Measures].[Expected Goal])) MEMBER [Measures].[DrivingSchoolRatioPropertyThreshold] AS (([AceOpoly Goals].[Metric].&[Driving School Ratio]),[Measures].[Expected Goal]) MEMBER [Measures].[DrivingSchoolReferralPropertyThreshold] AS MAX((([AceOpoly Goals].[Metric].&[Driving School Referral]),[Measures].[Expected Goal])) MEMBER [Measures].[PlusPremierPropertyThreshold] AS MAX((([AceOpoly Goals].[Metric].&[PlusPremier Upgrade]),[Measures].[Expected Goal])) MEMBER [Measures].[TeenOnboardPropertyThreshold] AS MAX((([AceOpoly Goals].[Metric].&[Teen Onboard]),[Measures].[Expected Goal])) MEMBER [Measures].[AutoInsHouseThreshold] AS MAX((([AceOpoly Goals].[Metric].&[Auto Insurance SMN]),[Measures].[Exceed Goal])) MEMBER [Measures].[AutoInsHotelThreshold] AS MAX((([AceOpoly Goals].[Metric].&[Auto Insurance SMN]),[Measures].[Distinguished Goal])) MEMBER [Measures].[AutoInsHouseOpportunity] AS MAX((([AceOpoly Goals].[Metric].&[Auto Insurance SMN]),[Measures].[Exceed Recurrence])) MEMBER [Measures].[AutoInsPropertyPay] AS (([AceOpoly Goals].[Metric].&[Auto Insurance SMN]),[Measures].[Expected Pay]) MEMBER [Measures].[AutoInsHotelOpportunity] AS (([AceOpoly Goals].[Metric].&[Auto Insurance SMN]),[Measures].[Distinguished Recurrence]) MEMBER [Measures].[HomeInsHouseThreshold] AS MAX((([AceOpoly Goals].[Metric].&[Home Insurance SMN]),[Measures].[Exceed Goal])) MEMBER [Measures].[AARHouseThreshold] AS MAX((([AceOpoly Goals].[Metric].&[AAR]),[Measures].[Exceed Goal])) MEMBER [Measures].[AssociateAddOnHouseThreshold] AS MAX((([AceOpoly Goals].[Metric].&[Associate AddOn]),[Measures].[Exceed Goal])) MEMBER [Measures].[AutoPayMembershipHouseThreshold] AS MAX((([AceOpoly Goals].[Metric].&[Auto Pay Membership]),[Measures].[Exceed Goal])) MEMBER [Measures].[CBSHouseThreshold] AS MAX((([AceOpoly Goals].[Metric].&[CBS]),[Measures].[Exceed Goal])) MEMBER [Measures].[CreditCardHouseThreshold] AS MAX((([AceOpoly Goals].[Metric].&[Credit Card]),[Measures].[Exceed Goal])) MEMBER [Measures].[LifeInsHouseThreshold] AS MAX((([AceOpoly Goals].[Metric].&[Life Insurance SMN]),[Measures].[Exceed Goal])) MEMBER [Measures].[PlusPremierHouseThreshold] AS MAX((([AceOpoly Goals].[Metric].&[PlusPremier Upgrade]),[Measures].[Exceed Goal])) MEMBER [Measures].[TeenOnboardHouseThreshold] AS MAX((([AceOpoly Goals].[Metric].&[Teen Onboard]),[Measures].[Exceed Goal])) MEMBER [Measures].[TravelHouseThreshold] AS MAX((([AceOpoly Goals].[Metric].&[Travel SMN]),[Measures].[Exceed Goal])) MEMBER [Measures].[HomeInsHouseOpportunity] AS MAX((([AceOpoly Goals].[Metric].&[Home Insurance SMN]),[Measures].[Exceed Recurrence])) MEMBER [Measures].[AARHotelThreshold] AS MAX((([AceOpoly Goals].[Metric].&[AAR]),[Measures].[Distinguished Goal])) MEMBER [Measures].[AssociateAddOnHotelThreshold] AS MAX((([AceOpoly Goals].[Metric].&[Associate AddOn]),[Measures].[Distinguished Goal])) MEMBER [Measures].[AutoPayMembershipHotelThreshold] AS MAX((([AceOpoly Goals].[Metric].&[Auto Pay Membership]),[Measures].[Distinguished Goal])) MEMBER [Measures].[CBSHotelThreshold] AS MAX((([AceOpoly Goals].[Metric].&[CBS]),[Measures].[Distinguished Goal])) MEMBER [Measures].[CreditCardHotelThreshold] AS MAX((([AceOpoly Goals].[Metric].&[Credit Card]),[Measures].[Distinguished Goal])) MEMBER [Measures].[HomeInsHotelThreshold] AS MAX((([AceOpoly Goals].[Metric].&[Home Insurance SMN]),[Measures].[Distinguished Goal])) MEMBER [Measures].[LifeInsHotelThreshold] AS (([AceOpoly Goals].[Metric].&[Life Insurance SMN]),[Measures].[Distinguished Goal]) MEMBER [Measures].[PlusPremierHotelThreshold] AS MAX((([AceOpoly Goals].[Metric].&[PlusPremier Upgrade]),[Measures].[Distinguished Goal])) MEMBER [Measures].[TeenOnboardHotelThreshold] AS MAX((([AceOpoly Goals].[Metric].&[Teen Onboard]),[Measures].[Distinguished Goal])) MEMBER [Measures].[TravelHotelThreshold] AS MAX((([AceOpoly Goals].[Metric].&[Travel SMN]),[Measures].[Distinguished Goal])) MEMBER [Measures].[AARHouseOpportunity] AS MAX((([AceOpoly Goals].[Metric].&[AAR]),[Measures].[Exceed Recurrence])) MEMBER [Measures].[AssociateAddOnHouseOpportunity] AS MAX((([AceOpoly Goals].[Metric].&[Associate AddOn]),[Measures].[Exceed Recurrence])) MEMBER [Measures].[AutoPayMembershipHouseOpportunity] AS MAX((([AceOpoly Goals].[Metric].&[Auto Pay Membership]),[Measures].[Exceed Recurrence])) MEMBER [Measures].[CBSHouseOpportunity] AS (([AceOpoly Goals].[Metric].&[CBS]),[Measures].[Exceed Recurrence]) MEMBER [Measures].[CreditCardHouseOpportunity] AS MAX((([AceOpoly Goals].[Metric].&[Credit Card]),[Measures].[Exceed Recurrence])) MEMBER [Measures].[LifeInsHouseOpportunity] AS (([AceOpoly Goals].[Metric].&[Life Insurance SMN]),[Measures].[Exceed Recurrence]) MEMBER [Measures].[PlusPremierHouseOpportunity] AS MAX((([AceOpoly Goals].[Metric].&[PlusPremier Upgrade]),[Measures].[Exceed Recurrence])) MEMBER [Measures].[TeenOnboardHouseOpportunity] AS MAX((([AceOpoly Goals].[Metric].&[Teen Onboard]),[Measures].[Exceed Recurrence])) MEMBER [Measures].[TravelHouseOpportunity] AS MAX((([AceOpoly Goals].[Metric].&[Travel SMN]),[Measures].[Exceed Recurrence])) MEMBER [Measures].[AARHotelOpportunity] AS (([AceOpoly Goals].[Metric].&[AAR]),[Measures].[Distinguished Recurrence]) MEMBER [Measures].[AssociateAddOnHotelOpportunity] AS (([AceOpoly Goals].[Metric].&[Associate AddOn]),[Measures].[Distinguished Recurrence]) MEMBER [Measures].[AutoPayMembershipHotelOpportunity] AS (([AceOpoly Goals].[Metric].&[Auto Pay Membership]),[Measures].[Distinguished Recurrence]) MEMBER [Measures].[CBSHotelOpportunity] AS (([AceOpoly Goals].[Metric].&[CBS]),[Measures].[Distinguished Recurrence]) MEMBER [Measures].[CreditCardHotelOpportunity] AS (([AceOpoly Goals].[Metric].&[Credit Card]),[Measures].[Distinguished Recurrence]) MEMBER [Measures].[HomeInsHotelOpportunity] AS (([AceOpoly Goals].[Metric].&[Home Insurance SMN]),[Measures].[Distinguished Recurrence]) MEMBER [Measures].[LifeInsHotelOpportunity] AS (([AceOpoly Goals].[Metric].&[Life Insurance SMN]),[Measures].[Distinguished Recurrence]) MEMBER [Measures].[PlusPremierHotelOpportunity] AS (([AceOpoly Goals].[Metric].&[PlusPremier Upgrade]),[Measures].[Distinguished Recurrence]) MEMBER [Measures].[TeenOnboardHotelOpportunity] AS (([AceOpoly Goals].[Metric].&[Teen Onboard]),[Measures].[Distinguished Recurrence]) MEMBER [Measures].[TravelHotelOpportunity] AS (([AceOpoly Goals].[Metric].&[Travel SMN]),[Measures].[Distinguished Recurrence]) MEMBER [Measures].[AARPropertyPay] AS (([AceOpoly Goals].[Metric].&[AAR]),[Measures].[Expected Pay]) MEMBER [Measures].[AssociateAddOnPropertyPay] AS (([AceOpoly Goals].[Metric].&[Associate AddOn]),[Measures].[Expected Pay]) MEMBER [Measures].[AutoPayMembershipPropertyPay] AS (([AceOpoly Goals].[Metric].&[Auto Pay Membership]),[Measures].[Expected Pay]) MEMBER [Measures].[CBSPropertyPay] AS (([AceOpoly Goals].[Metric].&[CBS]),[Measures].[Expected Pay]) MEMBER [Measures].[CreditCardPropertyPay] AS (([AceOpoly Goals].[Metric].&[Credit Card]),[Measures].[Expected Pay]) MEMBER [Measures].[HomeInsPropertyPay] AS (([AceOpoly Goals].[Metric].&[Home Insurance SMN]),[Measures].[Expected Pay]) MEMBER [Measures].[LifeInsPropertyPay] AS (([AceOpoly Goals].[Metric].&[Life Insurance SMN]),[Measures].[Expected Pay]) MEMBER [Measures].[PlusPremierPropertyPay] AS (([AceOpoly Goals].[Metric].&[PlusPremier Upgrade]),[Measures].[Expected Pay]) MEMBER [Measures].[TeenOnboardPropertyPay] AS (([AceOpoly Goals].[Metric].&[Teen Onboard]),[Measures].[Expected Pay]) MEMBER [Measures].[TravelPropertyPay] AS (([AceOpoly Goals].[Metric].&[Travel SMN]),[Measures].[Expected Pay]) MEMBER [Measures].[AutoInsHousePay] AS (([AceOpoly Goals].[Metric].&[Auto Insurance SMN]),[Measures].[Exceed Pay]) MEMBER [Measures].[AutoInsHotelPay] AS (([AceOpoly Goals].[Metric].&[Auto Insurance SMN]),[Measures].[Distinguished Pay]) MEMBER [Measures].[AARHousePay] AS (([AceOpoly Goals].[Metric].&[AAR]),[Measures].[Exceed Pay]) MEMBER [Measures].[AssociateAddOnHousePay] AS (([AceOpoly Goals].[Metric].&[Associate AddOn]),[Measures].[Exceed Pay]) MEMBER [Measures].[AutoPayMembershipHousePay] AS (([AceOpoly Goals].[Metric].&[Auto Pay Membership]),[Measures].[Exceed Pay]) MEMBER [Measures].[CBSHousePay] AS (([AceOpoly Goals].[Metric].&[CBS]),[Measures].[Exceed Pay]) MEMBER [Measures].[CreditCardHousePay] AS (([AceOpoly Goals].[Metric].&[Credit Card]),[Measures].[Exceed Pay]) MEMBER [Measures].[HomeInsHousePay] AS (([AceOpoly Goals].[Metric].&[Home Insurance SMN]),[Measures].[Exceed Pay]) MEMBER [Measures].[LifeInsHousePay] AS (([AceOpoly Goals].[Metric].&[Life Insurance SMN]),[Measures].[Exceed Pay]) MEMBER [Measures].[PlusPremierHousePay] AS (([AceOpoly Goals].[Metric].&[PlusPremier Upgrade]),[Measures].[Exceed Pay]) MEMBER [Measures].[TeenOnboardHousePay] AS (([AceOpoly Goals].[Metric].&[Teen Onboard]),[Measures].[Exceed Pay]) MEMBER [Measures].[TravelHousePay] AS (([AceOpoly Goals].[Metric].&[Travel SMN]),[Measures].[Exceed Pay]) MEMBER [Measures].[AARHotelPay] AS (([AceOpoly Goals].[Metric].&[AAR]),[Measures].[Distinguished Pay]) MEMBER [Measures].[AssociateAddOnHotelPay] AS (([AceOpoly Goals].[Metric].&[Associate AddOn]),[Measures].[Distinguished Pay]) MEMBER [Measures].[AutoPayMembershipHotelPay] AS (([AceOpoly Goals].[Metric].&[Auto Pay Membership]),[Measures].[Distinguished Pay]) MEMBER [Measures].[CBSHotelPay] AS (([AceOpoly Goals].[Metric].&[CBS]),[Measures].[Distinguished Pay]) MEMBER [Measures].[CreditCardHotelPay] AS (([AceOpoly Goals].[Metric].&[Credit Card]),[Measures].[Distinguished Pay]) MEMBER [Measures].[HomeInsHotelPay] AS (([AceOpoly Goals].[Metric].&[Home Insurance SMN]),[Measures].[Distinguished Pay]) MEMBER [Measures].[LifeInsHotelPay] AS (([AceOpoly Goals].[Metric].&[Life Insurance SMN]),[Measures].[Distinguished Pay]) MEMBER [Measures].[PlusPremierHotelPay] AS (([AceOpoly Goals].[Metric].&[PlusPremier Upgrade]),[Measures].[Distinguished Pay]) MEMBER [Measures].[TeenOnboardHotelPay] AS (([AceOpoly Goals].[Metric].&[Teen Onboard]),[Measures].[Distinguished Pay]) MEMBER [Measures].[TravelHotelPay] AS (([AceOpoly Goals].[Metric].&[Travel SMN]),[Measures].[Distinguished Pay]) MEMBER [Measures].[DrivingSchoolRatioHouseThreshold] AS (([AceOpoly Goals].[Metric].&[Driving School Ratio]),[Measures].[Exceed Goal]) MEMBER [Measures].[DrivingSchoolReferralHouseThreshold] AS (([AceOpoly Goals].[Metric].&[Driving School Referral]),[Measures].[Exceed Goal]) MEMBER [Measures].[DrivingSchoolRatioHotelThreshold] AS (([AceOpoly Goals].[Metric].&[Driving School Ratio]),[Measures].[Distinguished Goal]) MEMBER [Measures].[DrivingSchoolReferralHotelThreshold] AS (([AceOpoly Goals].[Metric].&[Driving School Referral]),[Measures].[Distinguished Goal]) MEMBER [Measures].[DrivingSchoolRatioHouseOpportunity] AS (([AceOpoly Goals].[Metric].&[Driving School Ratio]),[Measures].[Exceed Recurrence]) MEMBER [Measures].[DrivingSchoolReferralHouseOpportunity] AS (([AceOpoly Goals].[Metric].&[Driving School Referral]),[Measures].[Exceed Recurrence]) MEMBER [Measures].[DrivingSchoolRatioHotelOpportunity] AS (([AceOpoly Goals].[Metric].&[Driving School Ratio]),[Measures].[Distinguished Recurrence]) MEMBER [Measures].[DrivingSchoolReferralHotelOpportunity] AS (([AceOpoly Goals].[Metric].&[Driving School Referral]),[Measures].[Distinguished Recurrence]) MEMBER [Measures].[DrivingSchoolRatioPropertyPay] AS (([AceOpoly Goals].[Metric].&[Driving School Ratio]),[Measures].[Expected Pay]) MEMBER [Measures].[DrivingSchoolReferralPropertyPay] AS (([AceOpoly Goals].[Metric].&[Driving School Referral]),[Measures].[Expected Pay]) MEMBER [Measures].[DrivingSchoolRatioHousePay] AS (([AceOpoly Goals].[Metric].&[Driving School Ratio]),[Measures].[Exceed Pay]) MEMBER [Measures].[DrivingSchoolReferralHousePay] AS (([AceOpoly Goals].[Metric].&[Driving School Referral]),[Measures].[Exceed Pay]) MEMBER [Measures].[DrivingSchoolRatioHotelPay] AS (([AceOpoly Goals].[Metric].&[Driving School Ratio]),[Measures].[Distinguished Pay]) MEMBER [Measures].[DrivingSchoolReferralHotelPay] AS (([AceOpoly Goals].[Metric].&[Driving School Referral]),[Measures].[Distinguished Pay]) MEMBER [Measures].[AutoInsDSUSMNReferrals] AS ([Interaction Management].[Dest Branch].&[CA DSU],[Measures].[Auto SMN Referrals])
+
([Interaction Management].[Dest Branch].&[NNE DSU],[Measures].[Auto SMN Referrals])
+
([Interaction Management].[Dest Branch].&[TX DSU],[Measures].[Auto SMN Referrals]) SELECT { [Measures].[AutoPayMembershipHouseThreshold], [Measures].[AssociateAddOnHouseThreshold], [Measures].[AARHouseThreshold], [Measures].[CBSHouseThreshold], [Measures].[PlusPremierHouseThreshold], [Measures].[LifeInsHouseThreshold], [Measures].[CreditCardHouseThreshold], [Measures].[HomeInsHouseThreshold], [Measures].[AutoInsHouseThreshold], [Measures].[TeenOnboardPropertyThreshold], [Measures].[PlusPremierPropertyThreshold], [Measures].[AutoInsHotelThreshold], [Measures].[AutoInsHotelOpportunity], [Measures].[AutoInsPropertyPay], [Measures].[AutoInsHouseOpportunity], [Measures].[AssociateAddOnHotelThreshold], [Measures].[AARHotelThreshold], [Measures].[HomeInsHouseOpportunity], [Measures].[AutoPayMembershipHotelThreshold], [Measures].[HomeInsHotelThreshold], [Measures].[CreditCardHotelThreshold], [Measures].[CBSHotelThreshold], [Measures].[DrivingSchoolReferralHotelPay], [Measures].[DrivingSchoolRatioPropertyPay], [Measures].[TravelHouseThreshold], [Measures].[TeenOnboardHouseThreshold], [Measures].[DrivingSchoolReferralPropertyPay], [Measures].[DrivingSchoolRatioHotelPay], [Measures].[DrivingSchoolReferralHousePay], [Measures].[DrivingSchoolRatioHousePay], [Measures].[CreditCardPropertyThreshold], [Measures].[AAR Referrals], [Measures].[Auth Days60], [Measures].[Associate Add On], [Measures].[AutoInsDSUSMNReferrals], [Measures].[HomeInsPropertyThreshold], [Measures].[AutoInsPropertyThreshold], [Measures].[TeenOnboardHotelThreshold], [Measures].[Car Buying Referral Count], [Measures].[Travel SMN Referrals], [Measures].[Plus Premier Upgrade Count], [Measures].[TeenOnboardHotelPay], [Measures].[Teen Activation Count], [Measures].[Submits], [Measures].[Home SMN Referrals], [Measures].[Life Insurance Referrals], [Measures].[AARPropertyThreshold], [Measures].[TravelPropertyThreshold], [Measures].[LifeInsPropertyThreshold], [Measures].[AssociateAddOnPropertyThreshold], [Measures].[CBSPropertyThreshold], [Measures].[AutoPayMembershipPropertyThreshold], [Measures].[LifeInsHotelOpportunity], [Measures].[TeenOnboardHouseOpportunity], [Measures].[Driving School Referrals], [Measures].[Driving School Bookings], [Measures].[Driving School Calls Answered], [Measures].[DrivingSchoolReferralPropertyThreshold], [Measures].[TeenOnboardHotelOpportunity], [Measures].[LifeInsHouseOpportunity], [Measures].[LifeInsHotelThreshold], [Measures].[DrivingSchoolRatioPropertyThreshold], [Measures].[CBSHotelPay], [Measures].[AutoPayMembershipHotelPay], [Measures].[AssociateAddOnHotelPay], [Measures].[CreditCardHotelPay], [Measures].[PlusPremierHotelPay], [Measures].[LifeInsHotelPay], [Measures].[HomeInsHotelPay], [Measures].[AARHotelPay], [Measures].[HomeInsHousePay], [Measures].[CreditCardHousePay], [Measures].[CBSHousePay], [Measures].[LifeInsHousePay], [Measures].[TravelHousePay], [Measures].[TeenOnboardHousePay], [Measures].[PlusPremierHousePay], [Measures].[Exceed Recurrence], [Measures].[Expected Goal], [Measures].[DrivingSchoolReferralHotelOpportunity], [Measures].[Exceed Goal], [Measures].[PlusPremierHotelThreshold], [Measures].[Distinguished Goal], [Measures].[Distinguished Recurrence], [Measures].[DrivingSchoolRatioHotelOpportunity], [Measures].[DrivingSchoolReferralHouseThreshold], [Measures].[DrivingSchoolRatioHouseThreshold], [Measures].[TravelHotelPay], [Measures].[DrivingSchoolRatioHotelThreshold], [Measures].[DrivingSchoolReferralHouseOpportunity], [Measures].[DrivingSchoolRatioHouseOpportunity], [Measures].[DrivingSchoolReferralHotelThreshold], [Measures].[AutoPayMembershipHousePay], [Measures].[AutoPayMembershipHotelOpportunity], [Measures].[AssociateAddOnHotelOpportunity], [Measures].[AARHotelOpportunity], [Measures].[CBSHotelOpportunity], [Measures].[PlusPremierHotelOpportunity], [Measures].[HomeInsHotelOpportunity], [Measures].[CreditCardHotelOpportunity], [Measures].[TravelHouseOpportunity], [Measures].[AssociateAddOnHouseOpportunity], [Measures].[AARHouseOpportunity], [Measures].[TravelHotelThreshold], [Measures].[AutoPayMembershipHouseOpportunity], [Measures].[PlusPremierHouseOpportunity], [Measures].[CreditCardHouseOpportunity], [Measures].[CBSHouseOpportunity], [Measures].[TravelPropertyPay], [Measures].[TeenOnboardPropertyPay], [Measures].[PlusPremierPropertyPay], [Measures].[AutoInsHousePay], [Measures].[AssociateAddOnHousePay], [Measures].[AARHousePay], [Measures].[AutoInsHotelPay], [Measures].[LifeInsPropertyPay], [Measures].[AssociateAddOnPropertyPay], [Measures].[AARPropertyPay], [Measures].[TravelHotelOpportunity], [Measures].[AutoPayMembershipPropertyPay], [Measures].[HomeInsPropertyPay], [Measures].[CreditCardPropertyPay], [Measures].[CBSPropertyPay] } ON COLUMNS, { ([Staff].[Employee Name].[Employee Name].ALLMEMBERS ) } DIMENSION PROPERTIES MEMBER_CAPTION, MEMBER_UNIQUE_NAME ON ROWS FROM ( SELECT ( STRTOSET(@StaffStatusHrs, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@AceOpolyGoalsBusUnitFilterValue, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@DateMonth, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@DateYear, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@StaffEmpN, CONSTRAINED) ) ON COLUMNS FROM [CallCenterAgent]))))) WHERE ( IIF( STRTOSET(@StaffEmpN, CONSTRAINED).Count = 1, STRTOSET(@StaffEmpN, CONSTRAINED), [Staff].[Emp N].currentmember ), IIF( STRTOSET(@DateYear, CONSTRAINED).Count = 1, STRTOSET(@DateYear, CONSTRAINED), [Date].[Year].currentmember ), IIF( STRTOSET(@DateMonth, CONSTRAINED).Count = 1, STRTOSET(@DateMonth, CONSTRAINED), [Date].[Month].currentmember ), IIF( STRTOSET(@AceOpolyGoalsBusUnitFilterValue, CONSTRAINED).Count = 1, STRTOSET(@AceOpolyGoalsBusUnitFilterValue, CONSTRAINED), [AceOpoly Goals].[Bus Unit Filter Value].currentmember ), IIF( STRTOSET(@StaffStatusHrs, CONSTRAINED).Count = 1, STRTOSET(@StaffStatusHrs, CONSTRAINED), [Staff].[Status Hrs].currentmember ) ) CELL PROPERTIES VALUE, BACK_COLOR, FORE_COLOR, FORMATTED_VALUE, FORMAT_STRING, FONT_NAME, FONT_SIZE, FONT_FLAGS

September 3rd, 2015 5:20pm

Hi Dee25,

According to your description, you have a MDX query can't return any records. However, another report with same MDX query works properly. Right?

In this scenario, returning no data means there's no data matching the slicing members. Since another report with same MDX query can get records properly, the syntax of this MDX should be correct. As your said, these two MDX query are targeting two different cube. Even those two cubes have same measure group and aggregation type. The underlying fact data and dimension data might be different. There can be no fact data for same dimension member in the new cube.

I suggest you remove those filter first and test the MDX query in SSMS to see if it can return any data. If it can return records. Please check those parameter in your sub select. You may apply set which is not existing in the new cube.

Regards,

Free Windows Admin Tool Kit Click here and download it now
September 7th, 2015 2:48am

Hi Simon, Thanks for your reply. I am not familiar with MDX queries much so I am sorry if I ask you basic questions.

You suggested to remove filters from the query. Are you talking about conditions after the where clause:

WHERE ( IIF( STRTOSET(@StaffEmpN, CONSTRAINED).Count = 1, STRTOSET(@StaffEmpN, CONSTRAINED), [Staff].[Emp N].currentmember ), 


September 11th, 2015 7:04pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics