[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

Business Objects detect column names on a renamed table

Posted on 2015-01-23
3
Medium Priority
?
209 Views
Last Modified: 2015-01-26
In Information Design Tool I renamed a table to match the correct name inthe database. The columns in the universe do not reflect the columns inthe DB. How do I refresh or detect such that the table in the universe autiomatically updates its column names to reflect the DB?

I am using BO 4.1 SP2
0
Comment
Question by:pcomb
  • 2
3 Comments
 
LVL 101

Accepted Solution

by:
mlmcc earned 2000 total points
ID: 40568875
Screen shot
CLick the DROPDOWN  that is below master.
Clcik REFRESH STRUCTURE

You have also update the Business Layer

mlmcc
0
 

Author Comment

by:pcomb
ID: 40569255
thanks mimcc I tried that but its not doing what I was expecting. I have a universe that is defined to use table XYZ (columns a,b,c) and has all the dimensino, joins etc created However my underlying database has the table as XYZ_01(columns 1,2,3). I dont want to have to redefine all the objects in the universe.

I was hoping I could rename the table iname in the universe data foundation to match the data i.e. rename XYZ to XYZ_01 and then refresh and the data foundataoin would change the columns from a,b,c to 1,2,3. That doesnt happen on the refresh is there a way to do this or do I need to manually rename each column in the universe?

thanks
0
 
LVL 101

Expert Comment

by:mlmcc
ID: 40569479
Is it in the same database as the universe?

Have you tried creating a connection to the new database then changing the connection of the data foundation?

If you right click a table in the foundation I believe there is an option to replace the table.

mlmcc
0

Featured Post

Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

While Plesk offers many potential benefits to website administrators, including compatibility with Windows Server and other leading technologies, the company has also been working to differentiate it from other control panels for content management…
Eseutil Hard Recovery is part of exchange tool and ensures Exchange mailbox data recovery when mailbox gets corrupt due to some problem on Exchange server.
An overview on how to enroll an hourly employee into the employee database and how to give them access into the clock in terminal.
Whether it be Exchange Server Crash Issues, Dirty Shutdown Errors or Failed to mount error, Stellar Phoenix Mailbox Exchange Recovery has always got your back. With the help of its easy to understand user interface and 3 simple steps recovery proced…

829 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question