Retrieve a list of dimension member id’s from a table

This script works with stories consuming a live model

var resultSet = TBL_S.getDataSource().getResultSet();
var members = ArrayUtils.create(Type.string);

// Loop through each row in the result set
for (var i = 0; i < resultSet.length; i++) {   
        var memberId = resultSet[i]["OBJECT_ID"].id;
        if (!members.includes(memberId)) {
            members.push(memberId);
        }
    }


console.log(members);
Code language: JavaScript (javascript)
Scroll to Top