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

Custom MDX Query in a data integration giving error

edited Jan 14, 2026 5:25PM in EPM Platform and Freeform

Hello, I am trying to add a custom MDX query to my data integration. I am following the document at . This works if I use "#Custom{Except([A.1.d_Capital].Levels(0).Members,{CPSDQ262})}", but we want this to be flexible and not have to list out very member that we need to exclude, so we created UDA AxiomSkip. Based on what I have seen in searching, the it should look like this:
"#Custom{Except([A.1.d_Capital].Levels(0).Members,UDA([A.1.d_Capital], "AxiomSkip"))}"

However, I get error "ERROR [AIF]: String index out of range: -9" when trying to do this. If I take the quotes away from around "AxiomSkip", then I get this error "ERROR [AIF]: Cannot perform cube view operation. Essbase Error(1260052): Syntax error in input MDX query on line 2 at token ''"

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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