YTD_Salary_Category_Query0.02083in0.01042in2.50918in4.63541inWhiteNone2.56126in4.65625in1in1in1in1in0RSDS_EnterpriseDW_SSASNone95e0f472-c858-414f-a622-ca1d5b24daa5RSDS_EnterpriseDW_SSAS=Parameters!DateFiscalYear.Value=Parameters!OrgUnitFundCode.Value=Parameters!GlCodeGlCategory.Value=Parameters!OrgUnitLocation.Value=Parameters!UserId.Value=Parameters!GlCodeHrTimeStatus.Value=Parameters!OrgUnitFunction.ValueSelect
NON EMPTY
{ [Measures].[Journal Amount]
}on Columns,
NON EMPTY
{
[Gl Code].[Gl Category].[Gl Category].ALLMEMBERS
}
on rows
FROM [Executive_Integrated_Financials]
WHERE
(
STRTOSET(@OrgUnitLocation)
,STRTOSET(@OrgUnitFundCode)
,STRTOSET(@DateFiscalYear)
,STRTOSET(@OrgUnitFunction)
,STRTOSET(@GlCodeHrTimeStatus)
,[Gl Code].[Gl Class Code].&[5]
,[Gl Trans Detail].[Journal Grouping].&[Actuals]
,[Gl Code].[Hr Classification].&[Salary]
, 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].[Gl Category].[Gl Category].ALLMEMBERS
}
on rows
FROM [Executive_Integrated_Financials]
WHERE
(
STRTOSET(@OrgUnitLocation)
,STRTOSET(@OrgUnitFundCode)
,STRTOSET(@DateFiscalYear)
,STRTOSET(@OrgUnitFunction)
,STRTOSET(@GlCodeHrTimeStatus)
,[Gl Code].[Gl Class Code].&[5]
,[Gl Trans Detail].[Journal Grouping].&[Actuals]
,[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]GlCodeGlCategory[Gl Code].[Gl Category].[All]
GlCodeGlCategory
[Gl Code].[Gl Category]WITH MEMBER [Measures].[ParameterCaption] AS [Gl Code].[Gl Category].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Gl Code].[Gl Category].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Gl Code].[Gl Category].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Gl Code].[Gl Category].ALLMEMBERS ON ROWS FROM [Executive_Integrated_Financials]trueGlCodeHrTimeStatus[Gl Code].[Hr Time Status].[All]
GlCodeHrTimeStatus
[Gl Code].[Hr Time Status]WITH MEMBER [Measures].[ParameterCaption] AS [Gl Code].[Hr Time Status].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Gl Code].[Hr Time Status].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Gl Code].[Hr Time Status].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Gl Code].[Hr Time Status].ALLMEMBERS ON ROWS FROM [Executive_Integrated_Financials]trueOrgUnitFunction[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="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[Gl Code].[Gl Category].[All]GlCodeGlCategorytrueString[Gl Code].[Hr Time Status].[All]GlCodeHrTimeStatustrueString[Org Unit].[Function Description].[All]OrgUnitFunctiontrueInchba2cb72b-2313-457d-8a5d-af4cb89bf676