?
Solved

Business Objects detect column names on a renamed table

Posted on 2015-01-23
3
Medium Priority
?
203 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 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

Moving data to the cloud? Find out if you’re ready

Before moving to the cloud, it is important to carefully define your db needs, plan for the migration & understand prod. environment. This wp explains how to define what you need from a cloud provider, plan for the migration & what putting a cloud solution into practice entails.

Question has a verified solution.

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

This article was originally published on Monitis Blog, you can check it here . If you have responsibility for software in production, I bet you’d like to know more about it. I don’t mean that you’d like an extra peek into the bowels of the sourc…
In this article I discuss my selections of the Top Four free Outlook OST File Viewers available. Open, view and read even damaged OST files by using these tools. They all provide a clear preview of all data such as emails, notes, tasks, calendars, e…
Video by: Tony
This video teaches viewers how to export a project from Adobe Premiere Pro and the various file types involved.
Michael from AdRem Software explains how to view the most utilized and worst performing nodes in your network, by accessing the Top Charts view in NetCrunch network monitor (https://www.adremsoft.com/). Top Charts is a view in which you can set seve…

800 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