BOB: Business Objects Board
Not endorsed by or affiliated with SAP

Register | Login 

Want to sponsor BOB? 
Want to sponsor BOB? (Opens a new window)  

General Notice: BOB is going to retire...please see details here.
General Notice: No events within the next 45 days.

Renaming Field Names


 
Search this topic... | Search Semantic Layer / Universe Designer... | Search Box
Register or Login to Post    Forum Index -> Semantic Layer / Universe Designer  Previous TopicPrint TopicNext Topic
Author Message
phantom404
Forum Member
Forum Member



Joined: 07 Nov 2018

Posts: 5



PostPosted: 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
Forum Associate



Joined: 20 Aug 2002

Posts: 902
Location: Woodinville, WA USA


flag
PostPosted: 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
Forum Devotee



Joined: 03 Feb 2003
ASUG Icon
Posts: 11462
Location: Manchester, UK


flag
PostPosted: 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
Forum Member



Joined: 07 Nov 2018

Posts: 5



PostPosted: 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
Forum Member



Joined: 07 Oct 2016

Posts: 15



PostPosted: 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
Display posts from previous:   
Register or Login to Post    Forum Index -> Semantic Layer / Universe Designer  Previous TopicPrint TopicNext Topic
Page 1 of 1 All times are GMT - 5 Hours
 
Jump to:  

Index | About | FAQ | RAG | Privacy | Search |  Register |  Login 

Get community updates via Twitter:

Not endorsed by or affiliated with SAP
Powered by phpBB © phpBB Group
Generated in 0.0351 seconds using 17 queries. (SQL 0.0103 Parse 0.0009 Other 0.0239)
CCBot/2.0 (https://commoncrawl.org/faq/)
Hosted by ForumTopics.com | Terms of Service
phpBB Customizations by the phpBBDoctor.com
Shameless plug for MomentsOfLight.com Moments of Light Logo