04-13-2023 10:18 AM - last edited on 05-03-2023 09:04 AM by JackLacava
Does anyone know if it is possible to rename a cube? I am happy to execute SQL queries if that's what it takes.
Failing that are there any shortcuts for copying a cube (with all the workflows)? We have copied an application but one of the cubes (top level for workflow) must be renamed as it is out of place in the new application.
Any comments or ideas will be welcome. Thanks
Solved! Go to Solution.
04-17-2023 04:39 AM - edited 04-17-2023 05:06 AM
Not aware of any supported procedure to do that. The potential for breakage is very significant, I'd strongly advise to take backups in advance.
I guess something like this should work:
Alternatively, get the API Details & Database Documentation from the documentation package, find all references to cube names in db fields, and run SQLs as necessary, but Support might not be very happy about it when something goes wrong, you'd be on your own.
It might be worth engaging Support from the start, they will probably refer you to the Remote Consulting folks - who might be able to help (possibly for a fee).
04-17-2023 04:39 AM - edited 04-17-2023 05:06 AM
Not aware of any supported procedure to do that. The potential for breakage is very significant, I'd strongly advise to take backups in advance.
I guess something like this should work:
Alternatively, get the API Details & Database Documentation from the documentation package, find all references to cube names in db fields, and run SQLs as necessary, but Support might not be very happy about it when something goes wrong, you'd be on your own.
It might be worth engaging Support from the start, they will probably refer you to the Remote Consulting folks - who might be able to help (possibly for a fee).