ODI setup tips

1. Interface Flow IKM Selector Is <Undefined> Even IKM Has Already Been Imported (Doc ID 1453984.1)

SYMPTOMS:

Trying to create a new interface with IKM, such as IKM SQL to Hyperion Planning
The KM has already been imported but it does not show up on Interface -> Flow tab
IKM Selector is <Undefined>
The problem does not occur in Oracle Data Integrator 11.1.1.5

Cause:  Currently the issue is being investigated via unpublished BUG 13532957 - IKM SQL TO PLANNING COULD NOT BE SELECTED ON STAGING AREA

Solution:

 The following workaround is available :
1) After importing the IKM, open the KM and go to "Definition" -> "Source Technology"
2) Manually change "Source Technology" value from "Generic SQL" to "Undefined" 
3) Save and proceed with your new interface creation

How to Assign, update and remove Attributes to base dimension with outline load utility

Tips:

Attributes, Loading and Assigning Attributes Using Outline Load Utility
http://hyperionplanningandmore.blogspot.ca/2013/05/attributes-loading-and-assigning.html

https://community.oracle.com/message/10231999#10231999



Remind:
set <None> to remove.

Common Member Properties
Operation: Takes these values:
Update: Adds, updates, or moves the member being loaded.
Delete Level 0: Deletes the member being loaded if it has no children.
Delete Idescendants: Deletes the member being loaded and all of its descendants.
Delete Descendants: Deletes the descendants of the member being loaded, but does not delete the member itself.
Use caution when deleting members; this deletes the member, its data, and any associated planning units.

hp_admin_11122.pdf
P85 Loading Data and Metadata
P98 Dimension Properties
P278 Working with Dimensions
P374 Restrictions for Dimensions, Members, Aliases, and Forms

ODI Tips

Tips:
1. Essbase to Planning
http://john-goodwin.blogspot.ca/2008/12/odi-series-essbase-to-planning.html

2. Extract Essbase outline
http://john-goodwin.blogspot.ca/2008/10/odi-series-essbase-outline-extractor.html

3. SQL to Planning
http://john-goodwin.blogspot.ca/2008/10/odi-series-part-5-sql-to-planning.html

4. Operator parameters in planning data model

Here’s a list:

• Delete Level 0
• Delete Descendants
• Delete Idescendants

John explains them here: http://john-goodwin.blogspot.ca/2011/08/odi-series-deleting-planning-members.html

Common Member Properties
The default (i.e. null value) is to insert/update (aka upsert).
Update: Adds, updates, or moves the member being loaded.
Delete Level 0: Deletes the member being loaded if it has no children.
Delete Idescendants: Deletes the member being loaded and all of its descendants.
Delete Descendants: Deletes the descendants of the member being loaded, but does not delete the member itself.
Use caution when deleting members; this deletes the member, its data, and any associated planning units.

hp_admin_11122.pdf
P85 Loading Data and Metadata
P98 Dimension Properties
P278 Working with Dimensions
P374 Restrictions for Dimensions, Members, Aliases, and Forms

5. Loop in ODI pacakge
https://blogs.oracle.com/dataintegration/entry/using_variables_in_odi_creatin
http://www.canburaktumer.com/blog/odi-11g-implementing-loops/



6. ODI Variables
http://oracledataintegrator.blogspot.ca/2011/10/odi-variables.html

7. Planning dimensions
    Extracting existing metadata from Planning Repository
    http://devepm.com/tag/planning-repository/