Skip to Main Content

Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Account dimension not recognized in HFM to Custom

ericeriksonAug 24 2018 — edited Aug 27 2018

Hi. Trying to pull data from HFM to a custom application with FDMEE 11.1.2.4.220. Successfully using FDMEE to load Oracle EBS to the same HFM application.

The target application is set up with an Account dimension and the import format maps the HFM Account dimension to the Target Account Dimension - see pic1.

pic1.png

The data load rule is set up to filter the Account and a Custom dimension - see pic2.

pic2.png

The process runs but nothing imports. When I look in the log, there are several entries that are almost helpful - see pic3. The extract point of view is there but the Account filter is not being applied and the Custom dimension one is. Every record is rejecting based on "[NULL ACCOUNT VALUE]." The number of records shows the data coming out of HFM but all rows are rejected.

pic3.png

Any thoughts?

Eric

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 24 2018
Added on Aug 24 2018
4 comments
274 views