Popular Tags
- OTBI 1,456
- Reporting 1,398
- FDI 1,150
- Analysis and Data Visualization 991
- BI Publisher 866
- Analysis 684
- Oracle Fusion Analytics 597
- Administration 557
- OAC 482
- OBIEE 434
- Analytics 410
- BI Publisher Data Models 360
- Security 300
- HCM 269
- BIP 265
- Answers 265
- Analyses 255
- Developers 246
- Data Modelling and Datasets 229
- Oracle Analytics Cloud 220
- ERP Analytics Content 215
- Data Connectivity 212
- BI Publisher Report Templates 205
- Fusion Data Intelligence 196
- Report Output 184
Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture
ODI
Discussion List
-
How to update attributes of a datastoreI have created a datastore, and use reverse engineer to get the attributes, but I want to update the type for a column, after update, I can't save the changes, it shows … -
18FDI Data Lineage Subject AreaIntroduce a Fusion Data Intelligence data lineage subject area that not only identifies where customisations come from - such as from an supplementary data augmentation,…Yagnesh_Analytics 172 views 1 comment 18 points Most recent by Jay Pearson-Oracle Oracle Fusion Data Intelligence Idea Lab -
ODI can't load the local csv file on windowsI have two server A: it's my oracle database server, installed odi studio, repository, alone agent A B: it's a windows server, installed odi studio, alone agent B I trie…
-
How do I modify an IKM in ODI 12c to prevent duplicates in a target table?Hi everyone, I was practicing ODI 12c and I came across this problem: I have a mapping in ODI 12c that inserts the data from a staging table into a staging history table… -
Moving data from SAP BW to FDI-ADW (Custom schemas)Hello Team, We have a requirement to move data from SAP BW to FDI-ADW (custom schemas), and we're referring to the following Oracle documentation for guidance: However, …
-
2Allow non-default domain users to be configured for Object Storage connections in ODI MarketplaceWe have to use the default domain for the user configured in ODI to connect to OOS, need to allow other created domains' users to be configured to access OOS. When acces…JamesM4454 22 views 3 comments 2 points Most recent by Farivar Javanbakhti-Oracle Oracle Fusion Data Intelligence Idea Lab
-
ODI Error: Create view on source (LKM BIAPPS SQL to Oracle (Multi Transport))Hi, I have moved one mapping from UAT to SIT environment in ODI. I regenerated the scenario and run the scenario. The mapping is failed for below error. I have done the …User_F707D 21 views 1 comment 0 points Most recent by LCDavis-Oracle Oracle Business Intelligence Applications
-
ORA-01427: single row subquery return more than one rowWhen I run the mapping in ODI it will getting the issue ORA-01427: single row subquery return more than one row And am add rownum=1 in join condition interface successfu… -
Difference ODI on MP vs OCI - DIHi Team, We are deciding which ETL tool to suggest to the client for implementing FDIP/FAW. Can someone explain the difference between recommending ODI on MP and OCI-DI?…Vivek_Gautam 171 views 8 comments 0 points Most recent by Girish Ka-Oracle Oracle Fusion AI Data Platform -
Drop ODI COPY$ tables after data load completionHi, In ODI, during the data load it creates COPY$ tables in Oracle DB. In some cases, we get lot of copy$ tables getting created in DB and those are occupying more DB sp…Mrudula Kothapalli 21 views 2 comments 0 points Most recent by Gianni Ceresa Oracle Business Intelligence Applications
-
1Drop ODI COPY$ tables after data load completionDescription: In ODI, during the data load it creates COPY$ tables in Oracle DB. We're trying to drop the COPY$ tables with any of the ODI built in feature if available. …Mrudula Kothapalli 31 views 0 comments 1 point Started by Mrudula Kothapalli Oracle Analytics Idea Lab
-
How can two different teams can use a single PVO with different set of columnsHi, We have a scenario where AP team can extract ledger PVO with different column set and similarly AR team also need to extract the same PVO with different column set. …User_RO78H 11 views 1 comment 0 points Most recent by John Hung-Oracle Oracle Transactional Business Intelligence
-
Regarding Data Integration(Data Asset) Service in OCIAfter creating workspace in Oracle Cloud, I am creating data asset for the same. But when I try to create data asset it is showing me to add some policies to enable it. …
-
Any interface not executed in odi11gAny interface not executed in odi11g am checked in service still working fine but loadplans still running status not executed. How to clear the cache in odi 11g And how …User_HQ9TE 11 views 3 comments 0 points Most recent by Gianni Ceresa Oracle Business Intelligence Applications
-
Individual mapping is running fine but while running same in load plan getting failedIndividual mapping is running fine but while running same in load plan getting failed That columns just i am mapping source to target but same column names both tables. …User_HQ9TE 51 views 1 comment 0 points Most recent by Gianni Ceresa Oracle Business Intelligence Applications
-
1Need to configure HFM client with Oracle Business Intelligence Applications (OBIA) 11.1.1.10.3 PS2As far as i know OBIA is not certified with HFM Client .Can we have OBIA to support ODI module to be used for importing data from HFM using integrated ODI 12c Module tha…Saket.Saurav 11 views 0 comments 1 point Started by Saket.Saurav Oracle Transactional Business Intelligence Idea Lab
-
Differnce between ODI VS OBIEECan Any one tell me the difference between Oracle Data Integration(ODI) and Oracle Business Intelligence Enterprise Edition(OBIEE). Thanks in advance.
-
ODI 12.2.1.4 - problem in connect with ODI AgentHi, I have problem with connect to agent. Customer created two agents on server A, and now he wants to work from his local pc and ODi Studio installation. Everything wor…
-
Problems loading a view in ODI 12cHello, I am trying to load a view of 1 million records to a target table in ODI but the process does not finish, can you make me any suggestions to solve the problem? th…
-
OBIEE Pre-Builts Loading one year at a timeHi All, We are in a situation where we need to load one year at a time into the DWH (warehouse). We have 7 years of data to upload and we need to upload one year at a ti…Hippy 41 views 3 comments 0 points Most recent by Gianni Ceresa Oracle Business Intelligence Applications