Run MDX Against TM1 Cube

Post Reply
User avatar
mce
Community Contributor
Posts: 352
Joined: Tue Jul 20, 2010 5:01 pm
OLAP Product: Cognos TM1
Version: Planning Analytics Local 2.0.x
Excel Version: 2013 2016
Location: Istanbul, Turkey

Run MDX Against TM1 Cube

Post by mce »

Hi,

How can I query a TM1 cube directly using MDX?
Is it possible to do via a command line or something similar?

Regards,
Top
Marcus Scherer
Community Contributor
Posts: 126
Joined: Sun Jun 29, 2008 9:33 am
OLAP Product: TM1
Version: 10.2.2
Excel Version: 2016
Location: Karlsruhe

Re: Run MDX Against TM1 Cube

Post by Marcus Scherer »

Hi,
yes, it can be done, check this post:
http://www.tm1forum.com/viewtopic.php?p=2554
Top
Wim Gielis
MVP
Posts: 3241
Joined: Mon Dec 29, 2008 6:26 pm
OLAP Product: TM1, Jedox
Version: PAL 2.1.5
Excel Version: Microsoft 365
Location: Brussels, Belgium
Contact:
Contact Wim Gielis

Re: Run MDX Against TM1 Cube

Post by Wim Gielis »

Hi mce

See here:

on my website

for October 2011: MDX statements.
Scroll down a bit on that page with MDX'es.

Is this what you needed?
Best regards,

Wim Gielis

IBM Champion 2024-2025
Excel Most Valuable Professional, 2011-2014
https://www.wimgielis.com ==> 121 TM1 articles and a lot of custom code
Newest blog article: Deleting elements quickly
Top
Post Reply

Return to “IBM TM1, Planning Analytics, PAx and PAW”