0 RSDS_EnterpriseDW_SSAS None 95e0f472-c858-414f-a622-ca1d5b24daa5 RSDS_EnterpriseDW None 15b2838c-c39e-4a02-b89f-9477a85ccc09 RSDS_EnterpriseDW_SSAS =Parameters!DateFiscalYear.Value =Parameters!OrgUnitFundCode.Value =Parameters!OrgUnitFunction.Value =Parameters!OrgUnitLocation.Value =Parameters!UserId.Value Select NON EMPTY { [Measures].[Actuals Amount] ,[Measures].[Budget Amount] }on Columns, NON EMPTY { [Gl Code].[Gl Category].[Gl Category].ALLMEMBERS* [Gl Code].[Hr Time Status].[Hr Time Status].ALLMEMBERS } on rows FROM [Executive_Integrated_Financials] WHERE ( STRTOSET(@OrgUnitLocation) ,STRTOSET(@OrgUnitFundCode) ,STRTOSET(@DateFiscalYear) ,STRTOSET(@OrgUnitFunction) ,[Gl Code].[Gl Class Code].&[5] , {[Gl Trans Detail].[Journal Grouping].&[Actuals],[Gl Trans Detail].[Journal Grouping].&[Budget]} ,[Gl Code].[Hr Classification].&[Salary] , NONEMPTY ( [Org Unit].[Org Unit SK].[Org Unit SK].Members, ( STRTOMEMBER(@UserId) ,[Measures].[Fact Org Unit User Bridge Count] ) ) ) MDXQueryGl CodeGl Category[Gl Code].[Gl Category]Gl Category[Gl Code].[Gl Category].[Gl Category]Gl CategoryGl CodeHr Time Status[Gl Code].[Hr Time Status]Hr Time Status[Gl Code].[Hr Time Status].[Hr Time Status]Hr Time StatusActuals Amount[Measures].[Actuals Amount]Actuals AmounttrueBudget Amount[Measures].[Budget Amount]Budget AmounttrueExecutive_Integrated_FinancialsSelect NON EMPTY { [Measures].[Actuals Amount] ,[Measures].[Budget Amount] }on Columns, NON EMPTY { [Gl Code].[Gl Category].[Gl Category].ALLMEMBERS* [Gl Code].[Hr Time Status].[Hr Time Status].ALLMEMBERS } on rows FROM [Executive_Integrated_Financials] WHERE ( STRTOSET(@OrgUnitLocation) ,STRTOSET(@OrgUnitFundCode) ,STRTOSET(@DateFiscalYear) ,STRTOSET(@OrgUnitFunction) ,[Gl Code].[Gl Class Code].&[5] , {[Gl Trans Detail].[Journal Grouping].&[Actuals],[Gl Trans Detail].[Journal Grouping].&[Budget]} ,[Gl Code].[Hr Classification].&[Salary] , 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]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]OrgUnitFunction[Org Unit].[Function Description].[All]OrgUnitFunction[Org Unit].[Function Description]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]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].[Gl Category].[Gl Category]" /> 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].[Hr Time Status].[Hr Time Status]" /> 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].[Actuals 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="Measure" UniqueName="[Measures].[Budget Amount]" /> System.Int32 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 SELECT BackgroundColor, BackgroundAlternateColor, Band1Color, Band2Color, Band3Color, Band4Color, Band5Color, Band6Color FROM Configuration_Color WHERE (ReportType = 'GeneralLedger') BackgroundColor System.String BackgroundAlternateColor System.String Band1Color System.String Band2Color System.String Band3Color System.String Band4Color System.String Band5Color System.String Band6Color System.String true true =First(Fields!Band1Color.Value, "GetColors") 2pt 2pt 2pt 2pt 2 1.22917in 1.17708in 0.83333in 0.25in true true =Sum(Fields!Budget_Amount.Value) =First(Fields!BackgroundAlternateColor.Value, "GetColors") 2pt 2pt 2pt 2pt true true =Sum(Fields!Actuals_Amount.Value) =First(Fields!BackgroundAlternateColor.Value, "GetColors") 2pt 2pt 2pt 2pt true true =Iif(IsNothing(Sum(Fields!Budget_Amount.Value)) or Sum(Fields!Budget_Amount.Value) = "0","",Sum(Fields!Actuals_Amount.Value) / Sum(Fields!Budget_Amount.Value)) =First(Fields!BackgroundAlternateColor.Value, "GetColors") 2pt 2pt 2pt 2pt 0.25in true true =Sum(Fields!Budget_Amount.Value) 2pt 2pt 2pt 2pt true true =Sum(Fields!Actuals_Amount.Value) 2pt 2pt 2pt 2pt true true =Iif(IsNothing(Sum(Fields!Budget_Amount.Value)) or Sum(Fields!Budget_Amount.Value) = "0","",Sum(Fields!Actuals_Amount.Value) / Sum(Fields!Budget_Amount.Value)) 2pt 2pt 2pt 2pt 0.25in true true Budget Textbox37 =First(Fields!Band1Color.Value, "GetColors") 2pt 2pt 2pt 2pt 0.25in true true YTD Spent Textbox2 =First(Fields!Band1Color.Value, "GetColors") 2pt 2pt 2pt 2pt 0.25in true true Percentage Textbox7 =First(Fields!Band1Color.Value, "GetColors") 2pt 2pt 2pt 2pt =Fields!Hr_Time_Status.Value =Fields!Hr_Time_Status.Value 2.08333in true true =Fields!Hr_Time_Status.Value 2pt 2pt 2pt 2pt =Fields!Gl_Category.Value =Fields!Gl_Category.Value 2.29167in true true =Fields!Gl_Category.Value =First(Fields!BackgroundAlternateColor.Value, "GetColors") 2pt 2pt 2pt 2pt true Hr_Time_Status 2.29167in true true 2pt 2pt 2pt 2pt Before PercentageSpendingCurrentFY_Query 0.75in 7.61458in 0.80084in