External=First(Fields!ImageLocation.Value, "GetImage")FitProportional4.17958in0.5in7.17708inHETGrouptruetrueState OrgTextbox60=First(Fields!Band1Color.Value, "GetColors")2pt2pt2pt2pttruetrueQual1Textbox62=First(Fields!Band1Color.Value, "GetColors")2pt2pt2pt2pttruetrueLocTextbox64=First(Fields!Band1Color.Value, "GetColors")2pt2pt2pt2pttruetrueOrg TitleTextbox66=First(Fields!Band1Color.Value, "GetColors")2pt2pt2pt2pttruetrueGlcTextbox68=First(Fields!Band1Color.Value, "GetColors")2pt2pt2pt2pt0.92708in0.8125in0.8125in0.80208in0.75in0.76293in0.77083in0.83333in0.86458in0.86458in0.80208in0.8125in0.83333in0.97916in0.90625in0.25intruetrue=Sum(Fields!Budget_Amount.Value)Textbox1542pt2pt2pt2pttruetrue=Sum(Fields!Jul_Amt.Value)Jul_Amt2pt2pt2pt2pttruetrue=Sum(Fields!Aug_Amt.Value)Aug_Amt2pt2pt2pt2pttruetrue=Sum(Fields!Sep_Amt.Value)Sep_Amt2pt2pt2pt2pttruetrue=Sum(Fields!Oct_Amt.Value)Oct_Amt2pt2pt2pt2pttruetrue=Sum(Fields!Nov_Amt.Value)Nov_Amt2pt2pt2pt2pttruetrue=Sum(Fields!Dec_Amt.Value)Dec_Amt2pt2pt2pt2pttruetrue=Sum(Fields!Jan_Amt.Value)Jan_Amt2pt2pt2pt2pttruetrue=Sum(Fields!Feb_Amt.Value)Feb_Amt2pt2pt2pt2pttruetrue=Sum(Fields!Mar_Amt.Value)Mar_Amt2pt2pt2pt2pttruetrue=Sum(Fields!Apr_Amt.Value)Apr_Amt2pt2pt2pt2pttruetrue=Sum(Fields!May_Amt.Value)May_Amt2pt2pt2pt2pttruetrue=Sum(Fields!Jun_Amt.Value)Jun_Amt2pt2pt2pt2pttruetrue=IIF(IsNothing(SUM(Fields!Summary_Amount.Value)),0,SUM(Fields!Summary_Amount.Value))Textbox882pt2pt2pt2pttruetrue=Sum(Fields!Budget_Amount.Value) - SUM(Fields!Summary_Amount.Value)Textbox922pt2pt2pt2pt0.25intruetrue=Sum(Fields!Budget_Amount.Value,"Glc1")Textbox257=First(Fields!BackgroundAlternateColor.Value, "GetColors")2pt2pt2pt2pttruetrue=Sum(Fields!Jul_Amt.Value)Jul_Amt=First(Fields!BackgroundAlternateColor.Value, "GetColors")2pt2pt2pt2pttruetrue=Sum(Fields!Aug_Amt.Value)Aug_Amt=First(Fields!BackgroundAlternateColor.Value, "GetColors")2pt2pt2pt2pttruetrue=Sum(Fields!Sep_Amt.Value)Sep_Amt=First(Fields!BackgroundAlternateColor.Value, "GetColors")2pt2pt2pt2pttruetrue=Sum(Fields!Oct_Amt.Value)Oct_Amt=First(Fields!BackgroundAlternateColor.Value, "GetColors")2pt2pt2pt2pttruetrue=Sum(Fields!Nov_Amt.Value)Nov_Amt=First(Fields!BackgroundAlternateColor.Value, "GetColors")2pt2pt2pt2pttruetrue=Sum(Fields!Dec_Amt.Value)Dec_Amt=First(Fields!BackgroundAlternateColor.Value, "GetColors")2pt2pt2pt2pttruetrue=Sum(Fields!Jan_Amt.Value)Jan_Amt=First(Fields!BackgroundAlternateColor.Value, "GetColors")2pt2pt2pt2pttruetrue=Sum(Fields!Feb_Amt.Value)Feb_Amt=First(Fields!BackgroundAlternateColor.Value, "GetColors")2pt2pt2pt2pttruetrue=Sum(Fields!Mar_Amt.Value)Mar_Amt=First(Fields!BackgroundAlternateColor.Value, "GetColors")2pt2pt2pt2pttruetrue=Sum(Fields!Apr_Amt.Value)Apr_Amt=First(Fields!BackgroundAlternateColor.Value, "GetColors")2pt2pt2pt2pttruetrue=Sum(Fields!May_Amt.Value)May_Amt=First(Fields!BackgroundAlternateColor.Value, "GetColors")2pt2pt2pt2pttruetrue=Sum(Fields!Jun_Amt.Value)Jun_Amt=First(Fields!BackgroundAlternateColor.Value, "GetColors")2pt2pt2pt2pttruetrue=IIF(IsNothing(SUM(Fields!Summary_Amount.Value)),0,SUM(Fields!Summary_Amount.Value))Textbox259=First(Fields!BackgroundAlternateColor.Value, "GetColors")2pt2pt2pt2pttruetrue=Sum(Fields!Budget_Amount.Value,"Glc1") - SUM(Fields!Summary_Amount.Value)Textbox260=First(Fields!BackgroundAlternateColor.Value, "GetColors")2pt2pt2pt2pt0.25intruetrueTextbox238=First(Fields!BackgroundAlternateColor.Value, "GetColors")2pt2pt2pt2pttruetrue=IIF(IsNothing(Sum(Fields!Budget_Amount.Value, "Glc1")) or Sum(Fields!Budget_Amount.Value, "Glc1") = 0, 0,
Sum(Fields!Jul_Amt.Value) / Sum(Fields!Budget_Amount.Value, "Glc1"))Textbox13=First(Fields!BackgroundAlternateColor.Value, "GetColors")2pt2pt2pt2pttruetrue=IIF(IsNothing(Sum(Fields!Budget_Amount.Value, "Glc1")) Or Sum(Fields!Budget_Amount.Value, "Glc1") = 0, 0, Sum(Fields!Aug_Amt.Value) / Sum(Fields!Budget_Amount.Value, "Glc1"))Textbox13=First(Fields!BackgroundAlternateColor.Value, "GetColors")2pt2pt2pt2pttruetrue=IIF(IsNothing(Sum(Fields!Budget_Amount.Value, "Glc1")) Or Sum(Fields!Budget_Amount.Value, "Glc1") = 0, 0, Sum(Fields!Sep_Amt.Value) / Sum(Fields!Budget_Amount.Value, "Glc1"))Textbox13=First(Fields!BackgroundAlternateColor.Value, "GetColors")2pt2pt2pt2pttruetrue=IIF(IsNothing(Sum(Fields!Budget_Amount.Value, "Glc1")) or Sum(Fields!Budget_Amount.Value, "Glc1") = 0, 0,
Sum(Fields!Oct_Amt.Value) / Sum(Fields!Budget_Amount.Value, "Glc1"))Textbox13=First(Fields!BackgroundAlternateColor.Value, "GetColors")2pt2pt2pt2pttruetrue=IIF(IsNothing(Sum(Fields!Budget_Amount.Value, "Glc1")) or Sum(Fields!Budget_Amount.Value, "Glc1") = 0, 0,
Sum(Fields!Nov_Amt.Value) / Sum(Fields!Budget_Amount.Value, "Glc1"))Textbox13=First(Fields!BackgroundAlternateColor.Value, "GetColors")2pt2pt2pt2pttruetrue=IIF(IsNothing(Sum(Fields!Budget_Amount.Value, "Glc1")) or Sum(Fields!Budget_Amount.Value, "Glc1") = 0, 0,
Sum(Fields!Dec_Amt.Value) / Sum(Fields!Budget_Amount.Value, "Glc1"))Textbox13=First(Fields!BackgroundAlternateColor.Value, "GetColors")2pt2pt2pt2pttruetrue=IIF(IsNothing(Sum(Fields!Budget_Amount.Value, "Glc1")) or Sum(Fields!Budget_Amount.Value, "Glc1") = 0, 0,
Sum(Fields!Jan_Amt.Value) / Sum(Fields!Budget_Amount.Value, "Glc1"))Textbox13=First(Fields!BackgroundAlternateColor.Value, "GetColors")2pt2pt2pt2pttruetrue=IIF(IsNothing(Sum(Fields!Budget_Amount.Value, "Glc1")) or Sum(Fields!Budget_Amount.Value, "Glc1") = 0, 0,
Sum(Fields!Feb_Amt.Value) / Sum(Fields!Budget_Amount.Value, "Glc1"))Textbox13=First(Fields!BackgroundAlternateColor.Value, "GetColors")2pt2pt2pt2pttruetrue=IIF(IsNothing(Sum(Fields!Budget_Amount.Value, "Glc1")) or Sum(Fields!Budget_Amount.Value, "Glc1") = 0, 0,
Sum(Fields!Mar_Amt.Value) / Sum(Fields!Budget_Amount.Value, "Glc1"))Textbox13=First(Fields!BackgroundAlternateColor.Value, "GetColors")2pt2pt2pt2pttruetrue=IIF(IsNothing(Sum(Fields!Budget_Amount.Value, "Glc1")) or Sum(Fields!Budget_Amount.Value, "Glc1") = 0, 0,
Sum(Fields!Apr_Amt.Value) / Sum(Fields!Budget_Amount.Value, "Glc1"))Textbox13=First(Fields!BackgroundAlternateColor.Value, "GetColors")2pt2pt2pt2pttruetrue=IIF(IsNothing(Sum(Fields!Budget_Amount.Value, "Glc1")) or Sum(Fields!Budget_Amount.Value, "Glc1") = 0, 0,
Sum(Fields!May_Amt.Value) / Sum(Fields!Budget_Amount.Value, "Glc1"))Textbox13=First(Fields!BackgroundAlternateColor.Value, "GetColors")2pt2pt2pt2pttruetrue=IIF(IsNothing(Sum(Fields!Budget_Amount.Value, "Glc1")) or Sum(Fields!Budget_Amount.Value, "Glc1") = 0, 0,
Sum(Fields!Jun_Amt.Value) / Sum(Fields!Budget_Amount.Value, "Glc1"))Textbox13=First(Fields!BackgroundAlternateColor.Value, "GetColors")2pt2pt2pt2pttruetrue=IIF(IsNothing(Sum(Fields!Budget_Amount.Value, "Glc1")) or Sum(Fields!Budget_Amount.Value, "Glc1") = 0, 0,
Sum(Fields!Summary_Amount.Value) / Sum(Fields!Budget_Amount.Value, "Glc1"))Textbox240=First(Fields!BackgroundAlternateColor.Value, "GetColors")2pt2pt2pt2pttruetrue=IIF(IsNothing(Sum(Fields!Budget_Amount.Value, "Glc1")) or Sum(Fields!Budget_Amount.Value, "Glc1") = 0, 0,
(Sum(Fields!Budget_Amount.Value, "Glc1") - Sum(Fields!Summary_Amount.Value)) / Sum(Fields!Budget_Amount.Value, "Glc1"))Textbox241=First(Fields!BackgroundAlternateColor.Value, "GetColors")2pt2pt2pt2pt0.25intruetrueTextbox3222pt2pt2pt2pttruetrueTextbox142pt2pt2pt2pttruetrueTextbox232pt2pt2pt2pttruetrueTextbox342pt2pt2pt2pttruetrueTextbox432pt2pt2pt2pttruetrueTextbox522pt2pt2pt2pttruetrueTextbox632pt2pt2pt2pttruetrueTextbox772pt2pt2pt2pttruetrueTextbox972pt2pt2pt2pttruetrueTextbox1062pt2pt2pt2pttruetrueTextbox1152pt2pt2pt2pttruetrueTextbox1242pt2pt2pt2pttruetrueTextbox1332pt2pt2pt2pttruetrueTextbox3242pt2pt2pt2pttruetrueTextbox3252pt2pt2pt2pt0.25intruetrue=Sum(Fields!Budget_Amount.Value,"Gl_Class_Code")Textbox267=First(Fields!Band5Color.Value, "GetColors")2pt2pt2pt2pttruetrue=Sum(Fields!Jul_Amt.Value)Jul_Amt=First(Fields!Band5Color.Value, "GetColors")2pt2pt2pt2pttruetrue=Sum(Fields!Aug_Amt.Value)Aug_Amt=First(Fields!Band5Color.Value, "GetColors")2pt2pt2pt2pttruetrue=Sum(Fields!Sep_Amt.Value)Sep_Amt=First(Fields!Band5Color.Value, "GetColors")2pt2pt2pt2pttruetrue=Sum(Fields!Oct_Amt.Value)Oct_Amt=First(Fields!Band5Color.Value, "GetColors")2pt2pt2pt2pttruetrue=Sum(Fields!Nov_Amt.Value)Nov_Amt=First(Fields!Band5Color.Value, "GetColors")2pt2pt2pt2pttruetrue=Sum(Fields!Dec_Amt.Value)Dec_Amt=First(Fields!Band5Color.Value, "GetColors")2pt2pt2pt2pttruetrue=Sum(Fields!Jan_Amt.Value)Jan_Amt=First(Fields!Band5Color.Value, "GetColors")2pt2pt2pt2pttruetrue=Sum(Fields!Feb_Amt.Value)Feb_Amt=First(Fields!Band5Color.Value, "GetColors")2pt2pt2pt2pttruetrue=Sum(Fields!Mar_Amt.Value)Mar_Amt=First(Fields!Band5Color.Value, "GetColors")2pt2pt2pt2pttruetrue=Sum(Fields!Apr_Amt.Value)Apr_Amt=First(Fields!Band5Color.Value, "GetColors")2pt2pt2pt2pttruetrue=Sum(Fields!May_Amt.Value)May_Amt=First(Fields!Band5Color.Value, "GetColors")2pt2pt2pt2pttruetrue=Sum(Fields!Jun_Amt.Value)Jun_Amt=First(Fields!Band5Color.Value, "GetColors")2pt2pt2pt2pttruetrue=SUM(Fields!Summary_Amount.Value,"Gl_Class_Code")Textbox269=First(Fields!Band5Color.Value, "GetColors")2pt2pt2pt2pttruetrue=Sum(Fields!Budget_Amount.Value,"Gl_Class_Code") - SUM(Fields!Summary_Amount.Value,"Gl_Class_Code")Textbox270=First(Fields!Band5Color.Value, "GetColors")2pt2pt2pt2pt0.25intruetrueTextbox238=First(Fields!Band5Color.Value, "GetColors")2pt2pt2pt2pttruetrue=IIF(IsNothing(Sum(Fields!Budget_Amount.Value, "Gl_Class_Code")) or Sum(Fields!Budget_Amount.Value, "Gl_Class_Code") = 0, 0,
Sum(Fields!Jul_Amt.Value) / Sum(Fields!Budget_Amount.Value, "Gl_Class_Code"))Textbox16=First(Fields!Band5Color.Value, "GetColors")2pt2pt2pt2pttruetrue=IIF(IsNothing(Sum(Fields!Budget_Amount.Value, "Gl_Class_Code")) or Sum(Fields!Budget_Amount.Value, "Gl_Class_Code") = 0, 0,
Sum(Fields!Aug_Amt.Value) / Sum(Fields!Budget_Amount.Value, "Gl_Class_Code"))Textbox25=First(Fields!Band5Color.Value, "GetColors")2pt2pt2pt2pttruetrue=IIF(IsNothing(Sum(Fields!Budget_Amount.Value, "Gl_Class_Code")) or Sum(Fields!Budget_Amount.Value, "Gl_Class_Code") = 0, 0,
Sum(Fields!Sep_Amt.Value) / Sum(Fields!Budget_Amount.Value, "Gl_Class_Code"))Textbox36=First(Fields!Band5Color.Value, "GetColors")2pt2pt2pt2pttruetrue=IIF(IsNothing(Sum(Fields!Budget_Amount.Value, "Gl_Class_Code")) or Sum(Fields!Budget_Amount.Value, "Gl_Class_Code") = 0, 0,
Sum(Fields!Oct_Amt.Value) / Sum(Fields!Budget_Amount.Value, "Gl_Class_Code"))Textbox45=First(Fields!Band5Color.Value, "GetColors")2pt2pt2pt2pttruetrue=IIF(IsNothing(Sum(Fields!Budget_Amount.Value, "Gl_Class_Code")) or Sum(Fields!Budget_Amount.Value, "Gl_Class_Code") = 0, 0,
Sum(Fields!Nov_Amt.Value) / Sum(Fields!Budget_Amount.Value, "Gl_Class_Code"))Textbox54=First(Fields!Band5Color.Value, "GetColors")2pt2pt2pt2pttruetrue=IIF(IsNothing(Sum(Fields!Budget_Amount.Value, "Gl_Class_Code")) or Sum(Fields!Budget_Amount.Value, "Gl_Class_Code") = 0, 0,
Sum(Fields!Dec_Amt.Value) / Sum(Fields!Budget_Amount.Value, "Gl_Class_Code"))Textbox67=First(Fields!Band5Color.Value, "GetColors")2pt2pt2pt2pttruetrue=IIF(IsNothing(Sum(Fields!Budget_Amount.Value, "Gl_Class_Code")) or Sum(Fields!Budget_Amount.Value, "Gl_Class_Code") = 0, 0,
Sum(Fields!Jan_Amt.Value) / Sum(Fields!Budget_Amount.Value, "Gl_Class_Code"))Textbox84=First(Fields!Band5Color.Value, "GetColors")2pt2pt2pt2pttruetrue=IIF(IsNothing(Sum(Fields!Budget_Amount.Value, "Gl_Class_Code")) or Sum(Fields!Budget_Amount.Value, "Gl_Class_Code") = 0, 0,
Sum(Fields!Feb_Amt.Value) / Sum(Fields!Budget_Amount.Value, "Gl_Class_Code"))Textbox99=First(Fields!Band5Color.Value, "GetColors")2pt2pt2pt2pttruetrue=IIF(IsNothing(Sum(Fields!Budget_Amount.Value, "Gl_Class_Code")) or Sum(Fields!Budget_Amount.Value, "Gl_Class_Code") = 0, 0,
Sum(Fields!Mar_Amt.Value) / Sum(Fields!Budget_Amount.Value, "Gl_Class_Code"))Textbox108=First(Fields!Band5Color.Value, "GetColors")2pt2pt2pt2pttruetrue=IIF(IsNothing(Sum(Fields!Budget_Amount.Value, "Gl_Class_Code")) or Sum(Fields!Budget_Amount.Value, "Gl_Class_Code") = 0, 0,
Sum(Fields!Apr_Amt.Value) / Sum(Fields!Budget_Amount.Value, "Gl_Class_Code"))Textbox117=First(Fields!Band5Color.Value, "GetColors")2pt2pt2pt2pttruetrue=IIF(IsNothing(Sum(Fields!Budget_Amount.Value, "Gl_Class_Code")) or Sum(Fields!Budget_Amount.Value, "Gl_Class_Code") = 0, 0,
Sum(Fields!May_Amt.Value) / Sum(Fields!Budget_Amount.Value, "Gl_Class_Code"))Textbox126=First(Fields!Band5Color.Value, "GetColors")2pt2pt2pt2pttruetrue=IIF(IsNothing(Sum(Fields!Budget_Amount.Value, "Gl_Class_Code")) or Sum(Fields!Budget_Amount.Value, "Gl_Class_Code") = 0, 0,
Sum(Fields!Jun_Amt.Value) / Sum(Fields!Budget_Amount.Value, "Gl_Class_Code"))Textbox135=First(Fields!Band5Color.Value, "GetColors")2pt2pt2pt2pttruetrue=IIF(IsNothing(Sum(Fields!Budget_Amount.Value, "Gl_Class_Code")) or Sum(Fields!Budget_Amount.Value, "Gl_Class_Code") = 0, 0,
Sum(Fields!Summary_Amount.Value,"Gl_Class_Code") / Sum(Fields!Budget_Amount.Value, "Gl_Class_Code"))Textbox230=First(Fields!Band5Color.Value, "GetColors")2pt2pt2pt2pttruetrue=IIF(IsNothing(Sum(Fields!Budget_Amount.Value, "Gl_Class_Code")) or Sum(Fields!Budget_Amount.Value, "Gl_Class_Code") = 0, 0,
(Sum(Fields!Budget_Amount.Value, "Gl_Class_Code") - Sum(Fields!Summary_Amount.Value)) / Sum(Fields!Budget_Amount.Value, "Gl_Class_Code"))Textbox231=First(Fields!Band5Color.Value, "GetColors")2pt2pt2pt2pt0.25intruetrueTextbox3122pt2pt2pt2pttruetrueTextbox172pt2pt2pt2pttruetrueTextbox262pt2pt2pt2pttruetrueTextbox372pt2pt2pt2pttruetrueTextbox462pt2pt2pt2pttruetrueTextbox552pt2pt2pt2pttruetrueTextbox692pt2pt2pt2pttruetrueTextbox852pt2pt2pt2pttruetrueTextbox1002pt2pt2pt2pttruetrueTextbox1092pt2pt2pt2pttruetrueTextbox1182pt2pt2pt2pttruetrueTextbox1272pt2pt2pt2pttruetrueTextbox1362pt2pt2pt2pttruetrueTextbox3142pt2pt2pt2pttruetrueTextbox3152pt2pt2pt2pt0.25intruetrueBudgetTextbox153=First(Fields!Band1Color.Value, "GetColors")2pt2pt2pt2pttruetrueJulyTextbox10=First(Fields!Band1Color.Value, "GetColors")2pt2pt2pt2pttruetrueAugustTextbox19=First(Fields!Band1Color.Value, "GetColors")2pt2pt2pt2pttruetrueSeptemberTextbox30=First(Fields!Band1Color.Value, "GetColors")2pt2pt2pt2pttruetrueOctoberTextbox39=First(Fields!Band1Color.Value, "GetColors")2pt2pt2pt2pttruetrueNovemberTextbox48=First(Fields!Band1Color.Value, "GetColors")2pt2pt2pt2pttruetrueDecemberTextbox57=First(Fields!Band1Color.Value, "GetColors")2pt2pt2pt2pttruetrueJanuaryTextbox71=First(Fields!Band1Color.Value, "GetColors")2pt2pt2pt2pttruetrueFebruaryTextbox89=First(Fields!Band1Color.Value, "GetColors")2pt2pt2pt2pttruetrueMarchTextbox102=First(Fields!Band1Color.Value, "GetColors")2pt2pt2pt2pttruetrueAprilTextbox111=First(Fields!Band1Color.Value, "GetColors")2pt2pt2pt2pttruetrueMayTextbox120=First(Fields!Band1Color.Value, "GetColors")2pt2pt2pt2pttruetrueJuneTextbox129=First(Fields!Band1Color.Value, "GetColors")2pt2pt2pt2pttruetrueActualTextbox87=First(Fields!Band1Color.Value, "GetColors")2pt2pt2pt2pttruetrueBalanceTextbox91=First(Fields!Band1Color.Value, "GetColors")2pt2pt2pt2pt0.25intruetrueBudgetTextbox153=First(Fields!Band1Color.Value, "GetColors")2pt2pt2pt2pt0.25intruetrueJulyTextbox10=First(Fields!Band1Color.Value, "GetColors")2pt2pt2pt2pt0.25intruetrueAugustTextbox19=First(Fields!Band1Color.Value, "GetColors")2pt2pt2pt2pt0.25intruetrueSeptemberTextbox30=First(Fields!Band1Color.Value, "GetColors")2pt2pt2pt2pt0.25intruetrueOctoberTextbox39=First(Fields!Band1Color.Value, "GetColors")2pt2pt2pt2pt0.25intruetrueNovemberTextbox48=First(Fields!Band1Color.Value, "GetColors")2pt2pt2pt2pt0.25intruetrueDecemberTextbox57=First(Fields!Band1Color.Value, "GetColors")2pt2pt2pt2pt0.25intruetrueJanuaryTextbox71=First(Fields!Band1Color.Value, "GetColors")2pt2pt2pt2pt0.25intruetrueFebruaryTextbox89=First(Fields!Band1Color.Value, "GetColors")2pt2pt2pt2pt0.25intruetrueMarchTextbox102=First(Fields!Band1Color.Value, "GetColors")2pt2pt2pt2pt0.25intruetrueAprilTextbox111=First(Fields!Band1Color.Value, "GetColors")2pt2pt2pt2pt0.25intruetrueMayTextbox120=First(Fields!Band1Color.Value, "GetColors")2pt2pt2pt2pt0.25intruetrueJuneTextbox129=First(Fields!Band1Color.Value, "GetColors")2pt2pt2pt2pt0.25intruetrueActualTextbox87=First(Fields!Band1Color.Value, "GetColors")2pt2pt2pt2pt0.25intruetrueBalanceTextbox91=First(Fields!Band1Color.Value, "GetColors")2pt2pt2pt2pt=Fields!Gl_Class_Code.Value=Fields!Gl_Class_Code.Value=Fields!Glc.Value=Fields!Glc.Value=Fields!State_Org_Unit.Value=Fields!State_Org_Unit.Value0.61458intruetrue=Fields!State_Org_Unit.ValueState_Org_Unit2pt2pt2pt2pt=Fields!Qual1.Value=Fields!Qual1.Value0.47917intruetrue=Fields!Qual1.ValueQual12pt2pt2pt2pt=Fields!Location_Code.Value=Fields!Location_Code.Value0.33333intruetrue=Fields!Location_Code.ValueLocation_Code2pt2pt2pt2pt=Fields!Org_Unit_Name.Value=Fields!Org_Unit_Name.Value1.97917intruetrue=Fields!Org_Unit_Name.ValueOrg_Unit_Name2pt2pt2pt2pt=Fields!Glc.Value=Fields!Glc.Value0.61458intruetrue=Fields!Glc.ValueGlc2pt2pt2pt2pt3.40625intruetrueTotal for Glc =Fields!Glc.ValueTextbox252=First(Fields!BackgroundAlternateColor.Value, "GetColors")2pt2pt2pt2pt0.61458intruetrueTextbox256=First(Fields!BackgroundAlternateColor.Value, "GetColors")2pt2pt2pt2ptBefore3.40625intruetrue% of Budget Spent/RemainingTextbox233=First(Fields!BackgroundAlternateColor.Value, "GetColors")2pt2pt2pt2pt0.61458intruetrueTextbox237=First(Fields!BackgroundAlternateColor.Value, "GetColors")2pt2pt2pt2ptBefore3.40625intruetrueTextbox3172pt2pt2pt2pt0.61458intruetrueTextbox3212pt2pt2pt2ptBefore3.40625intruetrueTotal for GL Class =Fields!Gl_Class_Code.ValueTextbox262=First(Fields!Band5Color.Value, "GetColors")2pt2pt2pt2pt0.61458intruetrueTextbox266=First(Fields!Band5Color.Value, "GetColors")2pt2pt2pt2pt3.40625intruetrue% of Budget Spent/RemainingTextbox223=First(Fields!Band5Color.Value, "GetColors")2pt2pt2pt2pt0.61458intruetrueTextbox227=First(Fields!Band5Color.Value, "GetColors")2pt2pt2pt2pt3.40625intruetrueTextbox3072pt2pt2pt2pt0.61458intruetrueTextbox3112pt2pt2pt2pt=IIF(RowNumber(Nothing) = CountRows("Monthly_Accumulator_Query"), True, False)0.61458intruetrueState OrgTextbox60=First(Fields!Band1Color.Value, "GetColors")2pt2pt2pt2pt0.47917intruetrueQual1Textbox62=First(Fields!Band1Color.Value, "GetColors")2pt2pt2pt2pt0.33333intruetrueLocTextbox64=First(Fields!Band1Color.Value, "GetColors")2pt2pt2pt2pt1.97917intruetrueOrg TitleTextbox66=First(Fields!Band1Color.Value, "GetColors")2pt2pt2pt2pt0.61458intruetrueGlcTextbox68=First(Fields!Band1Color.Value, "GetColors")2pt2pt2pt2pt=IIF(RowNumber(Nothing) = CountRows("Monthly_Accumulator_Query"), True, False)Monthly_Accumulator_Query=Fields!Gl_Class_Code.Value=Fields!Glc.Value=Fields!State_Org_Unit.Value=Fields!Qual1.Value=Fields!Location_Code.Value0.74875in2.25in16.55456in12.99875in16.75247in1in1in1in1in0RSDS_EnterpriseDW_SSASNone95e0f472-c858-414f-a622-ca1d5b24daa5RSDS_EnterpriseDWNone7a877ce5-e9eb-445f-985d-6c4044eb2286RSDS_EnterpriseDW_SSAS=Parameters!DateFiscalYear.Value=Parameters!OrgUnitFundCode.Value=Parameters!OrgUnitLocationDescription.Value=Parameters!OrgUnitOrgUnit.Value=Parameters!GlCodeGlc.Value=Parameters!OrgUnitBudgetManager.Value=Parameters!OrgUnitUserGroup.Value=Parameters!UserId.ValueSELECT
NON EMPTY
{
[Measures].[Budget Amount]
,[Measures].[Summary Amount]
} ON COLUMNS
,
NON EMPTY
{
[Org Unit].[State Org Unit].[State Org Unit].ALLMEMBERS*
[Org Unit].[Qual1].[Qual1].ALLMEMBERS*
[Org Unit].[Location Code].[Location Code].ALLMEMBERS*
[Org Unit].[Org Unit Name].[Org Unit Name].ALLMEMBERS*
[Gl Code].[Gl Class Code].[Gl Class Code].ALLMEMBERS*
[Gl Code].[Glc].[Glc].ALLMEMBERS*
[Date].[Calendar Period].[Calendar Period].ALLMEMBERS*
[Date].[Fiscal Year].[Fiscal Year].ALLMEMBERS
}
DIMENSION PROPERTIES
MEMBER_CAPTION
,MEMBER_UNIQUE_NAME
ON ROWS
FROM
(
SELECT
[Gl Code].[Gl Class Code].&[5] : [Gl Code].[Gl Class Code].&[7] ON COLUMNS
FROM
(
SELECT
StrToSet(@DateFiscalYear) ON COLUMNS
FROM
(
SELECT
StrToSet(@GlCodeGlc) ON COLUMNS
FROM
(
SELECT
StrToSet(@OrgUnitOrgUnit) ON COLUMNS
FROM
(
SELECT
StrToSet(@OrgUnitLocationDescription) ON COLUMNS
FROM
(
SELECT
StrToSet(@OrgUnitUserGroup) ON COLUMNS
FROM
(
SELECT
StrToSet(@OrgUnitBudgetManager) ON COLUMNS
FROM
(
SELECT
StrToSet(@OrgUnitFundCode) ON COLUMNS
FROM [Executive_Integrated_Financials]
)
)
)
)
)
)
)
)
WHERE
NONEMPTY
(
[Org Unit].[Org Unit SK].[Org Unit SK].Members,
(
STRTOMEMBER(@UserId)
,[Measures].[Fact Org Unit User Bridge Count]
)
)MDXQueryExecutive_Integrated_FinancialsSELECT
NON EMPTY
{
[Measures].[Budget Amount]
,[Measures].[Summary Amount]
} ON COLUMNS
,
NON EMPTY
{
[Org Unit].[State Org Unit].[State Org Unit].ALLMEMBERS*
[Org Unit].[Qual1].[Qual1].ALLMEMBERS*
[Org Unit].[Location Code].[Location Code].ALLMEMBERS*
[Org Unit].[Org Unit Name].[Org Unit Name].ALLMEMBERS*
[Gl Code].[Gl Class Code].[Gl Class Code].ALLMEMBERS*
[Gl Code].[Glc].[Glc].ALLMEMBERS*
[Date].[Calendar Period].[Calendar Period].ALLMEMBERS*
[Date].[Fiscal Year].[Fiscal Year].ALLMEMBERS
}
DIMENSION PROPERTIES
MEMBER_CAPTION
,MEMBER_UNIQUE_NAME
ON ROWS
FROM
(
SELECT
[Gl Code].[Gl Class Code].&[5] : [Gl Code].[Gl Class Code].&[7] ON COLUMNS
FROM
(
SELECT
StrToSet(@DateFiscalYear) ON COLUMNS
FROM
(
SELECT
StrToSet(@GlCodeGlc) ON COLUMNS
FROM
(
SELECT
StrToSet(@OrgUnitOrgUnit) ON COLUMNS
FROM
(
SELECT
StrToSet(@OrgUnitLocationDescription) ON COLUMNS
FROM
(
SELECT
StrToSet(@OrgUnitUserGroup) ON COLUMNS
FROM
(
SELECT
StrToSet(@OrgUnitBudgetManager) ON COLUMNS
FROM
(
SELECT
StrToSet(@OrgUnitFundCode) ON COLUMNS
FROM [Executive_Integrated_Financials]
)
)
)
)
)
)
)
)
WHERE
NONEMPTY
(
[Org Unit].[Org Unit SK].[Org Unit SK].Members,
(
STRTOMEMBER(@UserId)
,[Measures].[Fact Org Unit User Bridge Count]
)
)
DateFiscalYear[Date].[Fiscal Year].&[FY 2013]
Date.Fiscal Year
[Date].[Fiscal Year]WITH MEMBER [Measures].[ParameterCaption] AS [Date].[Fiscal Year].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Date].[Fiscal Year].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Date].[Fiscal Year].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Date].[Fiscal Year].ALLMEMBERS ON ROWS FROM [Executive_Integrated_Financials]trueOrgUnitFundCode[Org Unit].[Fund Code].[All]
Fund Code
[Org Unit].[Fund Code]WITH MEMBER [Measures].[ParameterCaption] AS [Org Unit].[Fund Code].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Org Unit].[Fund Code].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Org Unit].[Fund Code].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Org Unit].[Fund Code].ALLMEMBERS ON ROWS FROM [Executive_Integrated_Financials]trueOrgUnitLocationDescription[Org Unit].[Location Description].[All]
OrgUnitLocationDescription
[Org Unit].[Location Description]WITH MEMBER [Measures].[ParameterCaption] AS [Org Unit].[Location Description].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Org Unit].[Location Description].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Org Unit].[Location Description].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Org Unit].[Location Description].ALLMEMBERS ON ROWS FROM [Executive_Integrated_Financials]trueGlCodeGlc[Gl Code].[Glc].[All]
Glc
[Gl Code].[Glc]WITH MEMBER [Measures].[ParameterCaption] AS [Gl Code].[Glc].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Gl Code].[Glc].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Gl Code].[Glc].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Gl Code].[Glc].ALLMEMBERS ON ROWS FROM [Executive_Integrated_Financials]trueOrgUnitOrgUnit[Org Unit].[Org Unit].[All]
OrgUnitOrgUnit
[Org Unit].[Org Unit]WITH MEMBER [Measures].[ParameterCaption] AS [Org Unit].[Org Unit].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Org Unit].[Org Unit].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Org Unit].[Org Unit].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Org Unit].[Org Unit].ALLMEMBERS ON ROWS FROM [Executive_Integrated_Financials]trueOrgUnitBudgetManager[Org Unit].[Budget Manager].[All]
OrgUnitBudgetManager
[Org Unit].[Budget Manager]WITH MEMBER [Measures].[ParameterCaption] AS [Org Unit].[Budget Manager].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Org Unit].[Budget Manager].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Org Unit].[Budget Manager].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Org Unit].[Budget Manager].ALLMEMBERS ON ROWS FROM [Executive_Integrated_Financials]trueOrgUnitUserGroup[Org Unit].[User Group].[All]
OrgUnitUserGroup
[Org Unit].[User Group]WITH MEMBER [Measures].[ParameterCaption] AS [Org Unit].[User Group].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Org Unit].[User Group].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Org Unit].[User Group].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Org Unit].[User Group].ALLMEMBERS ON ROWS FROM [Executive_Integrated_Financials]trueUserId[User].[Domain User Id].&[ad\scowan]
UserId
[User].[Domain User Id]WITH MEMBER [Measures].[ParameterCaption] AS [User].[Domain User Id].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [User].[Domain User Id].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [User].[Domain User Id].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [User].[Domain User Id].ALLMEMBERS ON ROWS FROM [Executive_Integrated_Financials]<?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="[Org Unit].[State Org Unit].[State Org Unit]" />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="[Org Unit].[Qual1].[Qual1]" />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="[Gl Code].[Gl Class Code].[Gl Class Code]" />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="[Org Unit].[Location Code].[Location Code]" />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="[Gl Code].[Glc].[Glc]" />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="[Org Unit].[Org Unit Name].[Org Unit 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="Measure" UniqueName="[Measures].[Summary 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="[Date].[Calendar Period].[Calendar Period]" />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="[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].[Budget Amount]" />System.Int32=IIF(Right(Fields!Calendar_Period.Value,2) = "07", IIF(IsNothing(Fields!Summary_Amount.Value),0,Fields!Summary_Amount.Value) ,0)=IIF(Right(Fields!Calendar_Period.Value,2) = "08", IIF(IsNothing(Fields!Summary_Amount.Value),0,Fields!Summary_Amount.Value) ,0)=IIF(Right(Fields!Calendar_Period.Value,2) = "09", IIF(IsNothing(Fields!Summary_Amount.Value),0,Fields!Summary_Amount.Value) ,0)=IIF(Right(Fields!Calendar_Period.Value,2) = "10", IIF(IsNothing(Fields!Summary_Amount.Value),0,Fields!Summary_Amount.Value) ,0)=IIF(Right(Fields!Calendar_Period.Value,2) = "11", IIF(IsNothing(Fields!Summary_Amount.Value),0,Fields!Summary_Amount.Value) ,0)=IIF(Right(Fields!Calendar_Period.Value,2) = "12", IIF(IsNothing(Fields!Summary_Amount.Value),0,Fields!Summary_Amount.Value) ,0)=IIF(Right(Fields!Calendar_Period.Value,2) = "01", IIF(IsNothing(Fields!Summary_Amount.Value),0,Fields!Summary_Amount.Value) ,0)=IIF(Right(Fields!Calendar_Period.Value,2) = "02", IIF(IsNothing(Fields!Summary_Amount.Value),0,Fields!Summary_Amount.Value) ,0)=IIF(Right(Fields!Calendar_Period.Value,2) = "03", IIF(IsNothing(Fields!Summary_Amount.Value),0,Fields!Summary_Amount.Value) ,0)=IIF(Right(Fields!Calendar_Period.Value,2) = "04", IIF(IsNothing(Fields!Summary_Amount.Value),0,Fields!Summary_Amount.Value) ,0)=IIF(Right(Fields!Calendar_Period.Value,2) = "05", IIF(IsNothing(Fields!Summary_Amount.Value),0,Fields!Summary_Amount.Value) ,0)=IIF(Right(Fields!Calendar_Period.Value,2) = "06", IIF(IsNothing(Fields!Summary_Amount.Value),0,Fields!Summary_Amount.Value) ,0)RSDS_EnterpriseDW_SSASWITH MEMBER [Measures].[ParameterCaption] AS [User].[Domain User Id].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [User].[Domain User Id].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [User].[Domain User Id].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [User].[Domain User Id].ALLMEMBERS ON ROWS FROM [Executive_Integrated_Financials]MDXQueryExecutive_Integrated_FinancialsWITH MEMBER [Measures].[ParameterCaption] AS [User].[Domain User Id].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [User].[Domain User Id].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [User].[Domain User Id].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [User].[Domain User Id].ALLMEMBERS ON ROWS FROM [Executive_Integrated_Financials]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_EnterpriseDWSELECT BackgroundColor, BackgroundAlternateColor, Band1Color, Band2Color, Band3Color, Band4Color, Band5Color, Band6Color
FROM Configuration_Color
WHERE (ReportType = 'GeneralLedger')BackgroundColorSystem.StringBackgroundAlternateColorSystem.StringBand1ColorSystem.StringBand2ColorSystem.StringBand3ColorSystem.StringBand4ColorSystem.StringBand5ColorSystem.StringBand6ColorSystem.StringRSDS_EnterpriseDW_SSAS=Parameters!OrgUnitFundCode.ValueWITH MEMBER [Measures].[ParameterCaption] AS [Org Unit].[Location Code].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Org Unit].[Location Code].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Org Unit].[Location Code].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Org Unit].[Location Code].ALLMEMBERS ON ROWS
FROM
(
SELECT
StrToSet
(@OrgUnitFundCode
,CONSTRAINED
) ON COLUMNS
FROM [Executive_Integrated_Financials]
)MDXQueryExecutive_Integrated_FinancialsWITH MEMBER [Measures].[ParameterCaption] AS [Org Unit].[Location Code].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Org Unit].[Location Code].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Org Unit].[Location Code].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Org Unit].[Location Code].ALLMEMBERS ON ROWS
FROM
(
SELECT
StrToSet
(@OrgUnitFundCode
,CONSTRAINED
) ON COLUMNS
FROM [Executive_Integrated_Financials]
)OrgUnitFundCode[Org Unit].[Fund Code].[All]
OrgUnitFundCode
[Org Unit].[Fund Code]WITH MEMBER [Measures].[ParameterCaption] AS [Org Unit].[Fund Code].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Org Unit].[Fund Code].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Org Unit].[Fund Code].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Org Unit].[Fund Code].ALLMEMBERS ON ROWS FROM [Executive_Integrated_Financials]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="[Org Unit].[Location Code].[Location Code]" />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].[ParameterCaption] AS
[Gl Code].[Glc].CurrentMember.Member_Caption
MEMBER [Measures].[ParameterValue] AS
[Gl Code].[Glc].CurrentMember.UniqueName
MEMBER [Measures].[ParameterLevel] AS
[Gl Code].[Glc].CurrentMember.Level.Ordinal
SELECT
{
[Measures].[ParameterCaption]
,[Measures].[ParameterValue]
,[Measures].[ParameterLevel]
} ON COLUMNS
,[Gl Code].[Glc].ALLMEMBERS ON ROWS
FROM [Executive_Integrated_Financials]
WHERE {[Gl Code].[Gl Class Code].&[5] : [Gl Code].[Gl Class Code].&[7]}MDXQueryExecutive_Integrated_FinancialsWITH
MEMBER [Measures].[ParameterCaption] AS
[Gl Code].[Glc].CurrentMember.Member_Caption
MEMBER [Measures].[ParameterValue] AS
[Gl Code].[Glc].CurrentMember.UniqueName
MEMBER [Measures].[ParameterLevel] AS
[Gl Code].[Glc].CurrentMember.Level.Ordinal
SELECT
{
[Measures].[ParameterCaption]
,[Measures].[ParameterValue]
,[Measures].[ParameterLevel]
} ON COLUMNS
,[Gl Code].[Glc].ALLMEMBERS ON ROWS
FROM [Executive_Integrated_Financials]
WHERE {[Gl Code].[Gl Class Code].&[5] : [Gl Code].[Gl Class Code].&[7]}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="[Gl Code].[Glc].[Glc]" />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!OrgUnitFundCode.ValueWITH MEMBER [Measures].[ParameterCaption] AS [Org Unit].[Org Unit].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Org Unit].[Org Unit].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Org Unit].[Org Unit].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Org Unit].[Org Unit].ALLMEMBERS ON ROWS
FROM
(
SELECT
StrToSet
(@OrgUnitFundCode
,CONSTRAINED
) ON COLUMNS
FROM [Executive_Integrated_Financials]
)MDXQueryExecutive_Integrated_FinancialsWITH MEMBER [Measures].[ParameterCaption] AS [Org Unit].[Org Unit].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Org Unit].[Org Unit].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Org Unit].[Org Unit].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Org Unit].[Org Unit].ALLMEMBERS ON ROWS
FROM
(
SELECT
StrToSet
(@OrgUnitFundCode
,CONSTRAINED
) ON COLUMNS
FROM [Executive_Integrated_Financials]
)OrgUnitFundCode[Org Unit].[Fund Code].[All]
OrgUnitFundCode
[Org Unit].[Fund Code]WITH MEMBER [Measures].[ParameterCaption] AS [Org Unit].[Fund Code].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Org Unit].[Fund Code].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Org Unit].[Fund Code].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Org Unit].[Fund Code].ALLMEMBERS ON ROWS FROM [Executive_Integrated_Financials]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="[Org Unit].[Org Unit].[Org Unit]" />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!OrgUnitFundCode.ValueWITH MEMBER [Measures].[ParameterCaption] AS [Org Unit].[Budget Manager].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Org Unit].[Budget Manager].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Org Unit].[Budget Manager].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Org Unit].[Budget Manager].ALLMEMBERS ON ROWS
FROM
(
SELECT
StrToSet
(@OrgUnitFundCode
,CONSTRAINED
) ON COLUMNS
FROM [Executive_Integrated_Financials]
)MDXQueryExecutive_Integrated_FinancialsWITH MEMBER [Measures].[ParameterCaption] AS [Org Unit].[Budget Manager].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Org Unit].[Budget Manager].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Org Unit].[Budget Manager].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Org Unit].[Budget Manager].ALLMEMBERS ON ROWS
FROM
(
SELECT
StrToSet
(@OrgUnitFundCode
,CONSTRAINED
) ON COLUMNS
FROM [Executive_Integrated_Financials]
)OrgUnitFundCode[Org Unit].[Fund Code].[All]
OrgUnitFundCode
[Org Unit].[Fund Code]WITH MEMBER [Measures].[ParameterCaption] AS [Org Unit].[Fund Code].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Org Unit].[Fund Code].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Org Unit].[Fund Code].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Org Unit].[Fund Code].ALLMEMBERS ON ROWS FROM [Executive_Integrated_Financials]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="[Org Unit].[Budget Manager].[Budget Manager]" />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!OrgUnitFundCode.ValueWITH MEMBER [Measures].[ParameterCaption] AS [Org Unit].[User Group].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Org Unit].[User Group].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Org Unit].[User Group].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Org Unit].[User Group].ALLMEMBERS ON ROWS
FROM
(
SELECT
StrToSet
(@OrgUnitFundCode
,CONSTRAINED
) ON COLUMNS
FROM [Executive_Integrated_Financials]
)MDXQueryExecutive_Integrated_FinancialsWITH MEMBER [Measures].[ParameterCaption] AS [Org Unit].[User Group].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Org Unit].[User Group].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Org Unit].[User Group].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Org Unit].[User Group].ALLMEMBERS ON ROWS
FROM
(
SELECT
StrToSet
(@OrgUnitFundCode
,CONSTRAINED
) ON COLUMNS
FROM [Executive_Integrated_Financials]
)OrgUnitFundCode[Org Unit].[Fund Code].[All]
OrgUnitFundCode
[Org Unit].[Fund Code]WITH MEMBER [Measures].[ParameterCaption] AS [Org Unit].[Fund Code].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Org Unit].[Fund Code].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Org Unit].[Fund Code].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Org Unit].[Fund Code].ALLMEMBERS ON ROWS FROM [Executive_Integrated_Financials]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="[Org Unit].[User Group].[User Group]" />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].[ParameterCaption] AS
[Date].[Fiscal Year].CurrentMember.Member_Caption
MEMBER [Measures].[ParameterValue] AS
[Date].[Fiscal Year].CurrentMember.UniqueName
MEMBER [Measures].[ParameterLevel] AS
[Date].[Fiscal Year].CurrentMember.Level.Ordinal
SELECT
{
[Measures].[ParameterCaption]
,[Measures].[ParameterValue]
,[Measures].[ParameterLevel]
} ON COLUMNS,
ORDER(
{[Date].[Fiscal Year].Children},[Measures].[ParameterCaption], DESC
) ON ROWS
FROM
(
SELECT
{
([Date].[Fiscal Year].[Fiscal Year].Members
,[Date].[Is Current Fiscal Year].&[Y]
,[Date].[Is Available For Finance].&[Y])
,
([Date].[Fiscal Year].[Fiscal Year].Members
,[Date].[Is Current Fiscal Year].Children
,[Date].[Is Available For Finance].&[Y]
)
} ON COLUMNS
FROM [Executive_Integrated_Financials]
)MDXQueryExecutive_Integrated_FinancialsWITH
MEMBER [Measures].[ParameterCaption] AS
[Date].[Fiscal Year].CurrentMember.Member_Caption
MEMBER [Measures].[ParameterValue] AS
[Date].[Fiscal Year].CurrentMember.UniqueName
MEMBER [Measures].[ParameterLevel] AS
[Date].[Fiscal Year].CurrentMember.Level.Ordinal
SELECT
{
[Measures].[ParameterCaption]
,[Measures].[ParameterValue]
,[Measures].[ParameterLevel]
} ON COLUMNS,
ORDER(
{[Date].[Fiscal Year].Children},[Measures].[ParameterCaption], DESC
) ON ROWS
FROM
(
SELECT
{
([Date].[Fiscal Year].[Fiscal Year].Members
,[Date].[Is Current Fiscal Year].&[Y]
,[Date].[Is Available For Finance].&[Y])
,
([Date].[Fiscal Year].[Fiscal Year].Members
,[Date].[Is Current Fiscal Year].Children
,[Date].[Is Available For Finance].&[Y]
)
} ON COLUMNS
FROM [Executive_Integrated_Financials]
)<?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="[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.Int32RSDS_EnterpriseDW_SSASWITH MEMBER [Measures].[ParameterValue]
AS [Date].[Fiscal Year].CURRENTMEMBER.UNIQUENAME
SELECT
[Measures].[ParameterValue] ON COLUMNS,
[Date].[Fiscal Year].Children ON ROWS
FROM [Executive_Integrated_Financials]
WHERE [Date].[Is Current Fiscal Year].&[Y]MDXQueryExecutive_Integrated_FinancialsWITH MEMBER [Measures].[ParameterValue]
AS [Date].[Fiscal Year].CURRENTMEMBER.UNIQUENAME
SELECT
[Measures].[ParameterValue] ON COLUMNS,
[Date].[Fiscal Year].Children ON ROWS
FROM [Executive_Integrated_Financials]
WHERE [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="[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.Int32RSDS_EnterpriseDW_SSASWITH
MEMBER [Measures].[ParameterCaption] AS
[Org Unit].[Fund Code].CurrentMember.Member_Caption
MEMBER [Measures].[ParameterValue] AS
[Org Unit].[Fund Code].CurrentMember.UniqueName
MEMBER [Measures].[ParameterLevel] AS
[Org Unit].[Fund Code].CurrentMember.Level.Ordinal
SELECT
{
[Measures].[ParameterCaption]
,[Measures].[ParameterValue]
,[Measures].[ParameterLevel]
} ON COLUMNS
,[Org Unit].[Fund Code].ALLMEMBERS ON ROWS
FROM [Executive_Integrated_Financials]MDXQueryExecutive_Integrated_FinancialsWITH
MEMBER [Measures].[ParameterCaption] AS
[Org Unit].[Fund Code].CurrentMember.Member_Caption
MEMBER [Measures].[ParameterValue] AS
[Org Unit].[Fund Code].CurrentMember.UniqueName
MEMBER [Measures].[ParameterLevel] AS
[Org Unit].[Fund Code].CurrentMember.Level.Ordinal
SELECT
{
[Measures].[ParameterCaption]
,[Measures].[ParameterValue]
,[Measures].[ParameterLevel]
} ON COLUMNS
,[Org Unit].[Fund Code].ALLMEMBERS ON ROWS
FROM [Executive_Integrated_Financials]<?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="[Org Unit].[Fund Code].[Fund Code]" />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.Int32RSDS_EnterpriseDWSELECT ImageType, ImageLocation, SuggestedImageSize
FROM Configuration_Image
WHERE (ImageType = 'Banner')ImageTypeSystem.StringImageLocationSystem.StringSuggestedImageSizeSystem.StringRSDS_EnterpriseDW_SSASWITH MEMBER [Measures].[ParameterCaption] AS [Org Unit].[Location Description].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Org Unit].[Location Description].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Org Unit].[Location Description].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Org Unit].[Location Description].ALLMEMBERS ON ROWS FROM [Executive_Integrated_Financials]MDXQueryExecutive_Integrated_FinancialsWITH MEMBER [Measures].[ParameterCaption] AS [Org Unit].[Location Description].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Org Unit].[Location Description].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Org Unit].[Location Description].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Org Unit].[Location Description].ALLMEMBERS ON ROWS FROM [Executive_Integrated_Financials]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.StringStringDefault_Fiscal_YearParameterValueFiscal YearDateFiscalYearParameterValueParameterCaptionString[Org Unit].[Fund Code].[All]Fund CodeOrgUnitFundCodeParameterValueParameterCaptiontrueString="[User].[Domain User Id].&["+User!UserID+"]"trueString[Gl Code].[Glc].[All]GlcGlCodeGlcParameterValueParameterCaptionIndentedtrueString[Org Unit].[Org Unit].[All]Org UnitOrgUnitOrgUnitParameterValueParameterCaptionIndentedtrueString[Org Unit].[Budget Manager].[All]Budget ManagerOrgUnitBudgetManagerParameterValueParameterCaptionIndentedtrueString[Org Unit].[User Group].[All]User GroupOrgUnitUserGroupParameterValueParameterCaptionIndentedtrueString[Org Unit].[Location Description].[All]LocationOrgUnitLocationDescriptionParameterValueParameterCaptionIndentedtruePrivate bOddRow As Boolean
Function AlternateColor (ByVal OddColor As String, ByVal EvenColor As String, ByVal Toggle As Boolean) As String
If Toggle Then bOddRow = Not bOddRow
If bOddRow Then
Return OddColor
Else
Return EvenColor
End If
End FunctionInchba2cb72b-2313-457d-8a5d-af4cb89bf676