MDX in the set editor could be greatly enhanced by having auto-complete and a function picker like rules and TI.
Currently you need to reference other sources for MDX syntax, supported functions etc.
Messaging could also be greatly enhanced.
The standard and only response in Invalid MDX expression.
Architect/Perspectives was at least a bit better hinting at where the issue may lie, even if not always accurate, was better than what is now available.
https://ibm-data-and-ai.ideas.aha.io/ideas/PAOC-I-403
Auto-complete and Function picker for MDX in PAW/PAfE set editor
-
- MVP
- Posts: 3222
- Joined: Mon Dec 29, 2008 6:26 pm
- OLAP Product: TM1, Jedox
- Version: PAL 2.1.5
- Excel Version: Microsoft 365
- Location: Brussels, Belgium
- Contact:
Re: Auto-complete and Function picker for MDX in PAW/PAfE set editor
So you are going to reduce the stream of visitors to my MDX page ? 

Best regards,
Wim Gielis
IBM Champion 2024-2025
Excel Most Valuable Professional, 2011-2014
https://www.wimgielis.com ==> 121 TM1 articles and a lot of custom code
Newest blog article: Deleting elements quickly
Wim Gielis
IBM Champion 2024-2025
Excel Most Valuable Professional, 2011-2014
https://www.wimgielis.com ==> 121 TM1 articles and a lot of custom code
Newest blog article: Deleting elements quickly
- scrumthing
- Posts: 81
- Joined: Tue Jan 26, 2016 4:18 pm
- OLAP Product: TM1
- Version: 11.x
- Excel Version: MS365
Re: Auto-complete and Function picker for MDX in PAW/PAfE set editor
IBM should just pay you to maintain that functionality within the set editor.Wim Gielis wrote: ↑Mon Nov 02, 2020 7:08 pm So you are going to reduce the stream of visitors to my MDX page ?![]()

But that page is still the number one go to place for anything related to MDX for TM1. <-- Just wanted to add that appreciation!

And YES IBM should definitely improve that editor!
There is no OLAP database besides TM1!
-
- MVP
- Posts: 3222
- Joined: Mon Dec 29, 2008 6:26 pm
- OLAP Product: TM1, Jedox
- Version: PAL 2.1.5
- Excel Version: Microsoft 365
- Location: Brussels, Belgium
- Contact:
Re: Auto-complete and Function picker for MDX in PAW/PAfE set editor
Thank you for the kind words !scrumthing wrote: ↑Tue Nov 03, 2020 11:43 amIBM should just pay you to maintain that functionality within the set editor.Wim Gielis wrote: ↑Mon Nov 02, 2020 7:08 pm So you are going to reduce the stream of visitors to my MDX page ?![]()
But that page is still the number one go to place for anything related to MDX for TM1. <-- Just wanted to add that appreciation!
And YES IBM should definitely improve that editor!
Note to self: add MDX syntax for views to the page.
Best regards,
Wim Gielis
IBM Champion 2024-2025
Excel Most Valuable Professional, 2011-2014
https://www.wimgielis.com ==> 121 TM1 articles and a lot of custom code
Newest blog article: Deleting elements quickly
Wim Gielis
IBM Champion 2024-2025
Excel Most Valuable Professional, 2011-2014
https://www.wimgielis.com ==> 121 TM1 articles and a lot of custom code
Newest blog article: Deleting elements quickly