Jump to content

Which table contains holiday dates


Recommended Posts


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

Link to comment
Share on other sites

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,


Link to comment
Share on other sites

Hi Diane

Let me check but i think you have been given access to the wrong set of Forums, this one if specifically for the Hornbill Cloud Solution we provide not Supportworks, so my answer really wont help you sorry.

Correct Supportworks Reporting Forum here: https://forums.hornbill.com/index.php?showforum=12

Kind Regards

Trevor Killick

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
  • Create New...