truetrueTextbox27=First(Fields!Band1Color.Value, "GetColors")2pt2pt2pt2pt20.90625in0.25intruetrue=Fields!Budget_Revenue.ValueBudget_Revenue1=Code.AlternateColor(First(Fields!BackgroundAlternateColor.Value, "GetColors"),First(Fields!BackgroundColor.Value, "GetColors"),False)2pt2pt2pt2pt0.25intruetrue=Sum(Fields!Budget_Expenses.Value)Textbox3=Code.AlternateColor(First(Fields!BackgroundAlternateColor.Value, "GetColors"),First(Fields!BackgroundColor.Value, "GetColors"),False)2pt2pt2pt2pt0.25intruetrue=Sum(Fields!Actual_Revenue.Value)Textbox10=Code.AlternateColor(First(Fields!BackgroundAlternateColor.Value, "GetColors"),First(Fields!BackgroundColor.Value, "GetColors"),False)2pt2pt2pt2pt0.25intruetrue=Sum(Fields!Actual_Expenses.Value)Textbox14=Code.AlternateColor(First(Fields!BackgroundAlternateColor.Value, "GetColors"),First(Fields!BackgroundColor.Value, "GetColors"),False)2pt2pt2pt2pt=Fields!Month_Of_Year.Value=Fields!Calendar_Period.Value0.25intruetrue=Fields!Month_Of_Year.ValueMonth=First(Fields!Band1Color.Value, "GetColors")2pt2pt2pt2pt=Fields!Fiscal_Year.Value=Fields!Fiscal_Year.Value1.19792intrueActual_to_Revenue_QuerytrueBudget RevenueTextbox28=Code.AlternateColor(First(Fields!BackgroundColor.Value, "GetColors"),First(Fields!BackgroundColor.Value, "GetColors"),True)2pt2pt2pt2pt0.59375intruetrue=Fields!Fiscal_Year.ValueFiscal_Year=Code.AlternateColor(First(Fields!BackgroundAlternateColor.Value, "GetColors"),First(Fields!BackgroundColor.Value, "GetColors"),False)2pt2pt2pt2pt=Fields!Fiscal_Year.Value=Fields!Fiscal_Year.Value1.19792intrueActual_to_Revenue_QuerytrueBudget ExpensesFiscal_Year1=Code.AlternateColor(First(Fields!BackgroundColor.Value, "GetColors"),First(Fields!BackgroundColor.Value, "GetColors"),True)2pt2pt2pt2pt0.59375intruetrue=Fields!Fiscal_Year.ValueFiscal_Year1=Code.AlternateColor(First(Fields!BackgroundAlternateColor.Value, "GetColors"),First(Fields!BackgroundColor.Value, "GetColors"),False)2pt2pt2pt2pt=Fields!Fiscal_Year.Value=Fields!Fiscal_Year.Value1.19792intrueActual_to_Revenue_QuerytrueActual RevenueFiscal_Year21=Code.AlternateColor(First(Fields!BackgroundColor.Value, "GetColors"),First(Fields!BackgroundColor.Value, "GetColors"),True)2pt2pt2pt2pt0.59375intruetrue=Fields!Fiscal_Year.ValueFiscal_Year1=Code.AlternateColor(First(Fields!BackgroundAlternateColor.Value, "GetColors"),First(Fields!BackgroundColor.Value, "GetColors"),False)2pt2pt2pt2pt=Fields!Fiscal_Year.Value=Fields!Fiscal_Year.Value1.19792intrueActual_to_Revenue_QuerytrueActual ExpensesFiscal_Year31=Code.AlternateColor(First(Fields!BackgroundColor.Value, "GetColors"),First(Fields!BackgroundColor.Value, "GetColors"),True)2pt2pt2pt2pt0.59375intruetrue=Fields!Fiscal_Year.ValueFiscal_Year31=Code.AlternateColor(First(Fields!BackgroundAlternateColor.Value, "GetColors"),First(Fields!BackgroundColor.Value, "GetColors"),False)2pt2pt2pt2ptActual_to_Revenue_Query1.25in2.69792in1.25in2.69792in1in1in1in1in0RSDS_EnterpriseDW_SSASNone95e0f472-c858-414f-a622-ca1d5b24daa5RSDS_EnterpriseDWNone7a877ce5-e9eb-445f-985d-6c4044eb2286RSDS_EnterpriseDW_SSAS=Parameters!DateFiscalYear.Value=Parameters!OrgUnitFundCode.Value=Parameters!OrgUnitReportDistribution.Value=Parameters!OrgUnitControlOrgUnit.Value=Parameters!OrgUnitOrgUnitGrouping.Value=Parameters!UserId.Value=Parameters!OrgUnitLocationDescription.ValueSELECT
{
[Measures].[ActualToPeriodAmount]
,[Measures].[BudgetToPeriodAmount]
} ON COLUMNS
,
{
[Date].[Fiscal Year].[Fiscal Year].ALLMEMBERS*
[Date].[FiscalCalendar].[Calendar Period].ALLMEMBERS*
[Date].[Month Of Year].[Month Of Year]*
[Gl Code].[Gl Class Code].[Gl Class Code].ALLMEMBERS*
[Gl Code].[Account Sign].[Account Sign].ALLMEMBERS
} ON ROWS
FROM
(
SELECT
{[Gl Code].[Gl Class Code].&[4]:[Gl Code].[Gl Class Code].&[7]} ON COLUMNS
FROM
(
SELECT
{
STRTOMEMBER(@DateFiscalYear + ".LAG(1)")
,STRTOMEMBER(@DateFiscalYear) } ON COLUMNS
FROM [Executive_Integrated_Financials]
)
)
WHERE
(
STRTOSET(@OrgUnitLocationDescription)
,STRTOSET(@OrgUnitOrgUnitGrouping)
,STRTOSET(@OrgUnitReportDistribution)
,STRTOSET(@OrgUnitControlOrgUnit)
,STRTOSET(@OrgUnitFundCode)
, NONEMPTY
(
[Org Unit].[Org Unit SK].[Org Unit SK].Members,
(
STRTOMEMBER(@UserId)
,[Measures].[Fact Org Unit User Bridge Count]
)
)
)MDXQueryExecutive_Integrated_FinancialsSELECT
{
[Measures].[ActualToPeriodAmount]
,[Measures].[BudgetToPeriodAmount]
} ON COLUMNS
,
{
[Date].[Fiscal Year].[Fiscal Year].ALLMEMBERS*
[Date].[FiscalCalendar].[Calendar Period].ALLMEMBERS*
[Date].[Month Of Year].[Month Of Year]*
[Gl Code].[Gl Class Code].[Gl Class Code].ALLMEMBERS*
[Gl Code].[Account Sign].[Account Sign].ALLMEMBERS
} ON ROWS
FROM
(
SELECT
{[Gl Code].[Gl Class Code].&[4]:[Gl Code].[Gl Class Code].&[7]} ON COLUMNS
FROM
(
SELECT
{
STRTOMEMBER(@DateFiscalYear + ".LAG(1)")
,STRTOMEMBER(@DateFiscalYear) } ON COLUMNS
FROM [Executive_Integrated_Financials]
)
)
WHERE
(
STRTOSET(@OrgUnitLocationDescription)
,STRTOSET(@OrgUnitOrgUnitGrouping)
,STRTOSET(@OrgUnitReportDistribution)
,STRTOSET(@OrgUnitControlOrgUnit)
,STRTOSET(@OrgUnitFundCode)
, 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]trueOrgUnitControlOrgUnit[Org Unit].[Control Org Unit].[All]
OrgUnitControlOrgUnit
[Org Unit].[Control Org Unit]WITH MEMBER [Measures].[ParameterCaption] AS [Org Unit].[Control Org Unit].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Org Unit].[Control Org Unit].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Org Unit].[Control Org Unit].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Org Unit].[Control Org Unit].ALLMEMBERS ON ROWS FROM [Executive_Integrated_Financials]trueOrgUnitReportDistribution[Org Unit].[Report Distribution].[All]
Report Distribution
[Org Unit].[Report Distribution]WITH MEMBER [Measures].[ParameterCaption] AS [Org Unit].[Report Distribution].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Org Unit].[Report Distribution].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Org Unit].[Report Distribution].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Org Unit].[Report Distribution].ALLMEMBERS ON ROWS FROM [Executive_Integrated_Financials]trueOrgUnitOrgUnitGrouping[Org Unit].[Org Unit Grouping].[All]
Org Unit Grouping
[Org Unit].[Org Unit Grouping]WITH MEMBER [Measures].[ParameterCaption] AS [Org Unit].[Org Unit Grouping].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Org Unit].[Org Unit Grouping].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Org Unit].[Org Unit Grouping].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Org Unit].[Org Unit Grouping].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]OrgUnitLocationDescription[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]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="[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="Level" UniqueName="[Gl Code].[Account Sign].[Account Sign]" />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].[FiscalCalendar].[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="Level" UniqueName="[Date].[Month Of Year].[Month Of 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="Level" UniqueName="[Date].[FiscalCalendar].[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="[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="Measure" UniqueName="[Measures].[ActualToPeriodAmount]" />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].[BudgetToPeriodAmount]" />System.Int32=IIf(Fields!Gl_Class_Code.Value = "4", Fields!BudgetToPeriodAmount.Value * Fields!Account_Sign.Value, 0)=IIf(Fields!Gl_Class_Code.Value >= "5" and Fields!Gl_Class_Code.Value <= "7" , Fields!BudgetToPeriodAmount.Value * Fields!Account_Sign.Value, 0)=IIf(Fields!Gl_Class_Code.Value = "4", Fields!ActualToPeriodAmount.Value * Fields!Account_Sign.Value, 0)=IIf(Fields!Gl_Class_Code.Value >= "5" and Fields!Gl_Class_Code.Value <= "7" , Fields!ActualToPeriodAmount.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.StringString[Date].[Fiscal Year].&[FY 2013]Date.Fiscal YearString[Org Unit].[Fund Code].[All]Fund CodetrueString[Org Unit].[Report Distribution].[All]Report DistributiontrueString[Org Unit].[Org Unit Grouping].[All]Org Unit GroupingtrueString="[User].[Domain User Id].&["+User!UserID+"]"trueString[Org Unit].[Control Org Unit].[All]OrgUnitControlOrgUnittrueString[Org Unit].[Location Description].[All]OrgUnitLocationDescriptiontruePrivate 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