Attention: To align with new corporate security policies, and to match policies adopted by other communities within Oracle, the My Oracle Support Community access requirements will change beginning September 18, 2025. MOSC will now require that member accounts in our community be associated to a *corporate* email address. This means that users with generic domains (such as gmail.com, yahoo.com, and others) will no longer be granted access to the discussion forums and ideas labs. If this policy affects you, act now to change the email address that is associated with your Oracle (and community) account. Alternatively, you can opt to create a new Oracle account that uses your corporate email domain.

Hyperion Financial Data Quality Management (FDM/FDMEE) (MOSC)

How to map data values to a catch all member if metadata target does not exist.

Nov 8, 2017 4:19PM edited Jun 21, 2018 4:40PM in Hyperion Financial Data Quality Management (FDM/FDMEE) (MOSC) 2 commentsAnswered ✓

Source is JDE.

Target is a planning app.

FDMEE 11.1.2.4.210

We have a specific situation where we need to map any entities that are missing in our target metadata to a "No_Entity" member.

We have really simple 'Like' mapping setup as follows (no other mappings in play for the entity dimension):

Source Value Target Value

7* IGNORE

8* IGNORE

* BU_*

What we want is when the target BU_* does not exist in the planning app, we want to map the data to a 'No_Entity' member.

I tried adding an additional mapping:

Source Value Target Value

7* IGNORE

8* IGNORE

* BU_*

* No_Entity

To see if after it cannot find the target it would just map it to No_Entity.

Tagged:

fdmee

1

Howdy, Stranger!

To view full details, sign in to My Oracle Support Community.

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month