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: 904
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: 11526
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 |
|
|
|
|
