Hi! Thanks in advance for the help/advise. I’m not the one that works on the backend with the tables and universes but was tasked with researching this topic.
Some poor naming convention is used for some fields and is causing some confusion so we are wanting to rename the fields to something more logical to the end users.
A couple questions:
If a field is renamed on the database, will all reports using the field need to be adjusted?
Will the universes need to have the newly named field added to the tables so they are visible?
You should refresh structure. In IDT, open the data foundation, click the Detect drop down and choose Refresh Structure… As the wizard progresses, you’ll see a list of Missing Columns, Added Columns, Modified columns and a Summary. You’ll have to change the SQL Definition for the objects affected by the name changes. After doing that and publishing the universe, try running a WebI that uses one or more of the objects in question. You might have to open the document in design mode and edit the data provider, click view script, click use custom query script, then click use query script generated by your query, and save.
Only where freehand SQL has been used - fixing in the universe and republishing will cascade the fix to the reports that use objects based on the fields. Don’t delete objects and create new ones.
Why don’t you just rename the objects in the universe? I assume by end user you mean the people who are building WEBI reports? This way any existing reports will continue to work and new reports will show the new object names.
(BOB member since 2002-08-20)