Oracle Table Changes

building semantic layer
1

Hi,
I have 6 Universes set up and they are all stable. Now I have changed some of the tables in Oracle Database. There are no changes in the primary keys to any of the tables. I have only added some additional columns to tables. Will this affect BO in any way. When the user module is started, will it recognise the new table format or do I need to export the universe again?
Information on this is greatly appreciated.

Thanks in Advance.
Aravind G

Listserv Archives (BOB member since 2002-06-25)

2

From: “Aravind, G (GEP, Contractor)” G.Aravind@GEPEX.GE.COM

I have only added some additional columns to tables. Will this affect BO in any way. When the user module is
started,
will it recognise the new table format or do I need to export the
universe
again?
Aravind G

Arvin,

You need to change your Universe only if you want to add objects that use these new columns.

Farfadet

______________________________________________________ Get Your Private, Free Email at http://www.hotmail.com

Listserv Archives (BOB member since 2002-06-25)

3

Hello Aravind,

  1. Refresh the database structure in the Designer module
    using the menu option “View/Refresh Structure”.

  2. Save the Universe.

  3. Export the Universe.

Only after exporting the User modules on other PCs will recognize this change.

I hope this will help you.

Chandrashekar.S

Listserv Archives (BOB member since 2002-06-25)