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
TM1-MDX-funtions in Cognos Reports
-
- 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
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.