Hyperion Essbase (MOSC)

MOSC Banner

How to create a custom filter with wildcard conditions applied

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.

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