MDXpy - An MDX library for TM1

A forum to post information about tools which are free and open source.
Post Reply
MariusWirtz
Posts: 29
Joined: Sat Apr 08, 2017 8:40 pm
OLAP Product: TM1
Version: 10.2.2.6
Excel Version: 2016

MDXpy - An MDX library for TM1

Post by MariusWirtz »

Hi,

we started an open-source project to create MDX queries programmatically with python: MDXpy
I quickly wanted to mention it here, to make sure we reach all Python and MDX fans :)

> What are the use cases?

1. You do TM1py stuff and need to retrieve data from TM1 with MDX
2. You need MDX for any other purpose and you don't want to write a complex raw MDX

> Why not just write raw MDX?

- With MDXpy you are faster and require less MDX knowledge
(e.g. through autocompletion on functions and arguments)
- MDX Syntax errors are impossible. You can't forget `}`, `]` or `)`
- Logical errors (e.g. pass a `Member` instead of a `Set` to a function) are highlighted by the editor
- MDXpy handles common pitfalls through built-in smarts
(e.g. MDXpy escapes `]` in object names and wraps the `INSTR` method to behave case-insensitively by default)

> How does it work?

Image

> Where can I read more about it?

https://code.cubewise.com/mdxpy

https://github.com/cubewise-code/mdxpy

> How do I install it?

- Install Python 3.x
- Install PyCharm, VSC or Jupyter Notebook
- Run `pip install mdxpy`

> Anything else?

The project is open source. If your favorite MDX function is missing please create a Merge Request on GitHub.
User avatar
scrumthing
Posts: 81
Joined: Tue Jan 26, 2016 4:18 pm
OLAP Product: TM1
Version: 11.x
Excel Version: MS365

Re: MDXpy - An MDX library for TM1

Post by scrumthing »

I had a look and I must say I like it. mdxpy is a straightforward idea. Will have to test it further but it sure looks promising. Thanks for that!
There is no OLAP database besides TM1!
Post Reply