Thursday, 24 April 2014

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

Thursday, 17 April 2014

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