Dimesion Loader Utility Completes Successfully But Does Not Load Members
Last updated on MAY 06, 2010
Applies to:Oracle Enterprise Performance Foundation - Version: 11.5.10 to 22.214.171.124 - Release: 11.5 to 11.5
Information in this document applies to any platform.
Checked for relevance on 6-May-2010.
In Enterprise Performance Foundation Administrator 11i, you cannot load dimension members into a dimension using the Dimension Loader utility in the "Data Rules" screen. While the request finishes successfully, you cannot see the dimension members in the "Configuration Rules" > "Dimension" > "Members" screen and no rows exist in the base dimension tables. Additionally, the rows remain in the _T interface tables with a STATUS = LOAD. The View Log and the Output log do not contain any errors.
Note: The following program is used to load the records: "FEM_DIM_HIER_LOADER module: Dimension Member and Hierarchy Loader".
Steps To Reproduce:
- Go to Enterprise Performance Foundation Administrator
- Go to "Data Rules" > "Dimension Loader"
- Create a rule to load a dimension
- Populate the _T interface tables
- Submit the rule
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms