Create a tag to build an alternate hierarchy and rollup in Cube without impacting your standard chart of accounts. Then, fetch that data into your report for further planning.
For example, use tags to create reports by budget owners.
Mutsu is responsible for the Sales, Marketing, and Customer Success departments. Since these are organized as separate dimensions in the standard department hierarchy, you create a tag that combines the three for Mutsu so you can fetch the data into your spreadsheet to see Mutsu's total budget.
Create a tag
1. Go to the Tags page in your Cube Workspace.
1. Click + New
2. Add a name, specify the dimension, and add the dimensions members you'd like to group.
3. Click Save.
Use a tag
Now, you can fetch data in your spreadsheet by citing the tag name in a row or column just as you would any other dimension member.
After you add the tag's name to the spreadsheet, reselect your range and fetch the data.
In the screenshot below, you can see the first range includes the new tag we created that sums the three departments in the second range.