0RSDS_EnterpriseDW_SSASNone95e0f472-c858-414f-a622-ca1d5b24daa5RSDS_EnterpriseDWNone7b945d79-7e23-4349-9363-1c3a7b045fcaRSDS_EnterpriseDW_SSAS=Parameters!DateFiscalYear.Value SELECT NON EMPTY { [Measures].[Expense Amount] } ON COLUMNS, NON EMPTY { ([Position].[Position Code].[Position Code].ALLMEMBERS * [Position].[Position Title].[Position Title].ALLMEMBERS * [Position].[Position Type].[Position Type].ALLMEMBERS * [Assignment].[Assignment AK].[Assignment AK].ALLMEMBERS * [Assignment].[Assignment Status].[Assignment Status].ALLMEMBERS * [Employee].[Full Name].[Full Name].ALLMEMBERS * [Org Unit].[Org Unit].[Org Unit].ALLMEMBERS ) } DIMENSION PROPERTIES MEMBER_CAPTION, MEMBER_UNIQUE_NAME ON ROWS FROM ( SELECT ( { [Position].[Multiple Funds].&[Yes] } ) ON COLUMNS FROM ( SELECT ( STRTOSET(@DateFiscalYear, CONSTRAINED) ) ON COLUMNS FROM [HR_Payroll])) WHERE ( IIF( STRTOSET(@DateFiscalYear, CONSTRAINED).Count = 1, STRTOSET(@DateFiscalYear, CONSTRAINED), [Date].[Fiscal Year].currentmember ), [Position].[Multiple Funds].&[Yes] ) CELL PROPERTIES VALUE, BACK_COLOR, FORE_COLOR, FORMATTED_VALUE, FORMAT_STRING, FONT_NAME, FONT_SIZE, FONT_FLAGSMDXHR_Payroll[Date].[Fiscal Year][Date].[Fiscal Year].&[FY 2015]true[Position].[Multiple Funds][Position].[Multiple Funds].&[Yes] SELECT NON EMPTY { [Measures].[Expense Amount] } ON COLUMNS, NON EMPTY { ([Position].[Position Code].[Position Code].ALLMEMBERS * [Position].[Position Title].[Position Title].ALLMEMBERS * [Position].[Position Type].[Position Type].ALLMEMBERS * [Assignment].[Assignment AK].[Assignment AK].ALLMEMBERS * [Assignment].[Assignment Status].[Assignment Status].ALLMEMBERS * [Employee].[Full Name].[Full Name].ALLMEMBERS * [Org Unit].[Org Unit].[Org Unit].ALLMEMBERS ) } DIMENSION PROPERTIES MEMBER_CAPTION, MEMBER_UNIQUE_NAME ON ROWS FROM ( SELECT ( { [Position].[Multiple Funds].&[Yes] } ) ON COLUMNS FROM ( SELECT ( STRTOSET(@DateFiscalYear, CONSTRAINED) ) ON COLUMNS FROM [HR_Payroll])) WHERE ( IIF( STRTOSET(@DateFiscalYear, CONSTRAINED).Count = 1, STRTOSET(@DateFiscalYear, CONSTRAINED), [Date].[Fiscal Year].currentmember ), [Position].[Multiple Funds].&[Yes] ) CELL PROPERTIES VALUE, BACK_COLOR, FORE_COLOR, FORMATTED_VALUE, FORMAT_STRING, FONT_NAME, FONT_SIZE, FONT_FLAGSDateFiscalYear[Date].[Fiscal Year].&[FY 2015]
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 [HR_Payroll]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="[Position].[Position Code].[Position 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="[Assignment].[Assignment AK].[Assignment AK]" />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="[Position].[Position Title].[Position Title]" />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="[Employee].[Full Name].[Full 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="[Position].[Position Type].[Position 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="[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].[Expense Amount]" />System.Int32RSDS_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_EnterpriseDWSELECT ImageType, ImageLocation, SuggestedImageSize
FROM Configuration_Image
WHERE (ImageType = 'Banner')ImageTypeSystem.StringImageLocationSystem.StringSuggestedImageSizeSystem.StringRSDS_EnterpriseDW_SSASWITH MEMBER [Measures].[ParameterValue]
AS [Date].[Fiscal Year].CURRENTMEMBER.UNIQUENAME
SELECT
[Measures].[ParameterValue] ON COLUMNS,
[Date].[Fiscal Year].Children ON ROWS
FROM [HR_Payroll]
WHERE [Date].[Is Current Fiscal Year].&[Y]MDXQueryHR_PayrollWITH MEMBER [Measures].[ParameterValue]
AS [Date].[Fiscal Year].CURRENTMEMBER.UNIQUENAME
SELECT
[Measures].[ParameterValue] ON COLUMNS,
[Date].[Fiscal Year].Children ON ROWS
FROM [HR_Payroll]
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
[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 [HR_Payroll]
)MDXQueryHR_PayrollWITH
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 [HR_Payroll]
)<?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.Int32=Space(3*Fields!ParameterLevel.Value) + Fields!ParameterCaption.ValueRSDS_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.Int32=Space(3*Fields!ParameterLevel.Value) + Fields!ParameterCaption.ValueRSDS_EnterpriseDW_SSAS WITH
MEMBER [Measures].[ParameterCaption] AS
[Org Unit].[Function Description].CurrentMember.Member_Caption
MEMBER [Measures].[ParameterValue] AS
[Org Unit].[Function Description].CurrentMember.UniqueName
MEMBER [Measures].[ParameterLevel] AS
[Org Unit].[Function Description].CurrentMember.Level.Ordinal
SELECT
{
[Measures].[ParameterCaption]
,[Measures].[ParameterValue]
,[Measures].[ParameterLevel]
} ON COLUMNS
,[Org Unit].[Function Description].ALLMEMBERS ON ROWS
FROM [Executive_Integrated_Financials]MDXQueryExecutive_Integrated_Financials WITH
MEMBER [Measures].[ParameterCaption] AS
[Org Unit].[Function Description].CurrentMember.Member_Caption
MEMBER [Measures].[ParameterValue] AS
[Org Unit].[Function Description].CurrentMember.UniqueName
MEMBER [Measures].[ParameterLevel] AS
[Org Unit].[Function Description].CurrentMember.Level.Ordinal
SELECT
{
[Measures].[ParameterCaption]
,[Measures].[ParameterValue]
,[Measures].[ParameterLevel]
} ON COLUMNS
,[Org Unit].[Function Description].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].[Function Description].[Function Description]" />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.ValueRSDS_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]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="[Org Unit].[Location Description].[Location Description]" />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.StringExternal=First(Fields!ImageLocation.Value, "GetImage")FitProportional0.16604in2.36396in0.5in7.17708inHETGrouptruetruePosition CodeTextbox22=First(Fields!Band3Color.Value, "GetColors")2pt2pt2pt2pttruetruePosition TitleTextbox38=First(Fields!Band3Color.Value, "GetColors")2pt2pt2pt2pttruetrueFull NameTextbox45=First(Fields!Band3Color.Value, "GetColors")2pt2pt2pt2pttruetrueAssignmentTextbox47=First(Fields!Band3Color.Value, "GetColors")2pt2pt2pt2pttruetrueOrg UnitTextbox25=First(Fields!Band3Color.Value, "GetColors")2pt2pt2pt2pt1in0.25intruetrue=Sum(Fields!Expense_Amount.Value)Expense_Amount=First(Fields!BackgroundColor.Value, "GetColors")2pt2pt2pt2pt0.25intruetrue=Sum(Fields!Expense_Amount.Value)Textbox61=First(Fields!BackgroundAlternateColor.Value, "GetColors")2pt2pt2pt2pt0.25intruetrueExpense AmountTextbox20=First(Fields!Band3Color.Value, "GetColors")2pt2pt2pt2pt=Fields!Position_Code.Value=Fields!Position_Code.Value1intruetrue=Fields!Position_Code.ValuePosition_Code=First(Fields!BackgroundAlternateColor.Value, "GetColors")2pt2pt2pt2pt=Fields!Position_Title.Value=Fields!Position_Title.Value2.05208intruetrue=Fields!Position_Title.ValuePosition_Title=First(Fields!BackgroundColor.Value, "GetColors")2pt2pt2pt2pt=Fields!Full_Name.Value=Fields!Full_Name.Value2.57292intruetrue=Fields!Full_Name.ValueFull_Name=First(Fields!BackgroundColor.Value, "GetColors")2pt2pt2pt2pt=Fields!Assignment_AK.Value=Fields!Assignment_AK.Value1.91604intruetrue=Fields!Assignment_AK.ValueAssignment_AK=First(Fields!BackgroundColor.Value, "GetColors")2pt2pt2pt2pt=Fields!Org_Unit.Value=Fields!Org_Unit.Value2.47917intruetrue=Fields!Org_Unit.ValueOrg_Unit=First(Fields!BackgroundColor.Value, "GetColors")2pt2pt2pt2pt4.625intruetrueTextbox89=First(Fields!BackgroundAlternateColor.Value, "GetColors")2pt2pt2pt2pt1.91604intruetrueTextbox59=First(Fields!BackgroundAlternateColor.Value, "GetColors")2pt2pt2pt2pt2.47917intruetrueTextbox60=First(Fields!BackgroundAlternateColor.Value, "GetColors")2pt2pt2pt2ptBeforeMultipleFunds_Query1.32167in0.01103in0.75in11.02021in1truetruePositions with Multiple Funds ReportTextbox10.85292in3.50917in0.25in4.76042in22pt2pt2pt2pt2.07167in11.03124in1in1in1in1inStringDefaultFiscalYearParameterValueFiscal YearDateFiscalYearParameterValueParameterCaptionPrivate 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 Function
Function RestartColor(ByVal OddColor As String) As String
bOddRow = True
Return OddColor
End Function
Inchba2cb72b-2313-457d-8a5d-af4cb89bf676