djacks Posted May 5, 2016 Share Posted May 5, 2016 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 Link to comment Share on other sites More sharing options...
TrevorKillick Posted May 5, 2016 Share Posted May 5, 2016 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 Link to comment Share on other sites More sharing options...
djacks Posted May 5, 2016 Author Share Posted May 5, 2016 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. Link to comment Share on other sites More sharing options...
TrevorKillick Posted May 5, 2016 Share Posted May 5, 2016 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 More sharing options...
djacks Posted May 5, 2016 Author Share Posted May 5, 2016 I see - sorry about that! Thanks for your help, Diane. Link to comment Share on other sites More sharing options...
Recommended Posts
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 accountSign in
Already have an account? Sign in here.
Sign In Now