Hi

Yes, ID-1411 is not a field from fact table, its a string, I trying to get output with along with string and also the date condtion is on FactTable DateTime Column Field not an Date Table Field, my apologies for earlier mis interpretation.

Correct Query

SELECT 
'[ID- 1411]+ ',' + cast(Count(Number of Items))+ ',' +  date.[Date Field] + ':'+ Tim[Half Hour Time Field] as ID
from [dbo].FCTtable i
inner join dbo.dimdate dates on dates.DayDateKEY = i.[DayDateKEY]
inner join dbo.DIMtime tim on tim.DIMtimeKEY = i.[DIMtimeKEY]
INNER JOIN dbo.DIMcountry contr ON contr.DIMcountryKEY = i.DIMCountryEY
where i.FactTableDateTimeColumn > '20160224070600' -- YYYYMMDDHHMMSS
and contr.country = 'US'
group by [DateField],[Half hour Time Field]