Wildcards in setDimensionFilter (Analytic Designer)

[robert_schmidt01]

In Analytic Designer, I want to show all chart entries that start with the letter a.

I am using an SAC model based on a SAC data source to populate the chart.

[robert_schmidt01 · Accepted solution]

I figured out a way to do this with Live Data Connection for HANA. Please read my blog:Wildcards in HANA Parameters in SAP Analytic Designer

[Bob0001]

There is not possibility to achieve this with setDimensionFilter directly. If the list of members is not too big, you could get the members from result set (using getResult method on DataSource) or from master data (getMembers on DataSource, this might be slow depending on the number of members) and filter them yourself and set them as array using setDimensionFilter. Another option could to create your own calculated dimension and filter members via formular.