ConCat DateTime

select FullDateAlternateKey,

str(YEAR(FullDateAlternateKey))+
RIGHT('00' + (CAST(datepart(mm, FullDateAlternateKey)AS NVARCHAR(2))), 2)+
RIGHT('00' + (CAST(datepart(dd, FullDateAlternateKey)AS NVARCHAR(2))), 2)from DateWorkingDimension

Filtering Rows not equal zero

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]

Select Weekend

SELECT FULLDT FROM FACTHOURS
WHERE DATENAME(dw, FULLDT) in ('Saturday', 'Sunday')