PurchaseOrderItemRanges_Query1.57167in7.29041inWhiteNone1.57167in7.29041in1in1in1in1in0RSDS_EnterpriseDW_SSASNone8a23ae1e-2314-4684-882b-b94c754b23b8RSDS_EnterpriseDW_SSASWITH MEMBER [Measures].[ParameterCaption] AS [Fiscal Year Date].[Fiscal Year].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Fiscal Year Date].[Fiscal Year].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Fiscal Year Date].[Fiscal Year].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Fiscal Year Date].[Fiscal Year].ALLMEMBERS ON ROWS FROM [PayablesPurchaseOrder]MDXQueryPayablesPurchaseOrderWITH MEMBER [Measures].[ParameterCaption] AS [Fiscal Year Date].[Fiscal Year].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Fiscal Year Date].[Fiscal Year].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Fiscal Year Date].[Fiscal Year].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Fiscal Year Date].[Fiscal Year].ALLMEMBERS ON ROWS FROM [PayablesPurchaseOrder]truetrue<?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.ValueSystem.StringRSDS_EnterpriseDW_SSAS=Parameters!FiscalYearDateFiscalYear.ValueWITH 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 ( STRTOSET(@FiscalYearDateFiscalYear, CONSTRAINED) ) ON COLUMNS FROM [PayablesPurchaseOrder])MDXQueryPayablesPurchaseOrderWITH 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 ( STRTOSET(@FiscalYearDateFiscalYear, CONSTRAINED) ) ON COLUMNS FROM [PayablesPurchaseOrder])FiscalYearDateFiscalYear[Fiscal Year Date].[Fiscal Year].&[FY 2013]
Fiscal Year Date.Fiscal Year
[Fiscal Year Date].[Fiscal Year]WITH MEMBER [Measures].[ParameterCaption] AS [Fiscal Year Date].[Fiscal Year].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Fiscal Year Date].[Fiscal Year].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Fiscal Year Date].[Fiscal Year].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Fiscal Year Date].[Fiscal Year].ALLMEMBERS ON ROWS FROM [PayablesPurchaseOrder]truetruetrue<?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.ValueSystem.StringRSDS_EnterpriseDW_SSAS=Parameters!FiscalYearDateFiscalYear.Value=Parameters!PayeeIsMinority.Value SELECT NON EMPTY { [Measures].[Fact Purchase Order Amounts Count], [Measures].[Number Of Items], [Measures].[Purchase Order Amount] } ON COLUMNS, NON EMPTY { ([Purchase Order].[Purchase Order Key].[Purchase Order Key].ALLMEMBERS * [Purchase Order].[Po Type].[Po Type].ALLMEMBERS ) } DIMENSION PROPERTIES MEMBER_CAPTION, MEMBER_UNIQUE_NAME ON ROWS FROM ( SELECT ( STRTOSET(@PayeeIsMinority, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@FiscalYearDateFiscalYear, CONSTRAINED) ) ON COLUMNS FROM [PayablesPurchaseOrder])) WHERE ( IIF( STRTOSET(@FiscalYearDateFiscalYear, CONSTRAINED).Count = 1, STRTOSET(@FiscalYearDateFiscalYear, CONSTRAINED), [Fiscal Year Date].[Fiscal Year].currentmember ), IIF( STRTOSET(@PayeeIsMinority, CONSTRAINED).Count = 1, STRTOSET(@PayeeIsMinority, CONSTRAINED), [Payee].[Is Minority].currentmember ) ) CELL PROPERTIES VALUE, BACK_COLOR, FORE_COLOR, FORMATTED_VALUE, FORMAT_STRING, FONT_NAME, FONT_SIZE, FONT_FLAGSMDXPayablesPurchaseOrder[Fiscal Year Date].[Fiscal Year][Fiscal Year Date].[Fiscal Year].&[FY 2013]true[Payee].[Is Minority][Payee].[Is Minority].[All]true SELECT NON EMPTY { [Measures].[Fact Purchase Order Amounts Count], [Measures].[Number Of Items], [Measures].[Purchase Order Amount] } ON COLUMNS, NON EMPTY { ([Purchase Order].[Purchase Order Key].[Purchase Order Key].ALLMEMBERS * [Purchase Order].[Po Type].[Po Type].ALLMEMBERS ) } DIMENSION PROPERTIES MEMBER_CAPTION, MEMBER_UNIQUE_NAME ON ROWS FROM ( SELECT ( STRTOSET(@PayeeIsMinority, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@FiscalYearDateFiscalYear, CONSTRAINED) ) ON COLUMNS FROM [PayablesPurchaseOrder])) WHERE ( IIF( STRTOSET(@FiscalYearDateFiscalYear, CONSTRAINED).Count = 1, STRTOSET(@FiscalYearDateFiscalYear, CONSTRAINED), [Fiscal Year Date].[Fiscal Year].currentmember ), IIF( STRTOSET(@PayeeIsMinority, CONSTRAINED).Count = 1, STRTOSET(@PayeeIsMinority, CONSTRAINED), [Payee].[Is Minority].currentmember ) ) CELL PROPERTIES VALUE, BACK_COLOR, FORE_COLOR, FORMATTED_VALUE, FORMAT_STRING, FONT_NAME, FONT_SIZE, FONT_FLAGSFiscalYearDateFiscalYear[Fiscal Year Date].[Fiscal Year].&[FY 2013]
Fiscal Year Date.Fiscal Year
[Fiscal Year Date].[Fiscal Year]WITH MEMBER [Measures].[ParameterCaption] AS [Fiscal Year Date].[Fiscal Year].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Fiscal Year Date].[Fiscal Year].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Fiscal Year Date].[Fiscal Year].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Fiscal Year 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 ( SELECT ( STRTOSET(@FiscalYearDateFiscalYear, CONSTRAINED) ) ON COLUMNS FROM [PayablesPurchaseOrder])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 ( STRTOSET(@FiscalYearDateFiscalYear, CONSTRAINED) ) ON COLUMNS FROM [PayablesPurchaseOrder])FiscalYearDateFiscalYeartrue<?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="[Purchase Order].[Purchase Order Key].[Purchase Order Key]" />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="[Purchase Order].[Po Type].[Po 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].[Purchase Order 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="Measure" UniqueName="[Measures].[Number Of Items]" />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].[Fact Purchase Order Amounts Count]" />System.Int32=Switch(Fields!Number_Of_Items.Value = 1, "01",
Fields!Number_Of_Items.Value >= 2 and Fields!Number_Of_Items.Value < 4,"02 - 03",
Fields!Number_Of_Items.Value >= 4 and Fields!Number_Of_Items.Value < 6, "04 - 05",
Fields!Number_Of_Items.Value >= 6 and Fields!Number_Of_Items.Value < 20, "06 - 19",
Fields!Number_Of_Items.Value >= 20, "20+")String[Fiscal Year Date].[Fiscal Year].&[FY 2013]Fiscal YearString[Payee].[Is Minority].[All]Is MinoritytrueInch302433cd-2bcc-4ef6-bcf6-55f0cad87a66