0 RSDS_EnterpriseDW_SSAS None aff4f71a-780b-44c2-8733-785745c31bba RSDS_EnterpriseDW_SSAS =Parameters!PaymentDateFiscalYear.Value =Parameters!PayeeIsMinority.Value SELECT NON EMPTY { [Measures].[Pay Amount] ,[Measures].[Fact Payable Amounts Count] } ON COLUMNS ,NON EMPTY { [Payee].[Payee Type].[Payee Type].ALLMEMBERS } ON ROWS FROM [PayablesPurchaseOrder] WHERE ( STRTOSET(@PaymentDateFiscalYear) ,STRTOSET(@PayeeIsMinority) ,[Payable].[Payable Status Code].&[PD] ) MDXQueryPayeePayee Type[Payee].[Payee Type]Payee Type[Payee].[Payee Type].[Payee Type]Payee TypePay Amount[Measures].[Pay Amount]Pay AmounttrueFact Payable Amounts Count[Measures].[Fact Payable Amounts Count]Fact Payable Amounts CounttruePayablesPurchaseOrderSELECT NON EMPTY { [Measures].[Pay Amount] ,[Measures].[Fact Payable Amounts Count] } ON COLUMNS ,NON EMPTY { [Payee].[Payee Type].[Payee Type].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 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="Measure" UniqueName="[Measures].[Fact Payable Amounts Count]" /> System.Int32 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 =Fields!Payee_Type.Value =Fields!Payee_Type.Value =Fields!Payee_Type.Value =Sum(Fields!Pay_Amount.Value) Axis Title False 0.5 NaN NaN NaN Axis Title False 0.5 NaN Opposite NaN NaN Axis Title 0.5 NaN NaN NaN Axis Title 0.5 NaN Opposite NaN NaN RightCenter Black Black Pastel No Data Available PaymentsByType_Query 0.01042in 2.53125in 3.65625in White None 2.53125in