Categories

JAVA DATEBASE
Technology Network Community
Oracle Database
Fusion Middleware
Development Tools
Java
Desktop
Server & Storage Systems
Enterprise Management
Berkeley DB Family
Cloud Computing
Big Data
Business Intelligence
Architecture
Migration and Modernization
E-Business Suite
Siebel
PeopleSoft Enterprise
JD Edwards World
Industries
JD Edwards EnterpriseOne
User Productivity Kit Pro (UPK) and Tutor
Governance, Risk & Compliance (GRC)
Master Data Management (MDM)
Oracle CRM On Demand
On Demand: SaaS and Managed Applications
AutoVue Enterprise Visualization
Primavera
ATG
Agile PLM
Endeca Experience Management
Fusion Applications
Archived Forums

 



Tags

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


Related Links

Running query without "date" dimension
Navigation issue
OBIEE JVM tuning
OBIEE mixed hierarchy based on Essbase
Union All Issue
OBIEE 11g MAPVIEWER-00011 Error
OBIEE 11g ODBC Drivers not found
Rudimentary automated PDF generation using Delivers
How to provide Responsiblity level security in OBIEE 11g
Restricting Downloading/Exporting in OBIEE 11g
11g Agent Question
Cannot start Weblogic in SampleApp V107 VirtualBox Image
PDF format attachment from delivers to email is giving error
My Folder is Missing
Sum Aggregation Error in Physical & BMM Layer in OBIEE 11g with Essbase 11
How to string aggregate in OBIEE reports?