Skip to Content
Jan 21, 2020 at 05:12 PM

Capture Hierarchy Node


Hi Experts,

I am trying to capture G/L-Hierarchy node from one Query and pass it on to the second Query.

Basically there are 2 Crosstabs, that are visible at run time to user. Crosstabs are put next to each-other. When user expand node on Crosstab one that should drill the same node on the second query simultaneously.

I tried below code but clearly its missing the node here,

DS_1. expandNode("0GL_ACCOUNT", CROSSTAB_01.getSelectedMember("0GL_ACCOUNT"));

expanded the code below for NODE, no luck

var getmembers = CROSSTAB_01.getSelectedMembers("0GL_ACCOUNT");
var referenceString = "";
getmembers.forEach(function(element, index) {
  referenceString = referenceString+element.internalKey+"/";
 DS_2.expandNode("0GL_ACCOUNT", referenceString);

Appreciate your advise, thanks