Categories
How to import metadata in offline mode into RPD
Hi all,
I am working on 11.1.1.7 version of obiee.
I am working on RPD in offline mode. There is a change in the table in the source database (oracle DB), user added new columns to the table.
In RPD, i have configured this Oracle DB in the connection pool. Is it possible to import these new columns to the rpd or do i require to create manually?
Regards,
Chandra.
Answers
-
Unless you can drop the table reimport then you will have to create the new columns manually, online or offline.
0 -
You can import offline as you can do it online.
It all depends on your host where the Admintool is running as it's the one connection to the DB and doing the job (and not the server).
Did you try the import? What happened?
If the question is more "can you update the existing table", in case you start having weird things or it doesn't want to make the job, before to drop the table (which will lose all your physical joins to it) you can just import it into a new "temporary" database object in the RPD, than copy/paste the new columns into the existing table and delete the "temporary" database and you are done.
0 -
Nice workaround!
0 -
When you are pissed to lose joins all the time you get creative
0 -
It's what us 'old timers' have learned to do!
0 -
Who ya callin' "old" mate? I'll roll my wheelchair over to you and hit you with my oxygen tank!
0
