You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

rule file question?

edited Aug 2, 2018 2:36AM in Essbase 2 comments

Summary

rule file question?

Content

In a rule file that loads data, we want to achieve - "assign a predefined name if a member doesn't exist in the hierarchy"

like in the source file we are getting 100 different types of entities.... and we want

Entity "ABC" should be kept as it is "ABC"

Entity "XYZ" should be kept as it is "XYZ"

any other entities apart from the 2 above should be replaced with say "****"

is this possible via rule file in essbase cube?

I know we can do this type of massaging in source file directly (CSV etc) or if we use ODI to push into staging and then push it via rule file...

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!