Die Einschränkung im BW erfolgt über eine Exit-Variable, die die Werte aus dieser Tabelle ausliest.
// Get result set from table data source var tableResultSet = p_Table.getDataSource().getResultSet(); // Reference planning model var planningModel = PlanningModel_1; // Get all members of the given dimension var planningModelMembers = planningModel.getMembers(p_Dimension); // Array for members to be updated var members = ArrayUtils.create(Type.PlanningModelMember); // Array to store BW member–user combinations (DIM$USER) var dimensionMembersBW = ArrayUtils.create(Type.string); // Temporary variables var dimensionMember = ""; var dimensionUser = ""; var dimensionKey = ""; // Array to store unique dimension members from BW var dimensionArrayBW = ArrayUtils.create(Type.string);
// Extract dimension members and users from BW result set
for (var j = 0; j < tableResultSet.length; j++) {
// Get dimension member ID
dimensionMember = tableResultSet[j][p_Dimension].id;
// Get BW user mapped to SAC user
dimensionUser = tableResultSet[j][p_User].properties["ZBW_USER.ZSAC_USER.DISPLAY_KEY"];
// Build DIM$USER key if user exists
if (dimensionUser !== "#") {
dimensionKey = dimensionMember + "$" + dimensionUser;
dimensionMembersBW.push(dimensionKey);
}
// Store unique dimension members
if (dimensionArrayBW.includes(dimensionMember) === false) {
dimensionArrayBW.push(dimensionMember);
}
} // Loop through planning model members
for (var n = 0; n < planningModelMembers.length; n++) {
// Process only members found in BW result set
if (dimensionArrayBW.includes(planningModelMembers[n].id) === true) {
// Remove existing user writers but keep team writers
for (var i = 0; i <= planningModelMembers[n].writers.length; i++) {
var member = planningModelMembers[n].writers.pop();
if (member !== undefined && member.type === UserType.Team) {
planningModelMembers[n].writers.push(member);
}
}
// Add users as writers based on BW mapping
for (var k = 0; k < dimensionMembersBW.length; k++) {
if (planningModelMembers[n].id === dimensionMembersBW[k].split("$")[0]) {
planningModelMembers[n].writers.push({
id: dimensionMembersBW[k].split("$")[1],
type: UserType.User
});
}
}
// Collect updated member
members.push(planningModelMembers[n]);
}
} // Update dimension members with new authorizations planningModel.updateMembers(p_Dimension, members);
Consultant