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: 836
Joined: Thu May 06, 2010 3:03 pm
OLAP Product: TM1
Version: PAL 2.0.3
Excel Version: 2016 64-bit
Location: JHB, South Africa
Contact:

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

Post by gtonkin » Mon Nov 02, 2020 11:05 am

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: 2588
Joined: Mon Dec 29, 2008 6:26 pm
OLAP Product: TM1, Jedox
Version: PAL 2.0.8
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 » Mon Nov 02, 2020 7:08 pm

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

Wim Gielis

Excel Most Valuable Professional, 2011-2014
https://www.wimgielis.com ==> 117 TM1 articles and a lot of custom code
Newest blog article: Using TI to change elemant names, like Biden to Trump

scrumthing
Posts: 58
Joined: Tue Jan 26, 2016 4:18 pm
OLAP Product: TM1
Version: 2.0.9
Excel Version: too many

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

Post by scrumthing » 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!
There is no OLAP database besides TM1!

Wim Gielis
MVP
Posts: 2588
Joined: Mon Dec 29, 2008 6:26 pm
OLAP Product: TM1, Jedox
Version: PAL 2.0.8
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 » Tue Nov 03, 2020 11:36 pm

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

Excel Most Valuable Professional, 2011-2014
https://www.wimgielis.com ==> 117 TM1 articles and a lot of custom code
Newest blog article: Using TI to change elemant names, like Biden to Trump

Post Reply