
General Notice: BOB is going to retire...please see details here. General Notice: No events within the next 45 days. |
Author |
Message |
phantom404 Forum Member


Joined: 07 Nov 2018
 Posts: 5

|
Posted: Thu Jun 13, 2019 2:58 pm Post subject: Renaming Field Names |
|
|
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:
1. If a field is renamed on the database, will all reports using the field need to be adjusted?
2. Will the universes need to have the newly named field added to the tables so they are visible?
Thanks! |
|
Back to top |
|
 |
charlie Forum Associate


Joined: 20 Aug 2002
                 Posts: 902 Location: Woodinville, WA USA

|
Posted: Fri Jun 14, 2019 5:02 pm Post subject: Re: Renaming Field Names |
|
|
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. _________________ Regards,
Chaz |
|
Back to top |
|
 |
Mark P Forum Devotee


Joined: 03 Feb 2003
                 Posts: 11455 Location: Manchester, UK

|
Posted: Mon Jun 17, 2019 5:40 am Post subject: Re: Renaming Field Names |
|
|
phantom404 wrote: | 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:
1. If a field is renamed on the database, will all reports using the field need to be adjusted?
2. Will the universes need to have the newly named field added to the tables so they are visible?
Thanks! |
1. 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. _________________ Current version I'm using: 4.1 SP3 over Oracle. Well versed in SQL Server too, including SSIS
______________________________________
Prior versions used: BO3,4,5,6.5,XIr2,XI3, 4.1 - yes, I have been using BO since 1996! |
|
Back to top |
|
 |
phantom404 Forum Member


Joined: 07 Nov 2018
 Posts: 5

|
Posted: Wed Jun 19, 2019 9:32 am Post subject: Re: Renaming Field Names |
|
|
Thanks everyone for their input/advice, really appreciate it! |
|
Back to top |
|
 |
dan4280 Forum Member


Joined: 07 Oct 2016
   Posts: 15

|
Posted: Wed Jul 03, 2019 4:30 am Post subject: Re: Renaming Field Names |
|
|
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. |
|
Back to top |
|
 |
|
|