Planning Analytics

 View Only

 Issue with TI Process and String-Based Numeric Filtering

Andrea Bonelli's profile image
Andrea Bonelli posted Tue May 13, 2025 10:35 AM

Good evening,

I'm encountering a strange behavior in a TI process that builds an MDX-defined subset.

To filter a numeric field, I created a string measure in a cube that the TI process reads in order to apply the filter. I'm using a string value because the user wants to include comparison operators (<, >, =) and the % symbol at the end of the input. To make it work, I trim the first character of the string, convert the numeric portion to decimal , and then remove the last character (>30% is converted to >0.30).

I've tested the process in my browser and everything works fine. However, when another user runs the TI process using the exact same filter value, an error is generated. The only difference between our configurations is the browser language. I've tested on my PC, changing the browser language and I face the same error.

Do you ever encounter a similar issue? 

I would appreciate any suggestions on how to resolve this issue.

Thanks,
Andrea Bonelli 

George Tonkin's profile image
George Tonkin IBM Champion

Hi Andrea, Could you share the code you are using as it may make it easier to make suggestions.