TechWare

If you look at the ODI code base for OBIA (all 11.X versions) before every SDE mapping step or SIL mapping steps. We will see two sets of steps. Initialize steps (Before the map is run) Indexes are dropped Finalize steps (After the map is run) Indexes are created Stats are gathered When we add a new index to a table in DW schema or when we delete an index, we do not have to add CREATE INDEX, DROP INDEX or GATHER STATS steps to the ODI code base. There are hooks in the code to take care of these steps irrespective of the number of indexes. Index maintenance steps can be achieved by a couple of simple steps in Designer without having to write a single line of code. Let's start by understanding what are the steps involved in adding an index to a table. Step 1: Create indexes on the database Step 2: Reverse engineer the model (typically named Oracle BI Applications) Customized Reverse-Engineering using OBIA specific RKM Step 3: Modify options on the index....

Once in a while, there might be a need to change some of the passwords of the system users in OBIA. These could include the BIAppsSystemUser or the database passwords for the BIAPPS warehouse. BIAPPS 10.2 version users can follow the instructions as mentioned in this MOS tech note. OBIA 11g: How to change the system account passwords in BI Applications (Doc ID 2264922.1) If you are on older versions of BIAPPS, you can refer to this document instead OBIA 11g: Installing Oracle BI Applications 11.1.1.8.1 - Troubleshooting and Frequently Asked Questions [1997293.1]

Business intelligence ( BI ) mainly refers to computer-based techniques used in identifying, extracting, and analyzing business data, such as sales revenue by products and/or departments, or by associated costs and incomes. BI technologies provide historical, current and predictive views of business operations. Common functions of business intelligence technologies are reporting, online analytical processing, analytics, data mining, process mining, business performance management, benchmarking, text mining and predictive analytics. Applications in an enterprise Business Intelligence can be applied to the following business purposes (MARCKM), in order to drive business value. Measurement – program that creates a hierarchy of Performance metrics (see also Metrics Reference Model) and Benchmarking that informs business leaders about progress towards business goals (AKA Business process management). Analytics – program that builds quantitative processes for ...