TM1-MDX-funtions in Cognos Reports

Post Reply
Toto
Posts: 71
Joined: Mon Jul 20, 2009 8:52 am
OLAP Product: TM1
Version: 9.5 Build 9.5.00100.2380
Excel Version: 2003

TM1-MDX-funtions in Cognos Reports

Post by Toto »

Hello,

if I wanted to develp Cognos8-Reports with a TM1-Cube, could I use the MDX-functions of TM1 in C8? What would be the syntax?
Can I use all C8-functions for a TM1-Cube, or only some of the normal C8-functions?

Thanks a lot,

Toto
MarioRubbo
Posts: 44
Joined: Wed Nov 04, 2009 3:50 am
OLAP Product: TM1
Version: 9.5
Excel Version: 2007

Re: TM1-MDX-funtions in Cognos Reports

Post by MarioRubbo »

You can't use any TM1 Subsets, Views, etc. in BI. You have to find equivalent functions in one of the Studios (Report Studio for example). C8 Report Studio has a very rich set of MDX functions exposed that you should be able to use. All the functions exposed in the Expression Editor are available to you but you do have to scrutinize each one to see if it will work on a relational database / OLAP cube / or both. The only datasource-specific functions are in the "Vendor Supplied" folder in the Expression Editor in Report Studio.
Post Reply