0 RSDS_EnterpriseDW_SSAS None 95e0f472-c858-414f-a622-ca1d5b24daa5 RSDS_EnterpriseDW_SSAS =Parameters!DateFiscalYear.Value =Parameters!OrgUnitFundCode.Value =Parameters!OrgUnitControlOrgUnit.Value =Parameters!OrgUnitReportDistribution.Value =Parameters!OrgUnitOrgUnitGrouping.Value =Parameters!OrgUnitLocation.Value =Parameters!UserId.Value SELECT { [Measures].[BudgetToPeriodAmount] ,[Measures].[ActualToPeriodAmount] } on Columns, { [Gl Code].[Gl Class].[Gl Class].ALLMEMBERS* [Date].[Fiscal Year].[Fiscal Year].ALLMEMBERS* [Date].[FiscalCalendar].[Calendar Period].ALLMEMBERS* [Date].[Month Of Year].[Month Of Year]* [Gl Code].[Gl Class Code].Children* [Date].[Fiscal Period Of Year].Children } 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 [Executive_Integrated_Financials] ) ) WHERE ( STRTOSET(@OrgUnitLocation) ,STRTOSET(@OrgUnitOrgUnitGrouping) ,STRTOSET(@OrgUnitReportDistribution) ,STRTOSET(@OrgUnitControlOrgUnit) ,STRTOSET(@OrgUnitFundCode) ,{[Gl Trans Detail].[Journal Grouping].&[Actuals],[Gl Trans Detail].[Journal Grouping].&[Budget]} , NONEMPTY ( [Org Unit].[Org Unit SK].[Org Unit SK].Members, ( STRTOMEMBER(@UserId) ,[Measures].[Fact Org Unit User Bridge Count] ) ) ) MDXQueryGl CodeGl Class[Gl Code].[Gl Class]Gl Class[Gl Code].[Gl Class].[Gl Class]Gl ClassDateFiscal Year[Date].[Fiscal Year]Fiscal Year[Date].[Fiscal Year].[Fiscal Year]Fiscal YearDateFiscalCalendar[Date].[FiscalCalendar]Fiscal Year[Date].[FiscalCalendar].[Fiscal Year]Fiscal YearDateFiscalCalendar[Date].[FiscalCalendar]Calendar Period[Date].[FiscalCalendar].[Calendar Period]Calendar PeriodDateMonth Of Year[Date].[Month Of Year]Month Of Year[Date].[Month Of Year].[Month Of Year]Month Of YearGl CodeGl Class Code[Gl Code].[Gl Class Code]Gl Class Code[Gl Code].[Gl Class Code].[Gl Class Code]Gl Class CodeDateFiscal Period Of Year[Date].[Fiscal Period Of Year]Fiscal Period Of Year[Date].[Fiscal Period Of Year].[Fiscal Period Of Year]Fiscal Period Of YearBudgetToPeriodAmount[Measures].[BudgetToPeriodAmount]BudgetToPeriodAmounttrueActualToPeriodAmount[Measures].[ActualToPeriodAmount]ActualToPeriodAmounttrueExecutive_Integrated_FinancialsSELECT { [Measures].[BudgetToPeriodAmount] ,[Measures].[ActualToPeriodAmount] } on Columns, { [Gl Code].[Gl Class].[Gl Class].ALLMEMBERS* [Date].[Fiscal Year].[Fiscal Year].ALLMEMBERS* [Date].[FiscalCalendar].[Calendar Period].ALLMEMBERS* [Date].[Month Of Year].[Month Of Year]* [Gl Code].[Gl Class Code].Children* [Date].[Fiscal Period Of Year].Children } 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 [Executive_Integrated_Financials] ) ) WHERE ( STRTOSET(@OrgUnitLocation) ,STRTOSET(@OrgUnitOrgUnitGrouping) ,STRTOSET(@OrgUnitReportDistribution) ,STRTOSET(@OrgUnitControlOrgUnit) ,STRTOSET(@OrgUnitFundCode) ,{[Gl Trans Detail].[Journal Grouping].&[Actuals],[Gl Trans Detail].[Journal Grouping].&[Budget]} , 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]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="[Gl Code].[Gl Class].[Gl Class]" /> 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="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="[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="[Date].[Fiscal Period Of Year].[Fiscal Period 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="Measure" UniqueName="[Measures].[BudgetToPeriodAmount]" /> 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].[ActualToPeriodAmount]" /> System.Int32 =(Fields!ActualToPeriodAmount.Value / Fields!BudgetToPeriodAmount.Value) * 100 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 =Fields!Calendar_Period.Value =Fields!Calendar_Period.Value =Fields!Calendar_Period.Value =Fields!Gl_Class.Value =Fields!Gl_Class.Value =Fields!Gl_Class.Value =Sum(Fields!PercentageActualOverBudget.Value) False Auto 0.5 NaN NaN NaN Axis Title False 0.5 NaN Opposite NaN NaN % Actuals vs. Budget 0.5 NaN NaN NaN Axis Title 0.5 NaN Opposite NaN NaN BottomCenter Black Black Pastel No Data Available SpendingVelocity_Query 2.63417in 7.47918in White None 2.655in