0 RSDS_EnterpriseDW_SSAS None aff4f71a-780b-44c2-8733-785745c31bba RSDS_EnterpriseDW None 97934b5d-38bd-4601-9d45-9b1883147120 RSDS_EnterpriseDW_SSAS =Parameters!PaymentDateFiscalYear.Value =Parameters!PayeeIsMinority.Value SELECT NON EMPTY {[Measures].[Pay Amount]} ON COLUMNS ,NON EMPTY { TOPCOUNT([Payee].[Payee Id].[Payee Id].MEMBERS,15,[Measures].[Pay Amount]) * [Payee].[Payee Type].[Payee Type].ALLMEMBERS* [Payee].[Payee Name Consolidated].[Payee Name Consolidated].ALLMEMBERS } ON ROWS FROM [PayablesPurchaseOrder] WHERE ( STRTOSET(@PaymentDateFiscalYear) ,STRTOSET(@PayeeIsMinority) ,[Payable].[Payable Status Code].&[PD] ) MDXQueryPayeePayee Id[Payee].[Payee Id]Payee Id[Payee].[Payee Id].[Payee Id]Payee IdPayeePayee Type[Payee].[Payee Type]Payee Type[Payee].[Payee Type].[Payee Type]Payee TypePayeePayee Name Consolidated[Payee].[Payee Name Consolidated]Payee Name Consolidated[Payee].[Payee Name Consolidated].[Payee Name Consolidated]Payee Name ConsolidatedPay Amount[Measures].[Pay Amount]Pay AmounttruePayablesPurchaseOrderSELECT NON EMPTY {[Measures].[Pay Amount]} ON COLUMNS ,NON EMPTY { TOPCOUNT([Payee].[Payee Id].[Payee Id].MEMBERS,15,[Measures].[Pay Amount]) * [Payee].[Payee Type].[Payee Type].ALLMEMBERS* [Payee].[Payee Name Consolidated].[Payee Name Consolidated].ALLMEMBERS } ON ROWS FROM [PayablesPurchaseOrder] WHERE ( STRTOSET(@PaymentDateFiscalYear) ,STRTOSET(@PayeeIsMinority) ,[Payable].[Payable Status Code].&[PD] ) PaymentDateFiscalYear[Payment Date].[Fiscal Year].&[FY 2013]Payment Date.Fiscal Year[Payment Date].[Fiscal Year]WITH MEMBER [Measures].[ParameterCaption] AS [Payment Date].[Fiscal Year].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Payment Date].[Fiscal Year].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Payment Date].[Fiscal Year].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Payment Date].[Fiscal Year].ALLMEMBERS ON ROWS FROM [PayablesPurchaseOrder]truePayeeIsMinority[Payee].[Is Minority].[All]Is Minority[Payee].[Is Minority]WITH MEMBER [Measures].[ParameterCaption] AS [Payee].[Is Minority].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Payee].[Is Minority].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Payee].[Is Minority].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Payee].[Is Minority].ALLMEMBERS ON ROWS FROM [PayablesPurchaseOrder]true <?xml version="1.0" encoding="utf-8"?><Field xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xsi:type="Measure" UniqueName="[Measures].[Pay Amount]" /> System.Int32 <?xml version="1.0" encoding="utf-8"?><Field xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xsi:type="Level" UniqueName="[Payee].[Payee Id].[Payee Id]" /> System.String <?xml version="1.0" encoding="utf-8"?><Field xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xsi:type="Level" UniqueName="[Payee].[Payee Type].[Payee Type]" /> System.String <?xml version="1.0" encoding="utf-8"?><Field xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xsi:type="Level" UniqueName="[Payee].[Payee Name Consolidated].[Payee Name Consolidated]" /> System.String RSDS_EnterpriseDW_SSAS WITH MEMBER [Measures].[ParameterValue] AS [Payment Date].[Fiscal Year].CURRENTMEMBER.UNIQUENAME SELECT [Measures].[ParameterValue] ON COLUMNS, [Payment Date].[Fiscal Year].Children ON ROWS FROM [PayablesPurchaseOrder] WHERE [Payment Date].[Is Current Fiscal Year].&[Y] MDXQueryPayment DateFiscal Year[Payment Date].[Fiscal Year]Fiscal Year[Payment Date].[Fiscal Year].[Fiscal Year]Fiscal YearParameterValue[Measures].[ParameterValue]ParameterValuetruePayablesPurchaseOrderWITH MEMBER [Measures].[ParameterValue] AS [Payment Date].[Fiscal Year].CURRENTMEMBER.UNIQUENAME SELECT [Measures].[ParameterValue] ON COLUMNS, [Payment Date].[Fiscal Year].Children ON ROWS FROM [PayablesPurchaseOrder] WHERE [Payment Date].[Is Current Fiscal Year].&[Y] <?xml version="1.0" encoding="utf-8"?><Field xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xsi:type="Level" UniqueName="[Payment Date].[Fiscal Year].[Fiscal Year]" /> System.String <?xml version="1.0" encoding="utf-8"?><Field xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xsi:type="Measure" UniqueName="[Measures].[ParameterValue]" /> System.Int32 RSDS_EnterpriseDW_SSAS WITH MEMBER [Measures].[ParameterCaption] AS [Payment Date].[Fiscal Year].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Payment Date].[Fiscal Year].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Payment Date].[Fiscal Year].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Payment Date].[Fiscal Year].ALLMEMBERS ON ROWS FROM ( SELECT ( { [Payee].[Payee Type Code].&[V] } ) ON COLUMNS FROM [PayablesPurchaseOrder]) MDXQueryParameterCaption[Measures].[ParameterCaption]ParameterCaptiontrueParameterValue[Measures].[ParameterValue]ParameterValuetrueParameterLevel[Measures].[ParameterLevel]ParameterLeveltruePayablesPurchaseOrderWITH MEMBER [Measures].[ParameterCaption] AS [Payment Date].[Fiscal Year].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Payment Date].[Fiscal Year].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Payment Date].[Fiscal Year].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Payment Date].[Fiscal Year].ALLMEMBERS ON ROWS FROM ( SELECT ( { [Payee].[Payee Type Code].&[V] } ) ON COLUMNS FROM [PayablesPurchaseOrder]) true true <?xml version="1.0" encoding="utf-8"?><Field xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xsi:type="Measure" UniqueName="[Measures].[ParameterCaption]" /> System.Int32 <?xml version="1.0" encoding="utf-8"?><Field xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xsi:type="Measure" UniqueName="[Measures].[ParameterValue]" /> System.Int32 <?xml version="1.0" encoding="utf-8"?><Field xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xsi:type="Measure" UniqueName="[Measures].[ParameterLevel]" /> System.Int32 =Space(3*Fields!ParameterLevel.Value) + Fields!ParameterCaption.Value System.String RSDS_EnterpriseDW_SSAS =Parameters!PaymentDateFiscalYear.Value WITH MEMBER [Measures].[ParameterCaption] AS [Payee].[Is Minority].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Payee].[Is Minority].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Payee].[Is Minority].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Payee].[Is Minority].ALLMEMBERS ON ROWS FROM ( SELECT ( { [Payable].[Payable Status Code].&[PD] } ) ON COLUMNS FROM ( SELECT ( STRTOSET(@PaymentDateFiscalYear, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( { [Payee].[Payee Type Code].&[V] } ) ON COLUMNS FROM [PayablesPurchaseOrder]))) MDXQueryParameterCaption[Measures].[ParameterCaption]ParameterCaptiontrueParameterValue[Measures].[ParameterValue]ParameterValuetrueParameterLevel[Measures].[ParameterLevel]ParameterLeveltruePayablesPurchaseOrderWITH MEMBER [Measures].[ParameterCaption] AS [Payee].[Is Minority].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Payee].[Is Minority].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Payee].[Is Minority].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Payee].[Is Minority].ALLMEMBERS ON ROWS FROM ( SELECT ( { [Payable].[Payable Status Code].&[PD] } ) ON COLUMNS FROM ( SELECT ( STRTOSET(@PaymentDateFiscalYear, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( { [Payee].[Payee Type Code].&[V] } ) ON COLUMNS FROM [PayablesPurchaseOrder])))PaymentDateFiscalYear[Payment Date].[Fiscal Year].&[FY 2013]Payment Date.Fiscal Year[Payment Date].[Fiscal Year]WITH MEMBER [Measures].[ParameterCaption] AS [Payment Date].[Fiscal Year].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Payment Date].[Fiscal Year].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Payment Date].[Fiscal Year].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Payment Date].[Fiscal Year].ALLMEMBERS ON ROWS FROM ( SELECT ( { [Payee].[Payee Type Code].&[V] } ) ON COLUMNS FROM [PayablesPurchaseOrder])true true true <?xml version="1.0" encoding="utf-8"?><Field xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xsi:type="Measure" UniqueName="[Measures].[ParameterCaption]" /> System.Int32 <?xml version="1.0" encoding="utf-8"?><Field xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xsi:type="Measure" UniqueName="[Measures].[ParameterValue]" /> System.Int32 <?xml version="1.0" encoding="utf-8"?><Field xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xsi:type="Measure" UniqueName="[Measures].[ParameterLevel]" /> System.Int32 =Space(3*Fields!ParameterLevel.Value) + Fields!ParameterCaption.Value System.String RSDS_EnterpriseDW SELECT BackgroundColor, BackgroundAlternateColor, Band1Color, Band2Color, Band3Color, Band4Color, Band5Color, Band6Color FROM Configuration_Color WHERE (ReportType = 'GeneralLedger') BackgroundColor System.String BackgroundAlternateColor System.String Band1Color System.String Band2Color System.String Band3Color System.String Band4Color System.String Band5Color System.String Band6Color System.String 0.88542in 0.89583in 2.46875in 1.13542in 0.25in true true Payee Type =First(Fields!Band1Color.Value, "GetColors") 2pt 2pt 2pt 2pt true true Payee Id =First(Fields!Band1Color.Value, "GetColors") 2pt 2pt 2pt 2pt true true Payee Name =First(Fields!Band1Color.Value, "GetColors") 2pt 2pt 2pt 2pt true true Pay Amount =First(Fields!Band1Color.Value, "GetColors") 2pt 2pt 2pt 2pt 0.14583in true true =Fields!Payee_Type.Value =iif(rownumber(Nothing) mod 2 = 0, First(Fields!BackgroundColor.Value, "GetColors"), First(Fields!BackgroundAlternateColor.Value, "GetColors") ) 2pt 2pt 2pt 2pt true true =Fields!Payee_Id.Value =iif(rownumber(Nothing) mod 2 = 0, First(Fields!BackgroundColor.Value, "GetColors"), First(Fields!BackgroundAlternateColor.Value, "GetColors") ) 2pt 2pt 2pt 2pt true true =Fields!Payee_Name_Consolidated.Value =iif(rownumber(Nothing) mod 2 = 0, First(Fields!BackgroundColor.Value, "GetColors"), First(Fields!BackgroundAlternateColor.Value, "GetColors") ) 2pt 2pt 2pt 2pt true true =Fields!Pay_Amount.Value =iif(rownumber(Nothing) mod 2 = 0, First(Fields!BackgroundColor.Value, "GetColors"), First(Fields!BackgroundAlternateColor.Value, "GetColors") ) 2pt 2pt 2pt 2pt After Top15Payees 0.39583in 5.38542in 0.44792in