Popular Tags
- OTBI 1,407
- Reporting 1,365
- FDI 985
- Analysis and Data Visualization 953
- BI Publisher 820
- Analysis 663
- Administration 553
- Oracle Fusion Analytics 550
- OBIEE 421
- Analytics 347
- OAC 338
- BI Publisher Data Models 335
- Security 273
- Answers 261
- Analyses 253
- Developers 240
- HCM 239
- BIP 233
- Data Modelling and Datasets 218
- Data Connectivity 206
- ERP Analytics Content 199
- BI Publisher Report Templates 185
- Report Output 180
- Agents 151
- Customizing Reports 146
Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture
ODI
Discussion List
-
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…Ngoc Phung 12 views 1 comment 0 points Most recent by Gianni Ceresa Oracle Analytics Cloud and Server -
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 14 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 11 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…User_HQ9TE 21 views 1 comment 0 points Most recent by SteveF-Oracle Oracle Analytics Cloud and Server -
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 147 views 8 comments 0 points Most recent by Girish Ka-Oracle Oracle Fusion Data Intelligence -
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 35 views 0 comments 1 point Started by Mrudula Kothapalli Oracle Analytics Cloud and Server 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 12 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.CHAITANYASHAH 926 views 3 comments 0 points Most recent by [Deleted User] Oracle Analytics Cloud and Server
-
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 33 views 3 comments 0 points Most recent by Gianni Ceresa Oracle Business Intelligence Applications
-
OBIA / ODI 11 - ODI Agent won't start in Admin ConsoleHi team, I am facing an error when i'm trying to start oraclediagent deployment coming with OBIA Here the error message that i have :BenFreez 74 views 1 comment 0 points Most recent by Charles M Oracle Business Intelligence Applications
-
ODI-1232: Procedure Parse SQL execution fails - Data Lineage load issueI found one instance of this error and the stated solution was to regenerate the OBIEE extract files which we did. We ran the Data Lineage load plan early this morning a…MelissaCCHC 142 views 1 comment 0 points Most recent by Adrian_Popescu-Oracle Oracle Business Intelligence Applications
-
How to use both aggregate and analytic function in ODIHi All, I am working on ODI mapping where I am calculating" Min(ID) over parition by(device_num, sys_id) as min_id" in expression component, I used another expression co…User_XG491 2 views 0 comments 0 points Started by User_XG491 Oracle Business Intelligence Applications