cancel
Showing results for 
Search instead for 
Did you mean: 

Pass dynamic parameter to a table

0 Kudos

hi All, 

I need some help filtering my table with all members.

I tried this code without success.

var resultSet = Table_Scenario.getDataSource().getMembers("ZCP_DM_CCIND");

var memberInfos = ArrayUtils.create(Type.MemberInfo);
for ( i = 0; i < resultSet.length; i++)
{ var member = resultSet[i];
var memberId = member.id; var memberDescription = member.description; memberInfos.push({id: memberId, description: memberDescription}); }
Table_Scenario.getDataSource().setDimensionFilter("ZCP_DM_CCIND", memberInfos);
console.log(memberInfos); 

Thanks in advance 

Rosanna

#sac #story 2.0

View Entire Topic
N1kh1l
Active Contributor
0 Kudos

@rosanna_chiarazzo 

var resultSet = Table_Scenario.getDataSource().getMembers("ZCP_DM_CCIND");

This may not be bringing all members, I think default is 200. You can check how to bring all members

https://help.sap.com/doc/958d4c11261f42e992e8d01a4c0dde25/release/en-US/index.html#DataSource_MgetMe...

Also if you just remove the filter on this dimension its a good as all members right ?

 

Br.

Nikhil