Cube viewer - MDX editor does not evaluate WITH
** 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
Describe the bug
Hi Arc team, not sure if this is a bug or current limitation of the cube viewer. The cube viewer has an MDX editor which shows the full MDX code of the current cube view or generates a new view based on edits to the MDX code. However, we noticed that the MDX editor doesn't fully support WITH / SET / MEMBER functions before the SELECT. If we paste in a valid WITH / MEMBER statement (which renders properly in MDX Lab), we see an "unable to parse MDX" error message.
Interesting enough, if we use the new Arc aggregate feature, we notice that Arc does generates the proper WITH / SET / MEMBER statement in the MDX editor window. However, if we try to modify this MDX, the entire WITH section disappears on subsequent refresh.
To Reproduce
Steps to reproduce the behavior:
-
Use UX_Samples instance, General Ledger cube
-
In the cube viewer, go into MDX editor and paste in: WITH MEMBER [Account].[ABC] AS 1 SELECT NON EMPTY {[Region].[Region].[1],[Region].[Region].[10],[Region].[Region].[2],[Region].[Region].[9]} ON COLUMNS , NON EMPTY {[Account].[4200],[Account].[4500],[Account].[ABC]} ON ROWS FROM [General Ledger] WHERE ( [Version].[Version].[Budget], [Year].[Year].[2016], [Currency].[Currency].[Local], [Department].[Department].[1], [General Ledger Measure].[General Ledger Measure].[Amount], [Period].[Period].[Year] )
-
You will see the MDX parsing error
-
Go to MDX Lab and paste in the same MDX and it renders properly
Expected behavior
I recognize the additional complexity of the cube viewer needing to render the dimension filters (vs MDX lab) so perhaps the parsing error is because of this. Curious if support for WITH in the cube viewer will be added in the future.
Our users are using the aggregate feature (very useful) but if they want to quickly share their view w/ another user, sharing their MDX code doesn't render the same view.
Screenshots