Which table contains holiday dates

[djacks]

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

[TrevorKillick]

Hi Diane

They are stored in the h_settings column of the h_sys_slc table.

However the configuration is stored as a complex XML string.

Kind Regards

Trevor Killick

[djacks]

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.

[TrevorKillick]

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

[djacks]

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

Diane.