rule file question?
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...
0