I'm sorry if you have to shout but I'm new in TM1 with zero experience. If anyone can help with these: I have to createprocess not rule that woul calculate fakturiranost/nefakturiranost according to data from cube Radni sati and cube Uloga na projektu. Example: For Dražen Horvat it would be 10*5=50 SO fakturirano would be 50 EUR.
I didn't manage to get HRK from last posts so it would be enough for EUR.
Sorry, one more, but I'm new in whole story. Maybe it seems simple to you.
Problem with calculation
-
- Posts: 12
- Joined: Sat Mar 05, 2016 8:59 pm
- OLAP Product: IBM Tm1
- Version: 10.1.0
- Excel Version: Office plus 2013
Re: Problem with calculation
- Attachments
-
- Opet 2.jpg (181.56 KiB) Viewed 3978 times
-
- Posts: 12
- Joined: Sat Mar 05, 2016 8:59 pm
- OLAP Product: IBM Tm1
- Version: 10.1.0
- Excel Version: Office plus 2013
Re: Problem with calculation
And thank you all, finally calculation formula from previous posts works:
SKIPCHECK;
['HRK']= N: ['EUR'] *DB('Tečaj',!Period,!Scenarij,'EUR','Tečaj');
FEEDERS;
['EUR']=>['HRK'];
Thanks!
SKIPCHECK;
['HRK']= N: ['EUR'] *DB('Tečaj',!Period,!Scenarij,'EUR','Tečaj');
FEEDERS;
['EUR']=>['HRK'];
Thanks!
-
- Posts: 12
- Joined: Sat Mar 05, 2016 8:59 pm
- OLAP Product: IBM Tm1
- Version: 10.1.0
- Excel Version: Office plus 2013
Re: Problem with calculation
I got one more problem with creting process that would calculate fakturiranost and nefakturiranost. Form me i'ts problem beacouse I never created such process with
calculation. Any ideas?
calculation. Any ideas?
-
- Community Contributor
- Posts: 248
- Joined: Tue Nov 01, 2011 10:31 am
- OLAP Product: TM1
- Version: All
- Excel Version: All
- Location: Manchester
- Contact:
Re: Problem with calculation
Can we assume you've read the Turbo Integrator Guide and that also did not help?
I've read rules guide, but it doesn't help.
-
- Posts: 12
- Joined: Sat Mar 05, 2016 8:59 pm
- OLAP Product: IBM Tm1
- Version: 10.1.0
- Excel Version: Office plus 2013
Re: Problem with calculation
Better explanation: Fakturirano and Nefakturirano in cube Profitabilnost projekta must be calculated according to data from cube Radni sati and Tečaj
-
- MVP
- Posts: 2836
- Joined: Tue Feb 16, 2010 2:39 pm
- OLAP Product: TM1, Palo
- Version: Beginning of time thru 10.2
- Excel Version: 2003-2007-2010-2013
- Location: Atlanta, GA
- Contact:
Re: Problem with calculation
If you need to get data from a cube in a TI process you use the function CellGetN (or CellGetS if it's string). Suggest you read about it in the manuals,
-
- Posts: 78
- Joined: Wed Jul 31, 2013 4:32 am
- OLAP Product: Cognos TM1, EP, Analyst
- Version: 10.2.2
- Excel Version: 2013
- Location: Sydney AU
Re: Problem with calculation
While I feel your pain for having to go through this as tm1 newbie, it is also worth pointing out that some basic fundamental tm1 train (and self learning) will go a long way.Edward Stuart wrote:Can we assume you've read the Turbo Integrator Guide and that also did not help?
I've read rules guide, but it doesn't help.
You should not expect helpful people on the net to simply hand you the codes for every step/task you need to do or stuck on.
MK