YTD_Compensation_Query3.0925in4.625inWhiteNone3.0925in4.625in1in1in1in1in0RSDS_EnterpriseDW_SSASNone95e0f472-c858-414f-a622-ca1d5b24daa5RSDS_EnterpriseDW_SSAS=Parameters!DateFiscalYear.Value=Parameters!OrgUnitFundCode.Value=Parameters!OrgUnitLocation.Value=Parameters!UserId.Value=Parameters!OrgUnitFunction.ValueSelect
NON EMPTY
( [Measures].[Journal Amount]
) on Columns,
NON EMPTY
{
[Gl Code].[Hr Classification].[Hr Classification].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]
, NONEMPTY
(
[Org Unit].[Org Unit SK].[Org Unit SK].Members,
(
STRTOMEMBER(@UserId)
,[Measures].[Fact Org Unit User Bridge Count]
)
)
)MDXQueryExecutive_Integrated_FinancialsSelect
NON EMPTY
( [Measures].[Journal Amount]
) on Columns,
NON EMPTY
{
[Gl Code].[Hr Classification].[Hr Classification].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]
, 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].[Hr Classification].[Hr Classification]" />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.Int32RSDS_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.StringString[Date].[Fiscal Year].&[FY 2013]Date.Fiscal YearString[Org Unit].[Fund Code].[All]Fund CodetrueString[Org Unit].[Location Description].[All]LocationtrueString="[User].[Domain User Id].&["+User!UserID+"]"trueString[Org Unit].[Function Description].[All]OrgUnitFunctiontrueInchba2cb72b-2313-457d-8a5d-af4cb89bf676