Arc - Cube Viewer - Excel export handling of non-alias attributes on rows
** Key Information (please complete the following information):**
- Company / Customer Name: Amazon
- Operating System: Windows + Mac
- TM1 Version: 11.8
- Browser: Chrome
- Arc clients: Web
- Arc Version: 4.2
- Excel Version: 2019 64-bit
Describe the bug
The ability to switch the "Display Attribute" name to non-alias attributes on the rows is useful in customizing a cube view. However, this presents some issues when the view is exported to Excel w/ DBRW formulas. The Excel export still shows the non-alias attribute on the rows, which will often result in DBRW errors as those values are not principal/alias element names.
To Reproduce
Steps to reproduce the behavior:
- Open up any cube view
- Right-click on row headers, expand "Display Attribute" and pick a non-alias attribute
- Refresh the cube view
- "Export Slice"
Expected behavior
We understand the consideration in keeping the non-alias attribute names to stay consistent with the cube view exported but find that this often causes greater confusion in our user base when they export and find DBRWs not working. We recommend that the Excel export should show the principal name if a non-alias attribute is selected.
Screenshots