Search found 12 matches
- Fri Mar 11, 2016 2:35 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Problem with calculation
- Replies: 26
- Views: 13920
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
- Fri Mar 11, 2016 2:05 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Problem with calculation
- Replies: 26
- Views: 13920
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?
- Fri Mar 11, 2016 2:00 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Problem with calculation
- Replies: 26
- Views: 13920
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!
- Fri Mar 11, 2016 1:28 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Problem with calculation
- Replies: 26
- Views: 13920
Re: Problem with calculation
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 create process 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...
- Fri Mar 11, 2016 11:34 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Problem with calculation
- Replies: 26
- Views: 13920
Re: Problem with calculation
I also included all dimensions from referencing cube Tečaj in calculation.
- Fri Mar 11, 2016 11:33 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Problem with calculation
- Replies: 26
- Views: 13920
Re: Problem with calculation
I've adjusted new order with original one if you had meant that? I' also found pop up window to trace calculation. But unfortunally the problem is same:
- Fri Mar 11, 2016 11:13 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Problem with calculation
- Replies: 26
- Views: 13920
Re: Problem with calculation
When I click trace calculation in Cube Uloga na projektu cube in intersection Dražen Horvat and HRK cijena po satu nothing happens
- Fri Mar 11, 2016 11:09 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Problem with calculation
- Replies: 26
- Views: 13920
Re: Problem with calculation
Here is the order of dimensions in both cubes:
- Fri Mar 11, 2016 10:48 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Problem with calculation
- Replies: 26
- Views: 13920
Re: Problem with calculation
Hi! I really don't know why my rule formula doesn't work. I've read rules guide, but it doesn't help. Please anyone can help me to get right calculation. If you look at the picture I need to get for example this value with rule Cube named Uloga na projektu: HRK Cijena po satu=EUR Cijena po satu* EUR...
- Thu Mar 10, 2016 5:04 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Problem with calculation
- Replies: 26
- Views: 13920
Re: Problem with calculation
I wrote your roule but unfortunatelly it doesn't work. Maybe piture can help.
Cube 1 is Radni sati
Cube 2 is Tečaj
Cube 1 is Radni sati
Cube 2 is Tečaj
- Thu Mar 10, 2016 4:20 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Problem with calculation
- Replies: 26
- Views: 13920
Re: Problem with calculation
I have two cubes. Cube 1 with this order of dimensions: Projekt,Zaposlenik,Period,Scenarij,Valuta,Fakturiranje and Cube 2 with this order of dimensions: Period,Scenarij,Konverzija,Valuta Measure dimension in Cube 1 is : Fakturiranje with elements Fakturabilni sati and Nefakturabilni sati Measure dim...
- Thu Mar 10, 2016 1:29 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Problem with calculation
- Replies: 26
- Views: 13920
Problem with calculation
Hy! I need help with rule calculation in TM1:
I need to get value in cell HRK when I put number in EUR (Cube is named Radni sati)
EUR must be multiply with value in second cube named Tečaj. I got screenshots
I need to get value in cell HRK when I put number in EUR (Cube is named Radni sati)
EUR must be multiply with value in second cube named Tečaj. I got screenshots