SAC Excel Exclude Option

[russellg]

Hi 

We are trying to upload a list of Cost Centers into the SAC Excel filter function and then exclude them for the report.

IT is possible to upload the list but it is not possible to upload them and exclude them - the system will only accept the upload as Select Member only (4) . You then have to go through the long list and select "exclude" for each one. 

IN SAP AFO you can upload a list and prefix with "!" which acts as the exclude function 

We did try dimension override function in excel but the option "6" does not exist or is allowed 

Question 

Has anyone found a way of uploading and excluding automatically for a long list of members 

Thanks

Russell

[russellg]

@Henry_Banks

[chmbilal]

Hi,
hoping that you are doing well. Ist you need to load the excluding values  in an array.then you can try to use setDimensionFilter here is the sample

var excludedValues = ["Value1", "Value2"];
var allowedMembers = [""];

var membersBatch = Table_1.getDataSource().getMembers("Item", 1000);

if (membersBatch) {
for (var i = 0; i < membersBatch.length; i++) {
var member = membersBatch[i];

// Check if the member is not in the excluded list
if (excludedValues.indexOf(member.id) === -1) {
allowedMembers.push(member.id);
}
}if (allowedMembers.length > 0) {
Table_1.getDataSource().setDimensionFilter("Item",allowedMembers);
} else {
console.log("No allowed members found to apply.");

hoping that this will help you...

Regards

[russellg]

Thanks - please can you explain how this SAC code is used in the SAC excel add in please ?

[N1kh1l]

@russellg 

Unfortunately there is no option to mass exclude the selected members. Once you paste, you have to set Exclude for each of them one by one.

Hope this helps 

Nikhil