I've actually just solved my problem, I realized that since I have the row templates created, I can pull the required result I need directly from the row template using Row or Column Sharing.
Remember that with Cube Views, you could reduce maintenance by using row/column templates for Cube Views. That way if the column layouts are the same for all 3 cube views, then you only have to maintain the column layout once.
With Row Templates, you could have a Row Template each for UK/CA/US, and then have the main Cube View dynamically select which Row Template to use based on a parameter.
You could also use, in your row definition for accounts, you could use a Custom Member List to dynamically generate a list of specific accounts to be displayed in the rows, based on some criteria (e.g. property of the user, some parameter selection)
Is the question more on how to bring all these three cube views together into a single view?
Thanks for the reply - our team imagines it working similarly to excel and directly linking a cell to another workbook.
Here are some clarifying items:
These Cube Views share the same column template which helps reduce maintenance. However, each Cube View has its own row template as results are presented differently and calculated differently. On our consolidated Cube View for the corporate group we have a select few results (rows) from each row template that we'd ideally bring into this report.
Rather than code and maintain these rows a second or even third time, we'd prefer (if at all possible) to simply pull the result from the existing templates. For example, whenever our report writers update the CA row templates for their Cube View, the corporate group will by default have the updated result.
Hopefully this makes sense!
