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

MOSC Banner

"Like" mapping does not validate question marks '?'

edited Mar 18, 2019 1:21PM in Hyperion Financial Data Quality Management (FDM/FDMEE) (MOSC) 4 commentsAnswered ✓

Hi all,

We have defined "like" mappings that look as follows:

CC_?? to CC_??

CC_??? to CC_???

The logic is clear: take everything starting by CC_ followed by 2 or characters and load it into the corresponding CC_xx or CC_xxx member.

The mappings work correctly so data is loaded where it should be, but they don't validate. The problem arises when power users try to migrate these mappings between environments. As per an internal policy, mapping migrations are performed with the "validate" option checked. As these don't validate, they fail to be migrated and have to be manually recreated. Not a big deal for an admin, but power users find this anoying.

Tagged:

Howdy, Stranger!

Log In

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

Register

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

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center