Subset() function to get IBM Planning Analytics dimension elements in Google Sheets | TeamOne
SUBSET() function retrieves the dimension elements using the set expression. It expects the following arguments:
dimName - the dimension name, you can also use dimName:hierName syntax to specify an alternative hierarchy
setExpression - a valid MDX expression, $SubsetName or MDX mods
attrName - attribute name, i.e. 'Caption'
options - flag, "S" - static values.
solveOrder - specifies the formula evaluation order. If omitted, the default value of 0 will be used.
https://succeedium.com/teamone/doc/fo...
#IBMPlanningAnalytics #TeamOne #TM1 #GoogleSheets