Solved

Business Objects detect column names on a renamed table

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

IT, Stop Being Called Into Every Meeting

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

Join & Write a Comment

If your app took Google’s lash recently, here are the 5 most likely reasons.
The article will include the best Data Recovery Tools along with their Features, Capabilities, and their Download Links. Hope you’ll enjoy it and will choose the one as required by you.
This video will demonstrate how to find the puppet warp tool from the edit menu and where to put the points to edit.
The viewer will learn how to successfully download and install the SARDU utility on Windows 7, without downloading adware.

743 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

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now