I am using BPC for NW 7 and I have a requirement to build a report which includes a sum of distinct account hierarchy nodes into one result row. The account hierarchy nodes have different parents, so I cannot select the parent to achieve this result.
For example, I want to return the result of (node X + node Z) in one row.
Has anyone tried this? Is it possible without building another hierarchy?