Using VBA to construct an MDX view that is using subsets using aliases.
The QR is built on a saved view.
The MDX is saved and updated in a sheet cell in the workbook.
Using this command:
Reporting.QuickReports.CreateFromMDX "https://devEnvironment.planning-analytics.cloud.ibm.com", "tm1", i
The rows are being rendered with the memberId, not the aliases as set in the subsets. The MDX rows are using those subsets. If the updated MDX from the spreadsheet is pasted into the MDX editor in a cube view, the view renders properly with aliases.
Is there a way to get the aliases to display in the QR when rebuilt?
------------------------------
Ty Cardin
------------------------------