Solved

Business Objects detect column names on a renamed table

Posted on 2015-01-23
3
191 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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

MS Dynamics Made Instantly Simpler

Make Your Microsoft Dynamics Investment Count  & Drastically Decrease Training Time by Providing Intuitive Step-By-Step WalkThru Tutorials.

Question has a verified solution.

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

Suggested Solutions

A high-level exploration of how our ever-increasing access to information has changed the way we do our jobs.
If your app took Google’s lash recently, here are the 5 most likely reasons.
Viewers will learn how to use the Hootsuite Dashboard.
XMind Plus helps organize all details/aspects of any project from large to small in an orderly and concise manner. If you are working on a complex project, use this micro tutorial to show you how to make a basic flow chart. The software is free when…

730 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