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?
> 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.
