Auto-complete and Function picker for MDX in PAW/PAfE set editor

Suggest and discuss enhancements for TM1
Post Reply
User avatar
gtonkin
MVP
Posts: 1192
Joined: Thu May 06, 2010 3:03 pm
OLAP Product: TM1
Version: Latest and greatest
Excel Version: Office 365 64-bit
Location: JHB, South Africa
Contact:

Auto-complete and Function picker for MDX in PAW/PAfE set editor

Post by gtonkin »

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
Wim Gielis
MVP
Posts: 3105
Joined: Mon Dec 29, 2008 6:26 pm
OLAP Product: TM1, Jedox
Version: PAL 2.0.9.18
Excel Version: Microsoft 365
Location: Brussels, Belgium
Contact:

Re: Auto-complete and Function picker for MDX in PAW/PAfE set editor

Post by Wim Gielis »

So you are going to reduce the stream of visitors to my MDX page ? :lol:
Best regards,

Wim Gielis

IBM Champion 2024
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
User avatar
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

Post by scrumthing »

Wim Gielis wrote: Mon Nov 02, 2020 7:08 pm So you are going to reduce the stream of visitors to my MDX page ? :lol:
IBM should just pay you to maintain that functionality within the set editor. :-D
But that page is still the number one go to place for anything related to MDX for TM1. <-- Just wanted to add that appreciation! :-P

And YES IBM should definitely improve that editor!
There is no OLAP database besides TM1!
Wim Gielis
MVP
Posts: 3105
Joined: Mon Dec 29, 2008 6:26 pm
OLAP Product: TM1, Jedox
Version: PAL 2.0.9.18
Excel Version: Microsoft 365
Location: Brussels, Belgium
Contact:

Re: Auto-complete and Function picker for MDX in PAW/PAfE set editor

Post by Wim Gielis »

scrumthing wrote: Tue Nov 03, 2020 11:43 am
Wim Gielis wrote: Mon Nov 02, 2020 7:08 pm So you are going to reduce the stream of visitors to my MDX page ? :lol:
IBM should just pay you to maintain that functionality within the set editor. :-D
But that page is still the number one go to place for anything related to MDX for TM1. <-- Just wanted to add that appreciation! :-P

And YES IBM should definitely improve that editor!
Thank you for the kind words !
Note to self: add MDX syntax for views to the page.
Best regards,

Wim Gielis

IBM Champion 2024
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
Post Reply