Restrict array to ignore "Unbooked Members" and only list members existing in dataset

[andrewbarlow1]

Hi,

I am trying to dynamically apply a dimension filter to a series of charts in Analytics Designer.

There is a single model providing data to this dashboard.

The scenario is ..

1. I get the datasource from chart 1 and apply a filter to it.

Chart_1.getDataSource().setDimensionFilter("Business_Un_4i4p4d06t2","The Filter");

2. I then want to get the members of a particular dimension after the filter has been applied

var modelsArray = Chart_1.getDataSource().getMembers("ModelDISPLAY_KEY",50);

The problem I have is that using this method the list of members returned includes all the unbooked members as well as the ones that have data against them. Is there a way of only returning the members that are valid for filtering?

Any help greatly appreciated

[former_member45674 · Accepted solution]

Hi Andrew,

If I understand your question right, the Resultset API can help you: https://saphanajourney.com/sap-analytics-cloud/resources/analytics-designer-resultset-api/

It returns a filtered dataset from Chart_1, then you can further get your restrict members on the dimension.

thanks,

Jason