Hi
I am trying to understand more of BO. Say I have created a universe in Development environment, and all
my tables inthe universe are from developement schema say develop.table1, develop.table2. Now I want to export my universe to production environment, all the production tables are say production.table1, production.table2(exact replica of development schema tables). Please let me know what changes I should do before exporting my universe to production domain.
Also say I have a report created which is querying from an universe from development environment, how can I make the report querty from production environment before publishing it?
You should have seperate universes for your Dev and Prod environments.
The Dev universe should be pointing to the Dev database and the Prod universe to the Prod database. Even though as you said they are the exact replica of each other, they may/would be different in future.
You should export the prod universe to the prod repository and dev universe to the dev repository. Once you have these Prod and Dev universes, when you open the reporter it would give you a list of available universes to create a new report and you can choose XYZ[Prod] or XYZ[Dev] universe from the list for your reporting needs.
Hi,
Thanks for the response. Correct me if I am wrong… you mean to say
I have to start creating my whole universe again in production? As far
as I understand, I think I have to just import the universe from development, change some connections, so that the tables will point to
the production schema, save it and again export it to production domain.
Also regarding reports, What if the reports are already been created
which is running against the universe in development, I just want the
same report to run against universe in production.(I am not trying to
create a new report). Please advise
If in designer you highlight the tables you need to rename, and then right click on any one of them, the top option in the popup list is rename table. This option will also allow you to rename the owner also.
Thanks brent,
yes you can rename the table owners name, but what bout the objects
and sqls should I gointo each one of these and change the reference
from development. table1 to production.table1?
If I recall, the sql for the objects should rename correctly. I’d try it on the most complicated table you have and see for yourself (save the universe first). I don’t think it will change any custom sql queries you have created yourself for custom list of values, etc., but most objects should change without a problem.
Brent is correct. Once the tables are renamed all the corresponding sql gets updated with the new table names. Koushik, Just out of curiosity, why are you guys having the Production and development environments in the same Machine(same database). Naturally there used to be different databases with different servers. In that case there used to be no difficulties in migrating(just a change of connection would do).
For your report migration, after exporting the Production Universe, You can change the connection in your existing report to point to the new universe.
Hi ashok,
First of all I am not a BO personat my work place, but I am just curious. I guess they have different schemas in the same database.
one is production and one is development. They design their stuff in dev and test it if everything looks fine they just connect it to production.
Regarding the report, I understand your point, but can you please let me
know how you change the report to point it to production database? like where should i do that change? really appreciate your help.
There is a setting in the prm file for the database that you are using that sallows it to ‘ignore’ the owneer name by changing the setting (default is OWNER=Y - change it to N). The catch ehre is if you have FC users, all oftheir files need to be synchronized with a changes one and there are 2 on your WebI server that will need to be adjusted (one used by ZABO and one by WebI).
You cannot point your report to a different database direcctly, but you have to point it to a different copy of your universe which in turn is pointing to your production Database.
Open your report in Development,
Go to View - Data - Click on the Definition Tab - Click on the button near the Universe name and you will find the list of Universes available - Select your production Universe - ok.
(BOB member since 2004-06-02)
(BOB member since 2002-10-31)