Unable to exclude members based on conditional search from a source filter in EPCM Data Management
We are trying to pull only certain cost centers which starts with either "PK*" or "Z0*" etc. but cannot put an Essbase function @MATCH to solve our purpose. However, as per Oracle Doc ID 2832900.1 , we should be able to put filters in Data Load Rules. It does not works for any functions whatsoever!
Then I came across the Oracle Fusion Cloud Enterprise Performance Management July 2023 update wherein Oracle mentioned that they have added MDX functions into Data Integration and hence I tried to leverage "IsMatch" function to search for my desired result but failed. Only the Levels(0).Members is working as expected.
Tagged:
0