03-06-2012 06:57 AM - edited 03-14-2019 09:30 AM
Hello,
The goal is to add a table where some custom parameters will be stored in order to speed up custom SQL queries.
Is it allowed/recommended to add a custom table to the HDS database?
Is it possible to add a table to the CUIC database? Is it possible to access the CUIC database?
Thanks,
Justine.
03-06-2012 08:02 AM
I would not add any tables to the HDS DB, pretty sure it's not supported. As for the CUIC database, I don't think you have access to the actual DB itself. Why don't you just build the table in another DB and create a new datasource in CUIC to pull data from this table?
david
03-06-2012 12:20 PM
Thanks for the reply David.
Since CUIC does not support 2 datasources for a single reports, I would need to create a view. Do you agree?
Thanks,
Justine.
03-07-2012 03:46 AM
Justine,
That's exactly how I have done this in the past. In theory my Custom Views could get removed when I do an upgrade but I will just recreate them.
Cheers
Boyd
Find answers to your questions by entering keywords or phrases in the Search bar above. New here? Use these resources to familiarize yourself with the community: