External=First(Fields!ImageLocation.Value, "GetImage")FitProportional3.06375in0.5in7.17708inHETGroup0.60417in1in1in1in0.25intruetrue# of POsTextbox39=First(Fields!Band1Color.Value, "GetColors")2pt2pt2pt2pttruetruePurchase Order AmountTextbox41=First(Fields!Band1Color.Value, "GetColors")2pt2pt2pt2pttruetrueEncumbered BalanceTextbox43=First(Fields!Band1Color.Value, "GetColors")2pt2pt2pt2pttruetruePaid AmountTextbox45=First(Fields!Band1Color.Value, "GetColors")2pt2pt2pt2pt0.25intruetrueFact_Purchase_Order_Amounts_Count=iif(rownumber("Payee_Sequence") mod 2 = 0,
First(Fields!BackgroundColor.Value, "GetColors"),
First(Fields!BackgroundAlternateColor.Value, "GetColors")
)2pt2pt2pt2pttruetrue=SUM(Fields!Purchase_Order_Amount.Value)Purchase_Order_Amount=iif(rownumber("Payee_Sequence") mod 2 = 0,
First(Fields!BackgroundColor.Value, "GetColors"),
First(Fields!BackgroundAlternateColor.Value, "GetColors")
)2pt2pt2pt2pttruetrue=SUM(Fields!Encumbered_Balance.Value)Encumbered_Balance=iif(rownumber("Payee_Sequence") mod 2 = 0,
First(Fields!BackgroundColor.Value, "GetColors"),
First(Fields!BackgroundAlternateColor.Value, "GetColors")
)2pt2pt2pt2pttruetrue=SUM(Fields!Paid_Amount.Value)Paid_Amount=iif(rownumber("Payee_Sequence") mod 2 = 0,
First(Fields!BackgroundColor.Value, "GetColors"),
First(Fields!BackgroundAlternateColor.Value, "GetColors")
)2pt2pt2pt2pt0.25intruetrue=SUM(Fields!Fact_Purchase_Order_Amounts_Count.Value)Textbox33=First(Fields!Band3Color.Value, "GetColors")2pt2pt2pt2pttruetrue=SUM(Fields!Purchase_Order_Amount.Value)Textbox34=First(Fields!Band3Color.Value, "GetColors")2pt2pt2pt2pttruetrue=SUM(Fields!Encumbered_Balance.Value)Textbox35=First(Fields!Band3Color.Value, "GetColors")2pt2pt2pt2pttruetrue=SUM(Fields!Paid_Amount.Value)Textbox36=First(Fields!Band3Color.Value, "GetColors")2pt2pt2pt2pt0.25intruetrue=SUM(Fields!Fact_Purchase_Order_Amounts_Count.Value)Textbox1062pt2pt2pt2pttruetrue=SUM(Fields!Purchase_Order_Amount.Value)Textbox1072pt2pt2pt2pttruetrue=SUM(Fields!Encumbered_Balance.Value)Textbox1082pt2pt2pt2pttruetrue=SUM(Fields!Paid_Amount.Value)Textbox1092pt2pt2pt2pt1.11458intruetrueVendor IDTextbox49=First(Fields!Band1Color.Value, "GetColors")2pt2pt2pt2pt0.67708intruetrueAddr SeqTextbox4=First(Fields!Band1Color.Value, "GetColors")2pt2pt2pt2pt1.63542intruetrueVendor NameTextbox10=First(Fields!Band1Color.Value, "GetColors")2pt2pt2pt2pt1.22917intruetruePurchase OrderTextbox19=First(Fields!Band1Color.Value, "GetColors")2pt2pt2pt2pt0.88542intruetrueEntry DateTextbox44=First(Fields!Band1Color.Value, "GetColors")2pt2pt2pt2pt1intruetrueStatusTextbox50=First(Fields!Band1Color.Value, "GetColors")2pt2pt2pt2pt1intruetruePO TypeTextbox62=First(Fields!Band1Color.Value, "GetColors")2pt2pt2pt2pt1.5intruetrueBuyerTextbox54=First(Fields!Band1Color.Value, "GetColors")2pt2pt2pt2pt0.74083intruetrue# of ItemsTextbox58=First(Fields!Band1Color.Value, "GetColors")2pt2pt2pt2ptAfter=Fields!Payee_Id.Value=Sum(Fields!Purchase_Order_Amount.Value, "TopVendorPurchaseOrder_Query")1.11458intruetrue=Fields!Payee_Id.ValuePayee_Id2pt2pt2pt2pt=Fields!Payee_Sequence.Value=Fields!Payee_Sequence.Value0.67708intruetrue=Fields!Payee_Sequence.ValuePayee_Sequence=First(Fields!Band3Color.Value, "GetColors")2pt2pt2pt2pt1.63542intruetrue=Fields!Payee_Name.ValueTextbox11=First(Fields!Band3Color.Value, "GetColors")2pt2pt2pt2pt=Fields!Purchase_Order_Key.Value=Fields!Purchase_Order_Key.Value1.22917intruetrue=Fields!Purchase_Order_Key.ValuePurchase_Order_Key=iif(rownumber("Payee_Sequence") mod 2 = 0,
First(Fields!BackgroundColor.Value, "GetColors"),
First(Fields!BackgroundAlternateColor.Value, "GetColors")
)2pt2pt2pt2pt0.88542intruetrue=Fields!Date_Name.ValueTextbox46=iif(rownumber("Payee_Sequence") mod 2 = 0,
First(Fields!BackgroundColor.Value, "GetColors"),
First(Fields!BackgroundAlternateColor.Value, "GetColors")
)2pt2pt2pt2pt1intruetrue=Fields!Po_Status.ValueTextbox51=iif(rownumber("Payee_Sequence") mod 2 = 0,
First(Fields!BackgroundColor.Value, "GetColors"),
First(Fields!BackgroundAlternateColor.Value, "GetColors")
)2pt2pt2pt2pt1intruetrue=Fields!Po_Type.ValueTextbox63=iif(rownumber("Payee_Sequence") mod 2 = 0,
First(Fields!BackgroundColor.Value, "GetColors"),
First(Fields!BackgroundAlternateColor.Value, "GetColors")
)2pt2pt2pt2pt1.5intruetrue=Fields!Buyer.ValueTextbox55=iif(rownumber("Payee_Sequence") mod 2 = 0,
First(Fields!BackgroundColor.Value, "GetColors"),
First(Fields!BackgroundAlternateColor.Value, "GetColors")
)2pt2pt2pt2pt0.74083intruetrue=Fields!Number_Of_Items.ValueTextbox59=iif(rownumber("Payee_Sequence") mod 2 = 0,
First(Fields!BackgroundColor.Value, "GetColors"),
First(Fields!BackgroundAlternateColor.Value, "GetColors")
)2pt2pt2pt2pttruePayee_SequencetruePayee_Sequence1.22917intruetrueTextbox32=First(Fields!Band3Color.Value, "GetColors")2pt2pt2pt2pt0.88542intruetrueTextbox47=First(Fields!Band3Color.Value, "GetColors")2pt2pt2pt2pt1intruetrueTextbox52=First(Fields!Band3Color.Value, "GetColors")2pt2pt2pt2pt1intruetrueTextbox64=First(Fields!Band3Color.Value, "GetColors")2pt2pt2pt2pt1.5intruetrueTextbox56=First(Fields!Band3Color.Value, "GetColors")2pt2pt2pt2pt0.74083intruetrueTotalTextbox60=First(Fields!Band3Color.Value, "GetColors")2pt2pt2pt2ptBeforetruePayee_Id0.67708intruetrueTextbox662pt2pt2pt2pt1.63542intruetrueTextbox672pt2pt2pt2pt1.22917intruetrueTextbox682pt2pt2pt2pt0.88542intruetrueTextbox482pt2pt2pt2pt1intruetrueTextbox532pt2pt2pt2pt1intruetrueTextbox652pt2pt2pt2pt1.5intruetrueTextbox572pt2pt2pt2pt0.74083intruetrueTextbox612pt2pt2pt2ptTopVendorPurchaseOrder_Query1.20709in1in13.38667in1truetrueTop 1000 Vendors based on Purchase Order AmountsTextbox10.74875in4.04042in0.25in4.39583in22pt2pt2pt2pt2.20709in14.16667in1in1in1in1in0RSDS_EnterpriseDW_SSASNone86609a28-0f07-4862-b057-67a3aac95510RSDS_EnterpriseDWNoneb60a708d-f7e9-4c5c-b68a-33d87daf289dRSDS_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,
ORDER(
{[Fiscal Year Date].[Fiscal Year].Children},[Measures].[ParameterCaption], DESC
) ON ROWS
FROM
(
SELECT
{
([Fiscal Year Date].[Fiscal Year].[Fiscal Year].Members
,[Fiscal Year Date].[Is Current Fiscal Year].&[Y]
,[Fiscal Year Date].[Is Available For Finance].&[Y])
,
([Fiscal Year Date].[Fiscal Year].[Fiscal Year].Members
,[Fiscal Year Date].[Is Current Fiscal Year].Children
,[Fiscal Year Date].[Is Available For Finance].&[Y]
)
} ON COLUMNS
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,
ORDER(
{[Fiscal Year Date].[Fiscal Year].Children},[Measures].[ParameterCaption], DESC
) ON ROWS
FROM
(
SELECT
{
([Fiscal Year Date].[Fiscal Year].[Fiscal Year].Members
,[Fiscal Year Date].[Is Current Fiscal Year].&[Y]
,[Fiscal Year Date].[Is Available For Finance].&[Y])
,
([Fiscal Year Date].[Fiscal Year].[Fiscal Year].Members
,[Fiscal Year Date].[Is Current Fiscal Year].Children
,[Fiscal Year Date].[Is Available For Finance].&[Y]
)
} ON COLUMNS
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="Level" UniqueName="[Fiscal Year 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].[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!ZipCountyState.Value=Parameters!ZipCountyCounty.Value=Parameters!PayeeIsMinority.ValueSELECT
{
[Measures].[Purchase Order Amount]
,[Measures].[Paid Amount]
,[Measures].[Encumbered Balance]
,[Measures].[Fact Purchase Order Amounts Count]
,[Measures].[Number Of Items]
,[Measures].[Number Of Change Orders]
} ON COLUMNS,
NON EMPTY
{
TOPCOUNT([Payee].[Payee Id].[Payee Id].MEMBERS,1000,[Measures].[Purchase Order Amount]) *
[Payee].[Payee Sequence].[Payee Sequence].ALLMEMBERS*
[Payee].[Payee Name].[Payee Name].ALLMEMBERS*
[Entry Date].[Date Name].[Date Name].ALLMEMBERS*
[Purchase Order].[Purchase Order Key].[Purchase Order Key].ALLMEMBERS*
[Purchase Order].[Po Status].[Po Status].ALLMEMBERS*
[Purchase Order].[Buyer].[Buyer].ALLMEMBERS*
[Purchase Order].[Po Type].[Po Type].ALLMEMBERS
}
ON ROWS
FROM [PayablesPurchaseOrder]
WHERE
(
STRTOSET(@FiscalYearDateFiscalYear)
, STRTOSET(@ZipCountyState)
,STRTOSET(@ZipCountyCounty)
,STRTOSET(@PayeeIsMinority)
)MDXQueryPayablesPurchaseOrderSELECT
{
[Measures].[Purchase Order Amount]
,[Measures].[Paid Amount]
,[Measures].[Encumbered Balance]
,[Measures].[Fact Purchase Order Amounts Count]
,[Measures].[Number Of Items]
,[Measures].[Number Of Change Orders]
} ON COLUMNS,
NON EMPTY
{
TOPCOUNT([Payee].[Payee Id].[Payee Id].MEMBERS,1000,[Measures].[Purchase Order Amount]) *
[Payee].[Payee Sequence].[Payee Sequence].ALLMEMBERS*
[Payee].[Payee Name].[Payee Name].ALLMEMBERS*
[Entry Date].[Date Name].[Date Name].ALLMEMBERS*
[Purchase Order].[Purchase Order Key].[Purchase Order Key].ALLMEMBERS*
[Purchase Order].[Po Status].[Po Status].ALLMEMBERS*
[Purchase Order].[Buyer].[Buyer].ALLMEMBERS*
[Purchase Order].[Po Type].[Po Type].ALLMEMBERS
}
ON ROWS
FROM [PayablesPurchaseOrder]
WHERE
(
STRTOSET(@FiscalYearDateFiscalYear)
, STRTOSET(@ZipCountyState)
,STRTOSET(@ZipCountyCounty)
,STRTOSET(@PayeeIsMinority)
)
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]trueZipCountyState[Zip County].[State].[All]
State
[Zip County].[State]WITH MEMBER [Measures].[ParameterCaption] AS [Zip County].[State].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Zip County].[State].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Zip County].[State].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Zip County].[State].ALLMEMBERS ON ROWS FROM [PayablesPurchaseOrder]trueZipCountyCounty[Zip County].[County].[All]
County
[Zip County].[County]WITH MEMBER [Measures].[ParameterCaption] AS [Zip County].[County].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Zip County].[County].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Zip County].[County].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Zip County].[County].ALLMEMBERS ON ROWS FROM [PayablesPurchaseOrder]truePayeeIsMinority[Payee].[Is Minority].[All]
PayeeIsMinority
[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="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 Sequence].[Payee Sequence]" />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].[Payee Name]" />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="[Entry Date].[Date Name].[Date Name]" />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].[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].[Buyer].[Buyer]" />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="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<?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].[Paid 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].[Encumbered Balance]" />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<?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].[Number Of Change Orders]" />System.Int32RSDS_EnterpriseDW_SSASWITH
MEMBER [Measures].[ParameterCaption] AS
[Zip County].[State].CurrentMember.Member_Caption
MEMBER [Measures].[ParameterValue] AS
[Zip County].[State].CurrentMember.UniqueName
MEMBER [Measures].[ParameterLevel] AS
[Zip County].[State].CurrentMember.Level.Ordinal
SELECT
{
[Measures].[ParameterCaption]
,[Measures].[ParameterValue]
,[Measures].[ParameterLevel]
} ON COLUMNS
,[Zip County].[State].ALLMEMBERS ON ROWS
FROM [PayablesPurchaseOrder];MDXQueryPayablesPurchaseOrderWITH
MEMBER [Measures].[ParameterCaption] AS
[Zip County].[State].CurrentMember.Member_Caption
MEMBER [Measures].[ParameterValue] AS
[Zip County].[State].CurrentMember.UniqueName
MEMBER [Measures].[ParameterLevel] AS
[Zip County].[State].CurrentMember.Level.Ordinal
SELECT
{
[Measures].[ParameterCaption]
,[Measures].[ParameterValue]
,[Measures].[ParameterLevel]
} ON COLUMNS
,[Zip County].[State].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="Level" UniqueName="[Zip County].[State].[State]" />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].[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!ZipCountyState.ValueWITH
MEMBER [Measures].[ParameterCaption] AS
[Zip County].[County].CurrentMember.Member_Caption
MEMBER [Measures].[ParameterValue] AS
[Zip County].[County].CurrentMember.UniqueName
MEMBER [Measures].[ParameterLevel] AS
[Zip County].[County].CurrentMember.Level.Ordinal
SELECT
{
[Measures].[ParameterCaption]
,[Measures].[ParameterValue]
,[Measures].[ParameterLevel]
} ON COLUMNS
,[Zip County].[County].ALLMEMBERS ON ROWS
FROM [PayablesPurchaseOrder]
WHERE
STRTOSET(@ZipCountyState)MDXQueryPayablesPurchaseOrderWITH
MEMBER [Measures].[ParameterCaption] AS
[Zip County].[County].CurrentMember.Member_Caption
MEMBER [Measures].[ParameterValue] AS
[Zip County].[County].CurrentMember.UniqueName
MEMBER [Measures].[ParameterLevel] AS
[Zip County].[County].CurrentMember.Level.Ordinal
SELECT
{
[Measures].[ParameterCaption]
,[Measures].[ParameterValue]
,[Measures].[ParameterLevel]
} ON COLUMNS
,[Zip County].[County].ALLMEMBERS ON ROWS
FROM [PayablesPurchaseOrder]
WHERE
STRTOSET(@ZipCountyState)ZipCountyState[Zip County].[State].[All]
ZipCountyState
[Zip County].[State]WITH MEMBER [Measures].[ParameterCaption] AS [Zip County].[State].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Zip County].[State].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Zip County].[State].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Zip County].[State].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="Level" UniqueName="[Zip County].[County].[County]" />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].[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_EnterpriseDWSELECT BackgroundColor, BackgroundAlternateColor, Band1Color, Band2Color, Band3Color, Band4Color, Band5Color, Band6Color
FROM Configuration_Color
WHERE (ReportType = 'GeneralLedger')BackgroundColorSystem.StringBackgroundAlternateColorSystem.StringBand1ColorSystem.StringBand2ColorSystem.StringBand3ColorSystem.StringBand4ColorSystem.StringBand5ColorSystem.StringBand6ColorSystem.StringRSDS_EnterpriseDWSELECT ImageType, ImageLocation, SuggestedImageSize
FROM Configuration_Image
WHERE (ImageType = 'Banner')ImageTypeSystem.StringImageLocationSystem.StringSuggestedImageSizeSystem.StringRSDS_EnterpriseDW_SSASWITH
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]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 [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="Level" UniqueName="[Payee].[Is Minority].[Is Minority]" />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].[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_SSASWITH MEMBER [Measures].[ParameterValue]
AS [Fiscal Year Date].[Fiscal Year].CURRENTMEMBER.UNIQUENAME
SELECT
[Measures].[ParameterValue] ON COLUMNS,
[Fiscal Year Date].[Fiscal Year].Children ON ROWS
FROM [PayablesPurchaseOrder]
WHERE [Fiscal Year Date].[Is Current Fiscal Year].&[Y]MDXQueryPayablesPurchaseOrderWITH MEMBER [Measures].[ParameterValue]
AS [Fiscal Year Date].[Fiscal Year].CURRENTMEMBER.UNIQUENAME
SELECT
[Measures].[ParameterValue] ON COLUMNS,
[Fiscal Year Date].[Fiscal Year].Children ON ROWS
FROM [PayablesPurchaseOrder]
WHERE [Fiscal Year 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="[Fiscal Year 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.Int32StringDefaultFiscalYearParameterValueFiscal YearFiscalYearDateFiscalYearParameterValueParameterCaptionIndentedString[Zip County].[State].[All]StateZipCountyStateParameterValueParameterCaptionIndentedtrueString[Zip County].[County].[All]CountyZipCountyCountyParameterValueParameterCaptionIndentedtrueString[Payee].[Is Minority].[All]PayeeIsMinorityPayeeIsMinorityParameterValueParameterCaptionIndentedtrueInch43feec44-f32f-458f-b784-32313c346a80