OBIA 11.1.1.8.1: Inventory In Balances Subject Area of Seeded OBIA
(Doc ID 2280116.1)
Last updated on APRIL 15, 2021
Applies to:
Business Intelligence Applications Consumer - Version 11.1.1.8.1 and laterInformation in this document applies to any platform.
Goal
Created custom lookup table to use for added fields from the seeded Inventory - Balances Subject Area with OBIA 11.1.1.8.1
The key to the Lookup Table is Item Number and Organization_ID.
This works by adding a logical column to the Dim - Item Dimension in BMM and used "Core"."Dim - Item"."Part Number" as the Item Number. Additionally hard-coding the organization_id to the primary org id number.
However, how to expand this so that it uses the Organization_ID for the inventory org that is being queried?
Where is the org id from found?
For example:
The lookup with the hard coded org_id is "LOOKUP ( SPARSE "Core"."XXLFI_ITEM_ORG_CUSTOMER_CODE_LKP"."CUSTOMER_NAME", 'None_Assigned', "Core"."Dim - Item"."Part Number", 83)".
How to replace the 83 number at the end?
Solution
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
Goal |
Solution |