How does the Dimensions get their ROW_WID(s), which are the dimensions PKs? Well it is not done by the database systems. Instead, the PKs are controlled by Informatica using Sequence transformations. These Sequence transformations are within the mplt_SIL_XXX(s) within the SIL mappings. Remember in my prior post on mapplets defined in OBIA, these *_SIL_* mapplets [...]
Archive for the ‘Oracle BI Apps’ Category
Sequence Generators in Informatica and BI Apps
Posted in Oracle BI Apps on May 23, 2011 | Leave a Comment »
OBIA Mapplets defined
Posted in Oracle BI Apps on May 18, 2011 | Leave a Comment »
There are pretty much 4 predominant types of mapplets in OBIA Infa ETL. Business Component (ex: mplt_BC_XXX) – These mapplets are used to extract the data from the source systems. They are only found in the SDE folders and start off the majority of the mappings. Within these mapplets, you will find the Source Tables [...]
Data level security on Logical Tables
Posted in Administration Tool, BI Server, Oracle BI Apps on April 22, 2011 | Leave a Comment »
The other day while working on data level security within OBIEE (BI Server), I found something very interesting I would like to share. While testing my data level security for various combinations of groups, I noticed that for one subject area I was not having my security filters applied. That should not and can not [...]
ORA-32036, WITH clause and STAR_TRANSFORMATION_ENABLED
Posted in BI Server, Oracle BI Apps on April 21, 2011 | Leave a Comment »
Its been a very, long time since I posted. And for just cause, as I have been very busy working OBIEE and OBIA projects. I have noted down along the past year interesting finds which I will post in the coming months. Of which, I will begin with an issue I came across using Oracle [...]
