MMULT function in TM1
-
elias912
- Posts: 1
- Joined: Fri Oct 29, 2010 5:32 pm
- OLAP Product: TM1
- Version: 10.2 xxx
- Excel Version: 2007+
MMULT function in TM1
Hi - has anyone got any code for doing the MMULT function within TM1 - thanks in advance !
-
declanr
- MVP
- Posts: 1831
- Joined: Mon Dec 05, 2011 11:51 am
- OLAP Product: Cognos TM1
- Version: PA2.0 and most of the old ones
- Excel Version: All of em
- Location: Manchester, United Kingdom
- Contact:
Re: MMULT function in TM1
MMULT is just doing simple multiplications and grouping them together; since TM1 doesn't have an equivalent formula you just have to break it down to the component parts and have a cell for each required calculation and then use the in built consolidations to get to the end result.
It's relatively straight forward in TI or Rules; you just need to ignore the concept of the MMULT formula and go back to the basics of multiplying arrays.
It's relatively straight forward in TI or Rules; you just need to ignore the concept of the MMULT formula and go back to the basics of multiplying arrays.
Declan Rodger