Planning Analytics

As of PAW 2.0.98, an MDX Editor is available for view widgets in PAW. You can start there and then copy the MDX to PAX.

https://www.ibm.com/docs/en/planning-analytics/2.0.0?topic=2098-mdx-editor-updates

Thanks for your information, Walter.  I heard about PAW earlier and looked at it a little bit.  After reading your reply (by the way, it does not appear I can reply directly to you to your post.  Therefore, I clicked to answer instead), I looked at it again. 

It seems in our case, we can only use the editor when we create a view from a particular cube.  And the MDX can only access the data in that particular cube.  Is it the way our admin configured it so that we do not have more of a free form MDX editor for us to query any cube?  That would be the ideal case.  

Best regards.

Indeed, you use PAW and start from a given cube of which you access the data.

if could be combined with data fro other cubes but the starting point is a new or existing view on an existing cube.

There are a few non-ibm alternatives. The open source MDXPy library makes writing MDX much easier if you already know python. If you prefer a web based IDE i would highly recommend ARC by Cubewise. It has an MDX editor with autocomplete and syntax highlighting. 

Thanks for your reply, Wim.

Thanks for your information, Ryan.  I just heard about MDXpy yesterday when I was watching a video about TM1py.  I do not know Python well, but I found a few lines of code that supposedly can run MDX queries.  I saw ARC the other day, but have not looked into it much.  Will give it a try as well.

Google Sheets is another option for using MDX. TeamOne Google Sheets addon provides MDX() function, explorations or data export task, where you can use MDX.

TeamOne offers MDX mods, which provide a simplified MDX syntax that is easy for non-technical users. Even if you see MDX mods for the first time, I'm sure you will be able to understand the expression with no issues:

\FY20*\>>descendants>>level=0>>status=OPEN>>first=5

This is equivalent to the following standard MDX:

{HEAD( {FILTER( {TM1FILTERBYLEVEL( {DESCENDANTS({TM1FILTERBYPATTERN({TM1SubsetAll([Month].[Month])}, "FY20*", "")})}, 0 )}, [Month].[Month].CurrentMember.Properties("status") = "OPEN" )}, 5 )}

There is also TEAMONE() function, where users can fetch data by providing just the element names\aliases. TeamOne can automatically detect the dimensions and skip empty and Google Sheets calculated cells:

Thanks Vlad for your information on TeamOne Google Sheet for running MDX queries.