0 RSDS_EnterpriseDW_SSAS None 95e0f472-c858-414f-a622-ca1d5b24daa5 RSDS_EnterpriseDW_SSAS =Parameters!DateFiscalYear.Value =Parameters!DateCalendarPeriodFilter.Value =Parameters!OrgUnitFundCode.Value =Parameters!OrgUnitControlOrgUnit.Value =Parameters!OrgUnitReportDistribution.Value =Parameters!OrgUnitOrgUnitGrouping.Value =Parameters!OrgUnitLocation.Value =Parameters!UserId.Value SELECT NON EMPTY { [Measures].[TotalRevenueToPeriodNoBudget] , [Measures].[TotalExpensesToPeriodNoBudget] , [Measures].[BudgetToPeriodAmount] } on Columns, { [Date].[Fiscal Year].[Fiscal Year].ALLMEMBERS* [Gl Code].[Gl Group].[Gl Group].ALLMEMBERS* [Date].[Calendar Period].[Calendar Period].ALLMEMBERS* ([Gl Trans Detail].[Journal Grouping].Children - [Gl Trans Detail].[Journal Grouping].&[N/A]) } on rows FROM ( SELECT { STRTOMEMBER(@DateFiscalYear + ".LAG(2)") ,STRTOMEMBER(@DateFiscalYear + ".LAG(1)") ,STRTOMEMBER(@DateFiscalYear) } ON COLUMNS FROM [Executive_Integrated_Financials] ) WHERE ( STRTOSET(@OrgUnitLocation) ,STRTOSET(@OrgUnitOrgUnitGrouping) ,STRTOSET(@OrgUnitReportDistribution) ,STRTOSET(@OrgUnitControlOrgUnit) ,STRTOSET(@OrgUnitFundCode) ,{[Gl Code].[Gl Class Code].&[4] : [Gl Code].[Gl Class Code].&[7]} ,{STRTOMEMBER("[Date].[FiscalCalendar].[Calendar Period].&[" + VBA!Right(@DateCalendarPeriodFilter,7)) , STRTOMEMBER("[Date].[FiscalCalendar].[Calendar Period].&[" + VBA!Right(@DateCalendarPeriodFilter,7) + ".LAG(12)") , STRTOMEMBER("[Date].[FiscalCalendar].[Calendar Period].&[" + VBA!Right(@DateCalendarPeriodFilter,7) + ".LAG(24)")} , NONEMPTY ( [Org Unit].[Org Unit SK].[Org Unit SK].Members, ( STRTOMEMBER(@UserId) ,[Measures].[Fact Org Unit User Bridge Count] ) ) ) MDXQueryDateFiscal Year[Date].[Fiscal Year]Fiscal Year[Date].[Fiscal Year].[Fiscal Year]Fiscal YearGl CodeGl Group[Gl Code].[Gl Group]Gl Group[Gl Code].[Gl Group].[Gl Group]Gl GroupDateCalendar Period[Date].[Calendar Period]Calendar Period[Date].[Calendar Period].[Calendar Period]Calendar PeriodGl Trans DetailJournal Grouping[Gl Trans Detail].[Journal Grouping]Journal Grouping[Gl Trans Detail].[Journal Grouping].[Journal Grouping]Journal GroupingTotalRevenueToPeriodNoBudget[Measures].[TotalRevenueToPeriodNoBudget]TotalRevenueToPeriodNoBudgettrueTotalExpensesToPeriodNoBudget[Measures].[TotalExpensesToPeriodNoBudget]TotalExpensesToPeriodNoBudgettrueBudgetToPeriodAmount[Measures].[BudgetToPeriodAmount]BudgetToPeriodAmounttrueExecutive_Integrated_FinancialsSELECT NON EMPTY { [Measures].[TotalRevenueToPeriodNoBudget] , [Measures].[TotalExpensesToPeriodNoBudget] , [Measures].[BudgetToPeriodAmount] } on Columns, { [Date].[Fiscal Year].[Fiscal Year].ALLMEMBERS* [Gl Code].[Gl Group].[Gl Group].ALLMEMBERS* [Date].[Calendar Period].[Calendar Period].ALLMEMBERS* ([Gl Trans Detail].[Journal Grouping].Children - [Gl Trans Detail].[Journal Grouping].&[N/A]) } on rows FROM ( SELECT { STRTOMEMBER(@DateFiscalYear + ".LAG(2)") ,STRTOMEMBER(@DateFiscalYear + ".LAG(1)") ,STRTOMEMBER(@DateFiscalYear) } ON COLUMNS FROM [Executive_Integrated_Financials] ) WHERE ( STRTOSET(@OrgUnitLocation) ,STRTOSET(@OrgUnitOrgUnitGrouping) ,STRTOSET(@OrgUnitReportDistribution) ,STRTOSET(@OrgUnitControlOrgUnit) ,STRTOSET(@OrgUnitFundCode) ,{[Gl Code].[Gl Class Code].&[4] : [Gl Code].[Gl Class Code].&[7]} ,{STRTOMEMBER("[Date].[FiscalCalendar].[Calendar Period].&[" + VBA!Right(@DateCalendarPeriodFilter,7)) , STRTOMEMBER("[Date].[FiscalCalendar].[Calendar Period].&[" + VBA!Right(@DateCalendarPeriodFilter,7) + ".LAG(12)") , STRTOMEMBER("[Date].[FiscalCalendar].[Calendar Period].&[" + VBA!Right(@DateCalendarPeriodFilter,7) + ".LAG(24)")} , 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]trueDateCalendarPeriodFilter[Date].[Calendar Period Filter].&[201211]DateCalendarPeriodFilter[Date].[Calendar Period Filter]WITH MEMBER [Measures].[ParameterCaption] AS [Date].[Calendar Period Filter].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Date].[Calendar Period Filter].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Date].[Calendar Period Filter].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Date].[Calendar Period Filter].ALLMEMBERS ON ROWS FROM [Executive_Integrated_Financials]OrgUnitFundCode[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]Control Org Unit[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]trueOrgUnitLocation[Org Unit].[Location Description].[All]Location[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]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="[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 Trans Detail].[Journal Grouping].[Journal Grouping]" /> 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].[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="[Gl Code].[Gl Group].[Gl 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].[TotalRevenueToPeriodNoBudget]" /> 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].[TotalExpensesToPeriodNoBudget]" /> 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 =Fields!TotalRevenueToPeriodNoBudget.Value * -1 =Fields!TotalExpensesToPeriodNoBudget.Value =Iif(Fields!Gl_Group.Value = "Revenue", Fields!BudgetToPeriodAmount.Value * -1, Fields!BudgetToPeriodAmount.Value) RSDS_EnterpriseDW_SSAS 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] MDX Query ParameterCaption [Measures].[ParameterCaption] ParameterCaption true ParameterValue [Measures].[ParameterValue] ParameterValue true ParameterLevel [Measures].[ParameterLevel] ParameterLevel true Executive_Integrated_Financials 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] true 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="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.Value System.String RSDS_EnterpriseDW_SSAS =Parameters!DateFiscalYear.Value WITH MEMBER [Measures].[ParameterCaption] AS [Date].[Calendar Period Filter].CurrentMember.Member_Caption MEMBER [Measures].[ParameterValue] AS [Date].[Calendar Period Filter].CurrentMember.UniqueName MEMBER [Measures].[ParameterLevel] AS [Date].[Calendar Period Filter].CurrentMember.Level.Ordinal SELECT { [Measures].[ParameterCaption] ,[Measures].[ParameterValue] ,[Measures].[ParameterLevel] } ON COLUMNS ,[Date].[Calendar Period Filter].Children ON ROWS FROM ( SELECT StrToSet (@DateFiscalYear ,CONSTRAINED ) ON COLUMNS FROM [Executive_Integrated_Financials] ) MDXQueryDateCalendar Period Filter[Date].[Calendar Period Filter]Calendar Period Filter[Date].[Calendar Period Filter].[Calendar Period Filter]Calendar Period FilterParameterCaption[Measures].[ParameterCaption]ParameterCaptiontrueParameterValue[Measures].[ParameterValue]ParameterValuetrueParameterLevel[Measures].[ParameterLevel]ParameterLeveltrueExecutive_Integrated_FinancialsWITH MEMBER [Measures].[ParameterCaption] AS [Date].[Calendar Period Filter].CurrentMember.Member_Caption MEMBER [Measures].[ParameterValue] AS [Date].[Calendar Period Filter].CurrentMember.UniqueName MEMBER [Measures].[ParameterLevel] AS [Date].[Calendar Period Filter].CurrentMember.Level.Ordinal SELECT { [Measures].[ParameterCaption] ,[Measures].[ParameterValue] ,[Measures].[ParameterLevel] } ON COLUMNS ,[Date].[Calendar Period Filter].Children ON ROWS FROM ( SELECT StrToSet (@DateFiscalYear ,CONSTRAINED ) ON COLUMNS FROM [Executive_Integrated_Financials] ) DateFiscalYear[Date].[Fiscal Year].[All]DateFiscalYear[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] <?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 Filter].[Calendar Period Filter]" /> 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 =Fields!Fiscal_Year.Value =Fields!Fiscal_Year.Value =Fields!Gl_Group.Value =Fields!Gl_Group.Value =Fields!Gl_Group.Value =Fields!Fiscal_Year.Value =Fields!Journal_Grouping.Value =Fields!Journal_Grouping.Value Revenue Expense Budget =Fields!Journal_Grouping.Value =Sum(Fields!Revenue.Value) False 0.5 NaN NaN NaN Axis Title False 0.5 NaN Opposite NaN NaN 0.5 NaN 0 NaN Axis Title 0.5 NaN Opposite NaN NaN BottomCenter Black Black Pastel No Data Available BudgetRevenueExpenses_Query 4.44667in 6.95833in White None 4.4675in