Using ATTR() you can get IBM Planning Analytics dimension/hierarchy element attributes directly in Google Sheets.
ATTR() function supports alternative hierarchies.
You can specify multiple elements.
For complex reports, you can use solveOrder to control the formula evaluation order.
More info:
https://succeedium.com/teamone/doc/fo...