YTD_Expenses_Query3.48834in3.25inWhiteNone3.48834in3.26042in1in1in1in1in0RSDS_EnterpriseDW_SSASNone95e0f472-c858-414f-a622-ca1d5b24daa5RSDS_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].[Journal Amount]} ON COLUMNS
,NON EMPTY
{
[Gl Code].[Gl Class].[Gl Class].ALLMEMBERS
*
[Gl Code].[Account Sign].[Account Sign].ALLMEMBERS
*
[Date].[Calendar Period].[Calendar Period]
}
DIMENSION PROPERTIES
MEMBER_CAPTION
,MEMBER_UNIQUE_NAME
ON ROWS
FROM [Executive_Integrated_Financials]
WHERE
(
STRTOSET(@OrgUnitLocation)
,STRTOSET(@OrgUnitOrgUnitGrouping)
,STRTOSET(@OrgUnitReportDistribution)
,STRTOSET(@OrgUnitControlOrgUnit)
,STRTOSET(@OrgUnitFundCode)
,STRTOSET(@DateFiscalYear + ".LAG(1)")
,{[Gl Code].[Gl Class Code].&[5] : [Gl Code].[Gl Class Code].&[7]}
, {[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) + ".LAG(12)")
, NONEMPTY
(
[Org Unit].[Org Unit SK].[Org Unit SK].Members,
(
STRTOMEMBER(@UserId)
,[Measures].[Fact Org Unit User Bridge Count]
)
)
)MDXQueryExecutive_Integrated_Financials SELECT
NON EMPTY
{[Measures].[Journal Amount]} ON COLUMNS
,NON EMPTY
{
[Gl Code].[Gl Class].[Gl Class].ALLMEMBERS
*
[Gl Code].[Account Sign].[Account Sign].ALLMEMBERS
*
[Date].[Calendar Period].[Calendar Period]
}
DIMENSION PROPERTIES
MEMBER_CAPTION
,MEMBER_UNIQUE_NAME
ON ROWS
FROM [Executive_Integrated_Financials]
WHERE
(
STRTOSET(@OrgUnitLocation)
,STRTOSET(@OrgUnitOrgUnitGrouping)
,STRTOSET(@OrgUnitReportDistribution)
,STRTOSET(@OrgUnitControlOrgUnit)
,STRTOSET(@OrgUnitFundCode)
,STRTOSET(@DateFiscalYear + ".LAG(1)")
,{[Gl Code].[Gl Class Code].&[5] : [Gl Code].[Gl Class Code].&[7]}
, {[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) + ".LAG(12)")
, 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="[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="[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="Measure" UniqueName="[Measures].[Journal 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="Level" UniqueName="[Date].[Calendar Period].[Calendar Period]" />System.StringRSDS_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 [Executive_Integrated_Financials]
)MDXQueryExecutive_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.Int32String[Date].[Fiscal Year].&[FY 2013]Date.Fiscal YearStringDateCalendarPeriodFilterParameterValueDate.Calendar PeriodString[Org Unit].[Fund Code].[All]Fund CodetrueString[Org Unit].[Control Org Unit].[All]Control Org UnittrueString[Org Unit].[Report Distribution].[All]Report DistributiontrueString[Org Unit].[Org Unit Grouping].[All]Org Unit GroupingtrueString[Org Unit].[Location Description].[All]LocationtrueString="[User].[Domain User Id].&["+User!UserID+"]"trueInchba2cb72b-2313-457d-8a5d-af4cb89bf676