PurchaseOrderAmountRanges_Query1.80083in7.43625inWhiteNone1.80083in7.43625in1in1in1in1in0RSDS_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].[Purchase Order Amount] } ON COLUMNS, NON EMPTY { ([Purchase Order].[Purchase Order Key].[Purchase Order Key].ALLMEMBERS * [Purchase Order].[Po Status].[Po Status].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].[Purchase Order Amount] } ON COLUMNS, NON EMPTY { ([Purchase Order].[Purchase Order Key].[Purchase Order Key].ALLMEMBERS * [Purchase Order].[Po Status].[Po Status].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 Status].[Po Status]" />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=Switch(Fields!Purchase_Order_Amount.Value < 1000, "<1,000",
Fields!Purchase_Order_Amount.Value >= 1000 and Fields!Purchase_Order_Amount.Value < 5000,"1,000 - <5,000",
Fields!Purchase_Order_Amount.Value >= 5000 and Fields!Purchase_Order_Amount.Value < 50000, "5,000 - <50,000",
Fields!Purchase_Order_Amount.Value >= 50000, "50,000+")String[Fiscal Year Date].[Fiscal Year].&[FY 2013]Fiscal YearString[Payee].[Is Minority].[All]Is MinoritytrueInch302433cd-2bcc-4ef6-bcf6-55f0cad87a66