Cube View MDX - handling of TM1SubsetToSet
** Key Information (please complete the following information):**
- Company / Customer Name: Amazon
- Operating System: Windows
- TM1 Version: 11.8
- Browser: Chrome
- Arc clients: Web
- Arc Version: 4.3
Describe the bug
The Arc Cube Viewer throws an error when trying to evaluate a full MDX which contains "TM1SubsetToSet". The MDX Lab has no issues evaluating the same MDX.
To Reproduce
Steps to reproduce the behavior:
- Using Apliqo "UX_Samples", go to the "Product" cube
- Put in the full MDX below:
SELECT {[Product Measure].[Standard Cost],[Product Measure].[List Price]} ON COLUMNS , {TM1SubsetToSet([Product].[Size], "Collapsed")}
ON ROWS FROM [Product] WHERE ( [Version].[Version].[Actual], [Year].[Year].[2012], [Currency].[Currency].[GBP], [Region].[Region].[1] )
- Refresh cube view and notice error: "Cannot resolve TM1 subset"
- If you don't use full MDX but rather use the Arc UI to select a subset on a virtual hierarchy on the rows (i.e., "Collapsed" on the "Product" dim), Arc will end up generating the same MDX, which will fail if saved/shared.
Expected behavior
Since the TM1SubsetToSet function is valid, we do expect it to return results. We have noticed that the alternative syntax of {[Dim].[Hier].[Subset]} does evaluate without issue in the Cube Viewer. However, since Arc generates the subset MDX using the TM1SubsetToSet function, it is causing some issues for users who build a view using the subset editor on a virt hier and then try to save/share this MDX view.