I have got the book Ralph Kimball Margy Ross The Data Warehouse Toolkit 3rd Edition but cannot see anything on any of the chapters about this scenario.

I am producing a...

• This reply was modified 1 year, 10 months ago by  SQL_Kills.

I have included the dates to the join but it is now not showing EmpId 129 (Rafael Nadal)

DROP TABLE #tmp;

WITH EmployeeList AS (
SELECT [EmpId]
   ...

• This reply was modified 2 years, 4 months ago by  SQL_Kills.

Sorry I forgot to include the the Table and Inserts and SQL I currently have, here it is below:

CREATE TABLE [dbo].[EmployeeList](
[EmpId] [int] NOT NULL,
[ManagerId] [int] NULL,
[Name] [varchar](100)...

.

• This reply was modified 4 years, 4 months ago by  SQL_Kills.
• This reply was modified 4 years, 4 months ago by  SQL_Kills.

This was the query I made if that is what you meant.

case when (DATEDIFF(MONTH,0,c.DateKey)/3 - DATEDIFF(MONTH,0,@TodaysDate)/3 = DATEPART(QUARTER,@TodaysDate)) THEN 1 ELSE 0 END

Hi Nigel, No it does not work either

Actually I think I've got it now, I have done the following

case when DATEPART(QUARTER,c.DateKey)+1 = DATEPART(QUARTER,@TodaysDate) AND YEAR(c.DateKey) = YEAR(@TodaysDate) THEN 1 ELSE 0 END

Thanks Nigel, This seems to work. What would need to be done for Previous Qtr, so the dates between 01/01/2019 to 31/03/2019 they would be set to 1 for this...

Thanks for the reply, so when I deploy to the server and then go back to the Analysis Services section on Azure, I can now see under "Models on Analysis...

Yes the first "Analysis Services Process Task" Processes the Dimensions, after that task has completed the second

Thanks Chris for your reply, it looks like it has done the job! But I did notice that when I inserted another row into the table hrd_audit

insert into hrd_Audit values...