Business Intelligence Suite Enterprise Edition
Covers BI Server, Interactive Dashboards, Answers, Delivers, Disconnected Analytics, Briefing Books
importing extra columns in physical tables
hi gems... am new in OBIEE(10.1.3.4.1)...till today i worked on the repository which is already been built by someone. meanwhile the product has been upgraded and thats why there are lots of tables and lots of columns in existing tables have been added to the schema. so now as per the requirement, i need to import some of the new tables and all the new columns in the existing tables in the repository. New tables i can import from the option file-->import-->from database. But how can i import the new columns in the existing tables?? is there any other way out than to do that manually one by one and then updating all the row counts?? please help...thanks in advance...
Hi, It's also similar... go to u RPD--> menu--> file--> import metadata--> enter user ID,password of u r DSN then u Just select the new columns/table then import it. save it and then update all row counts. obiee10g link refer: http://www.oracle.com/technetwork/middleware/bi-enterprise-edition/tutorials/obiee10g-453439.html http://www.oracle.com/webfolder/technetwork/tutorials/obe/fmw/bi/biee/r1013/bi_admin/biadmin.html Thanks Deva
Hi, When you re-import a table automatically the new columns would come into the physical layer and there on its the same process updating the rowcount. Cheers, KK