Yeah, before we are dig into BI APPS, you should have minimum idea about data warehouse/ data warehousing. If you are new to the data warehouse please go through the below article, which gives a over view of data warehouse otherwise you can skip this link.
What is Data warehouse
In Oracle words:
“Oracle Business Intelligence Applications are complete, pre-built BI solutions that deliver intuitive, role-based intelligence throughout an organization. These solutions enable organizations to gain more insight and greater value from a range of data sources and applications including Oracle E Business Suite, PeopleSoft, JD Edwards, Siebel, and third party systems.”
Oracle BI Applications are built on the Oracle BI Suite Enterprise Edition, a comprehensive and market leading BI platform. This enables organizations to realize the value of a packaged BI application, such as rapid deployment, lower TCO, and built-in best practices, or to build custom BI applications—all on one common BI foundation.”
DAC Platform:
Pre-built Informatica metadata content:
Which has the predefined subject areas,tasks,warehouse table etc..
After you import the predefined content into DAC repository, you are able to see the source container for each source and it version as like Infomatica folders.
It is better to copy the source container and make it as custom one, before going to modify the OOTB content. So OOTB content won't be disturbed.
What is Data warehouse
In Oracle words:
“Oracle Business Intelligence Applications are complete, pre-built BI solutions that deliver intuitive, role-based intelligence throughout an organization. These solutions enable organizations to gain more insight and greater value from a range of data sources and applications including Oracle E Business Suite, PeopleSoft, JD Edwards, Siebel, and third party systems.”
Oracle BI Applications are built on the Oracle BI Suite Enterprise Edition, a comprehensive and market leading BI platform. This enables organizations to realize the value of a packaged BI application, such as rapid deployment, lower TCO, and built-in best practices, or to build custom BI applications—all on one common BI foundation.”
Components of BI Apps:
As defined BI Apps is a complete analytical solution which has the following components.
1. Informatica Power centre Platform
2. DAC Platform.
3. Pre-built Informatica metadata content
4. Pre-built DAC metadata content.
5. Pre-built BI meta data.(.rpd)
6. Data Warehouse.
6. Data Warehouse.
Informatica Power centre platform:
This informatica platform is a third party tool which is used to perform ETL operations, i.e. it will Extract the data from source then Transform into required format and Load the data into target warehouse.
DAC Platform:
This platform is used to operate and schedule the Informatica workflows/Tasks and Data warehouse tables.
Pre-built Informatica metadata content:
Once you complete the BI Apps installation, will get a pre-built informatica metadata content
(Oracle_BI_DW_Base.rep) which includes the pre-defined/Designed mappings,session and workflows.
Once you restore this content into your informatica repository, then you can able to view or access the OOTB code. After informatica content restored you can see the different type of folders for each type source system and each type of version like Oracle Apps 11.10.5,R12.1.2,R12.1.3 etc...
As shown below
It is suggested to copy the original folder and make it as custom one before going to change any modification to the give code. ( Look at the picture Custom_SDE_ORAR1213)
Here all the SDE prefixed folders are used to extract the data from different type of data sources like Oracle,JDE etc to staging area.
Pre-built DAC metadata content:
After completion of BI Apps installation, you will get the DAC metadata content as like informatica.Which has the predefined subject areas,tasks,warehouse table etc..
After you import the predefined content into DAC repository, you are able to see the source container for each source and it version as like Infomatica folders.
It is better to copy the source container and make it as custom one, before going to modify the OOTB content. So OOTB content won't be disturbed.
Pre-built BI Metadata:
It is purely reporting content, which is contains reports and dashboards. You can deploy this predefined .rpd (OracleBIAnalyticsApps.rpd)
Data warehouse:
We can use Oracle, Teradata and Netezza etc.. databases as Data warehouse. Oracle provided the predefined Data warehouse table in BI Apps. From DAC we can create those data warehouse tables.
So all Staging, Fact and Aggregate table will reside on a single database/schema.
No comments:
Post a Comment