Is there a way to for TI to write to multiple intersection in one line without looping through each element in Dimension subset?
Any alternative ways or options are most welcome.
Below code works find which to create a dynamic subset and tag all the elements by looping through elements however with 1000 of data points it take time to process.
thanks.
Code: Select all
myMDX = '{TM1DRILLDOWNMEMBER({[' | var_dim | '].[' | var_ele | ']},ALL,RECURSIVE)}';
SubsetCreatebyMDX(var_subsetName, mdx );
xCount = 1;
eleCount = SubsetGetSize( var_dim, var_subsetName);
WHILE( xCount <= eleCount );
var_mdx_ele = SubsetGetElementName( var_dim, var_subsetName, index );
CellputS(dyna_var, xCube,vCatg, var_mdx_ele, 'xyz');
index = index + 1;
END;