Skip to Main Content

Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

How to limit accounts when integrating with Fusion GL Balance in EPBCS?

Lee JonghoAug 27 2024

Hi. Everyone.

I am integrating fusion erp and epm cloud.
I want to limit the data to be imported based on business rules.

There is no problem in specifying a specific value as shown in the figure below,
but I want to know how to apply the condition of all accounts starting with '1'.

I tried conditions like "1*" and @LIKE("1%","Account"),
but I am getting this error message:

"
ExtractBalanceData:Error::Cannot perform cube view operation. Essbase Error(1260046): Unknown Member = '1') used in query
"

I am hoping you can show me the way.
thank you.

Comments
Post Details
Added on Aug 27 2024
0 comments
30 views