How to use the getResultSet() APi with SAP Analytics Designer

The getResultSet() API returns result sets. A result set consists of property-value pairs. The property is a dimension name. The value contains information about the member or measure. You can get an array of result sets with getDataSource().getResultSet().

We are using an example from our Ownership Interface Analytics Application where we need to display the entity members for a scope, we read them from a hidden table with appropriate selection using the getResultSet() API. Then using the same API we will populate the Ownership report by scope.

Create two Script Objects, the first is the getScopeChildEntities with a return Type ResultSet and set as an Array, create one argument as a string called scopeId.

The second is the populateOwnershipTableByScope with a return Type void and do not set as an Array, nor create an argument.

This code was added to the getScopeChildEntities Script Object’s fx.

var results =Table_HiddenWrite.getDataSource().getResultSet({  

    "@MeasureDimension":"AMOUNT", 
    "Account":"[Account].[parentId].&[P_GROUP]",
    "AUDIT_TRAIL":"[AUDIT_TRAIL].[H1].&[INPUT]", // fixed
    "FLOW":"[FLOW].[H1].&[F99]",                 // fixed
    "INTERCO":"[INTERCO].[H1].&[I_NONE]",        // fixed
    "CURRENCY":"LC",                             // fixed
    //"ENTITY":"[ENTITY].[H1].&[ALL_ENTITIES]",  // ommited to get all
    "SCOPE": selectedScopeId,
    "Date": SV_String_selectedDateID,
    "Version": selectedVersion
});
return results; 

The populateOwnershipTableByScope Script Object’s fx includes this code

var selection = ({

    "@MeasureDimension":"AMOUNT", 
    "AUDIT_TRAIL":"[AUDIT_TRAIL].[H1].&[INPUT]", // fixed
    "FLOW":"[FLOW].[H1].&[F99]",                 // fixed
    "INTERCO":"[INTERCO].[H1].&[I_NONE]",        // fixed
    "CURRENCY":"LC",                             // fixed
    "ENTITY": part_entity_id,
    "Date":  SV_String_selectedDateID,
    "Version": selectedVersion
});

console.log(selection);

var data = Table_HiddenWrite.getDataSource().getResultSet(selection);

Add a button to the Analytics Application to test the result, and hide it at runtime after testing is complete.