Translate

Wednesday, 3 September 2014

OBIA 11.1.1.7.1 / 11.1.1.8.1 Custom BIACM Offerings for Load Plan / Custom Fact Group

We are Taking on New Clients at the Moment as Independant Contractors for OBIA 11.1.1.7.1 / 11.1.1.8.1 , ODI and Informatica projects



Me and Krishna at DeliverBI had to create a new CUSTOM BIACM Offering and Fact group for one of our longstanding clients, to seperate E Business Suite data loads Out Of the Box and their own Custom data sources. On the Back of the changes we wrote a setup document. 



So we have decided to share this with the OBIA / OBIEE Community.
Extension Documented was Applied to OBIA 11.1.1.7.1 and OBIA 11.1.1.8.1+

I have uploaded a document which covers setting up new functionality that is not available out of the box. We have included scripts needed to expand the offerings within the BIACM tool within OBIA and instructions to configure


BIACM Config. 2
Step 1: Creation of Custom Offering. 2
Step 2: Creation of Source for the new offering. 2
Step 3: Creation of Custom Functional Area. 2
Step 4: Creation of relation between Offering and Functional Area. 3
Step 5:  Creation of fact group (Repeat for each Fact Group). 3
Step 6: Creation of Func Area to Fact Group Relation (Repeat for each Fact Group). 3
Linking BIACM Fact Groups to ODI Objects. 4
Fact Model / Dimension Model 4
Load Plan Steps (provided only for SILs, but SDE steps will be the same). 5
Dev Components. 5
Load Plan System Component (Required for a New Fact Group or Dim Group). 7
Generate the Custom Load Plan in BIACM... 8

Link to Document

Click Here to Download the Custom BIACM Offering within Load plan document
Click Here to Download the Custom BIACM Offering within Load plan Scripts


Regards
Shahed Munir and Krishna Mohan 

No comments:

Post a Comment

Google Big Query Clone / Copy DataSets / Tables - PROD --> TEST --> DEV Projects

Google Big Query Cloning of Datasets & Tables across GCS Projects. We searched the internet and could not find a simple cloning / ...