Page 1 of 1
Use of MDX functions in TM1
Posted: Tue Aug 11, 2009 9:54 am
by David Usherwood
TM1's online help has a longish list of MDX functions which are supported, eg (my interest) standard deviation STDDEV(...)
But....
How could you _call_ these functions? You can't use them in rules, they aren't relevant for filtered subsets. What gives? Is it off into API-land?
Re: Use of MDX functions in TM1
Posted: Tue Aug 11, 2009 11:30 am
by Lukas Meyer
Have a look at
http://www.bihints.com/tm1_sdk - it contains "vba for running MDX reports", which could be what you are looking for. (and yes, this will take you to api land - be cautious, those pseudo-pointers are not quite as tasty as you would expect
)
Re: Use of MDX functions in TM1
Posted: Tue Aug 11, 2009 1:13 pm
by David Usherwood
Site seems to be down at present. Good that the developers have provided this support but left it out of the application!
Re: Use of MDX functions in TM1
Posted: Wed Aug 12, 2009 5:46 am
by Lukas Meyer
There you go - in case it will be down again or someone in the future is interested in this too:
Attached to this page is the TM1 Open Source Toolkit developed by James Wakefield
v 1.0.1 adds:
.vba code for running TI processes/chores
.vba for running MDX reports
v 1.0 includes:
.Treeview control on form showing TM1 Servers with cubes and public views. An Imagelist control is used to populate the treeview with images.
.Button on Treeview form allowing user to select view and be written to Excel
.Button on Treeview form allowing user to select view and be shown equivalent MDX statement
.Button on Treeview form allowing user to select view and be shown equivalent XML statement
.form in vba that people can easily use to collect text commentary into TM1
.KillTM1 module of Robert Gardiner's that kills DBRW'S
Definitely a great piece of work to see how the API can be used.
It also saves you from reinventing the wheel.
I will try to track and make available all (future) versions of that toolkit on this page.
Source:
http://www.bihints.com/tm1_sdk on 08/12/2009