Tuition_and_Fees_by_Month_Query2.93627in6.28125inWhiteNone2.93627in6.28125in1in1in1in1in0RSDS_EnterpriseDW_SSASNone95e0f472-c858-414f-a622-ca1d5b24daa5RSDS_EnterpriseDW_SSAS=Parameters!DateFiscalYear.Value=Parameters!DateCalendarPeriodFilter.ValueSELECT
NON EMPTY
{
[Measures].[Journal Amount]
} ON COLUMNS
,
NON EMPTY
{
[Date].[Fiscal Year].[Fiscal Year].ALLMEMBERS
*
[Gl Code].[Account Sign].[Account Sign].ALLMEMBERS
*
[Date].[Calendar Period].[Calendar Period].ALLMEMBERS
*
[Date].[Month Of Year].[Month Of Year].ALLMEMBERS
}
ON ROWS
FROM
(
SELECT
{
STRTOMEMBER(@DateFiscalYear + ".LAG(1)")
,STRTOMEMBER(@DateFiscalYear)
} ON COLUMNS
FROM [Student_Financials]
)
WHERE
(
[Gl Code].[Gl Category Code].&[40]
, {[Gl Trans Detail].[Journal Grouping].&[Actuals]}
,STRTOMEMBER("[Date].[FiscalCalendar].[Calendar Period].&[" +
VBA!Right(@DateCalendarPeriodFilter,7) +
".FirstSibling" + ".LAG(12)")
:
STRTOMEMBER("[Date].[FiscalCalendar].[Calendar Period].&[" +
VBA!Right(@DateCalendarPeriodFilter,7))
)MDXQueryStudent_FinancialsSELECT
NON EMPTY
{
[Measures].[Journal Amount]
} ON COLUMNS
,
NON EMPTY
{
[Date].[Fiscal Year].[Fiscal Year].ALLMEMBERS
*
[Gl Code].[Account Sign].[Account Sign].ALLMEMBERS
*
[Date].[Calendar Period].[Calendar Period].ALLMEMBERS
*
[Date].[Month Of Year].[Month Of Year].ALLMEMBERS
}
ON ROWS
FROM
(
SELECT
{
STRTOMEMBER(@DateFiscalYear + ".LAG(1)")
,STRTOMEMBER(@DateFiscalYear)
} ON COLUMNS
FROM [Student_Financials]
)
WHERE
(
[Gl Code].[Gl Category Code].&[40]
, {[Gl Trans Detail].[Journal Grouping].&[Actuals]}
,STRTOMEMBER("[Date].[FiscalCalendar].[Calendar Period].&[" +
VBA!Right(@DateCalendarPeriodFilter,7) +
".FirstSibling" + ".LAG(12)")
:
STRTOMEMBER("[Date].[FiscalCalendar].[Calendar Period].&[" +
VBA!Right(@DateCalendarPeriodFilter,7))
)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 [Student_Financials]DateCalendarPeriodFilter[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 [Student_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 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].[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="[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="Measure" UniqueName="[Measures].[Journal Amount]" />System.Int32=Fields!Journal_Amount.Value * Fields!Account_Sign.ValueRSDS_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_EnterpriseDW_SSAS=Parameters!DateFiscalYear.ValueWITH
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 [Student_Financials]
)MDXQueryStudent_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 [Student_Financials]
)DateFiscalYear[Date].[Fiscal Year].&[FY 2014]
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 [Student_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.Int32String[Date].[Fiscal Year].&[FY 2014]Date.Fiscal YearStringDateCalendarPeriodFilterParameterValueDate.Calendar PeriodInchba2cb72b-2313-457d-8a5d-af4cb89bf676