djacks

I see - sorry about that! Thanks for your help, Diane.

Hi Trevor, Thanks for the reply, but I can't see that table in the back-end database SWDATA (a SQL Server DB), is the table part of a different database (I have heard mention of a MySQL instance on the application server)? Sorry if that sounds like a daft question but I am the BI person and nothing to do with the sys admin and I've only used SWDATA so far! Thank you, Diane.

Hi, Can anyone tell me which table contains details of dates configured as bank holidays etc. so I can add it as a column in the time dimension of our data warehouse/analysis cube? Thank you, Diane Jackson