Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Universes and Database changes

Status
Not open for further replies.

nityk

Technical User
Aug 3, 2004
1
US
Hi,

I am new to Bo so I think this should be a basic question
but any help would be appreciated.

I have the following problem/dilema?

I have Column A from Table A which was added to Universe A, the universe is saved and a report is built using that universe.
Now say column A from Table A was dropped from the database but it is still in the universe (universe is not refreshed yet). Thus cascades into the report failing as well.
Is there a way to find out which column(s)/list of changes in the Universe A is no longer available when you refresh the structure?

TIA!!!!

Nity
 
Option "Refresh Structure" (under "view" in designermenu):

Columns were added to tables
Adds the columns to the corresponding tables in the universe.

Columns were removed from tables
Displays a warning message indicating the columns and associated joins you should delete.

Tables were removed from the database
Displays a warning message indicating the tables and associated joins you should delete.

Tables were renamed in the database
Displays a message that says it no longer recognizes the corresponding tables in the universe. You should rename these tables to match those in the database. If the names still do not match, Designer returns a message stating that the renamed tables do not exist in the database.

No changes were made to the database
Displays a message informing you that no update is
needed.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top