Custom MDX Query in a data integration giving error
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 ''"