Skip to Content
0
Jun 09 at 08:44 AM

SAC (Analytic Application) || Set Dimension Filter does not work on tables properly

108 Views Last edit Jun 09 at 10:38 AM 2 rev

Hello everyone, I have noticed that setting "measure" filters in tables is extremely error prone.

The data is basically consumed via a BW Live connection. Now we have a requirement to exchange measures in a table by selecting a field from a dropdown. I noticed that measure filters using table.getDataSource.setDimensionfilter([a,b,c,...]) are partly not set.

Often only 2 of the 5 selected measures are filtered. If I add all 5 measures to the table in the design time, it works without any problems but as soon as I try to set them via the scripting functions - the filter won't apply in the table.

Can someone tell me the cause ? The problem is extremely annoying, because we now have to use about 6 tables instead of one, simply for the reason that the filter function for the table does not work properly.

Best regards