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