Beautify and Run MDX queries on IBM Cognos TM1 multidimensional databases.
- Beautify MDX statements for better readability with the
Format MDX
command. - Execute MDX statements on a TM1 database with the
Execute MDX
command.
Download the .vsix package and install the extension in your Visual Studio Code or download the git repository and run it directly in Visual Studio Code.
Before executing MDX queries you have to connect to and login into a TM1 database server.
The port number is the port of the TM1 admin server. By default the server listens on port 5895. The communication with the admin server can only use http connections, not https connections.
Tip: You can also enter the servername as hostname:portnumber
Tip: You can state your mostly used database server as default server in the settings to shorten the connect process.
- TM1 MDX Client is a Visual Studio Code extension, so you need Visual Studio Code to run it.
- In order to execute MDX statements you must have access to a TM1 database.
This extension contributes the following settings:
whiteducksoftware.tm1client.defaultserver
: Default server for connection as hostname:portnumber
- Not all function names are defined as keywords
- The formatting parser doesn't know all calculations yet.
Initial release of TM1 client
- Bugfix: Didn't clear list of databases after re-connect
- Enhancement: Now recognizes element range expressions (element:element)
IBM, TM1, and Cognos are trademarks or registered trademarks of International Business Machines Corp.