Solved

Business Objects detect column names on a renamed table

Posted on 2015-01-23
3
185 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 100

Accepted Solution

by:
mlmcc earned 500 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 100

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

Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

Question has a verified solution.

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

I annotated my article on ransomware somewhat extensively, but I keep adding new references and wanted to put a link to the reference library.  Despite all the reference tools I have on hand, it was not easy to find a way to do this easily. I finall…
Today companies are subjected to more-and-more data, and it won't stop any time soon.  But there are obvious opportunities for reducing data, particularly data duplicated among companies.
This video demonstrates how to use each tool, their shortcuts, where and when to use them, and how to use the keyboard to improve workflow.
Video by: Tony
This video teaches viewers how to export a project from Adobe Premiere Pro and the various file types involved.

822 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