Issue: Need to refresh the data layer of an existing Universe in a repository as new columns have been added to tables.
First Challenge: When publishing the updated universe it acts as a “new” universe causing all of the connected reports to throw errors. How can i update the existing universe so that it will view it as a revision and not a new universe with a new CUID?
Second Challenge: When refreshing a data layer the wizard reports that tables do not exist. However, the tables are clearly visible in the underlying database that is connected to the universe.
Challenge one: Ive done extensive googling and found that the reason i was receiving an error after publishing the updated universe is because i was not actually revising the existing universe but creating a new one which caused a new CUID to be created. The reports failed when attempting to look for the nonexistent universe based on the CUID. I was unable to find a solution.
Challenge two: Ive come across solutions that say that the data layer may not be pointed to the accurate connection but that does not appear to be the issue.
Any assistance is greatly appreciated. I have less than a week to solve.
P.S I have been smart and have done all this in development so nothing is broken in production. I have also searched the forum and have not run across solutions.