Hi Chris,

Thank you so much, seems to be doing the job however, the will be a broader dataset and more months. I would these records to the sample dataset

('2012-12-03','DM1','Monday',441),

('2012-12-03','DM3','Monday',10),

('2012-12-10','DM4','Monday',25),

('2013-12-02','DM1','Monday',1521),...

Hi Chris,

Thank you. If I understood correctly, the piece of code will generate all the dates, 2 years back from today, with the day name and the week they fall...

I am not able to make it work. This is the code to create a sample data and attached is the result I want to achieve. Please help me write...

Thank you for your reply. I was thinking of adding a calculated column with DayName-DayInWeek-Month (e.g.Monday-1-11), then I can group all the first Monday of November for any year at...

Thanks, I will give that a go!

Thank you very much, this was helpful! Now, if I want to get this calculation to work for eveything other than 'UK' campaigns (France, US, Denmark, etc), how do I...

SSC Eights,

Thank you very much for your help, much appreciated. Your solution works even for overlapping dates, great!

Jaysen

Well spotted, mistake from my part whilst entering sample data in the table, the sample data is as below

/*Insert sample data*/

INSERT INTO delete_temp

VALUES (1,'LTB',34,'1997-04-17','2008-05-14',0),

(2,'LTB',34,'2008-05-15','2008-09-29',0),

(3,'LTB',34,'2008-09-30','2008-10-02',196),

(4,'LTB',34,'2008-10-03','2008-10-06',6),

(5,'LTB',34,'2008-10-07','2008-10-13',41),

(34,'LTB',34,'2009-06-12','2009-12-12',0)

Thank you for your reply and apologies, I should have read the ethitec before posting! I've basically created a temp table and loaded some data in it to play around...

Try this:

http://www.bidn.com/blogs/DevinKnight/ssis/144/ssrs-setting-default-parameter-values-for-analysis-services-datasets