Search found 12 matches

by marac2203
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
by marac2203
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?
by marac2203
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!
by marac2203
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...
by marac2203
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.
by marac2203
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:
by marac2203
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
by marac2203
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:
by marac2203
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...
by marac2203
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
by marac2203
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...
by marac2203
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