Problem with calculation

marac2203
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

Post by marac2203 »

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.
Attachments
Opet 2.jpg
Opet 2.jpg (181.56 KiB) Viewed 3978 times
marac2203
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

Post by marac2203 »

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!
marac2203
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

Post by marac2203 »

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?
Edward Stuart
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

Post by Edward Stuart »

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.
marac2203
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

Post by marac2203 »

Better explanation: Fakturirano and Nefakturirano in cube Profitabilnost projekta must be calculated according to data from cube Radni sati and Tečaj
tomok
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

Post by tomok »

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,
Tom O'Kelley - Manager Finance Systems
American Tower
http://www.onlinecourtreservations.com/
babytiger
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

Post by babytiger »

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.
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.

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
Post Reply