WITH
MEMBER [Measures].[Travel Expense as % of Salary] ASiif( [Measures].[Salary] = 0, null, [Measures].[Total Travel Expenses]/ [Measures].[Salary]),
Format_string = 'percent'
MEMBER [Measures].[Average FTE] AS --same as data source view calculation[Measures].[Hours]/[Measures].[Monthly Hr Rate]
MEMBER [Measures].[Average Cost Per FTE] AS[Measures].[Total Expenses]/[Measures].[Avg FTE]
SELECT NON EMPTY { [Measures].[Add Exp], [Measures].[Training Instructor Count], [Measures].[Salary], [Measures].[Total Expenses], [Measures].[Total Travel Expenses], [Measures].[Expenses], [Measures].[Hours], [Measures].[Monthly Hr Rate], [Measures].[Travel Expense as % of Salary],[Measures].[Average FTE],
[Measures].[Average Cost Per FTE]
}
ON COLUMNS, [Cost Center].[RC Charge Code].[RC Charge Code].
ALLMEMBERShaving [Measures].[Hours] <> 0 ON ROWS From[CRAnalytics]
No comments:
Post a Comment