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/