Negative Weight Issue

[amitbehere2002]

Hi All,

I got some issue about consolidation in my TM1 Application as
I have to put the weight as Negative for one Consolidation,I want put the formula is A = B - C
Where in Formula B is Consolidation with the weight of -1
So the issue comes up is somewhere the formula is working properly but somewhere it is not working
Please suggest me something as version for this application is TM1 9.5.1
Please do let me know if it is known bug in version 9.5.1
as i have tried in 10.1 it is working properly

[amitbehere2002]

Hi All,

I got some issue about consolidation in my TM1 Application as
I have to put the weight as Negative for one Consolidation,I want put the formula is A = B - C
Where in Formula B is Consolidation with the weight of -1
So the issue comes up is somewhere the formula is working properly but somewhere it is not working
Please suggest me something as version for this application is TM1 9.5.1
Please do let me know if it is known bug in version 9.5.1
as i have tried in 10.1 it is working properly

[qml]

Quoting yourself will not resolve the main reason why you are not getting responses: not enough detail.

Please describe in detail (or better yet - show) how/where you are applying the weight and where/when it works or doesn't.

[amitbehere2002]

Hi

It was wrongly quoted
My Question is quite simple as in my Formula is A = B-C
where B is Consolidated value
so the Formula will be A = B(1+2+3+4+5) - C
so this formula is not working everywhere in my Cubeview
Please do let me know for the same

[declanr]

Hi

It was wrongly quoted
My Question is quite simple as in my Formula is A = B-C
where B is Consolidated value
so the Formula will be A = B(1+2+3+4+5) - C
so this formula is not working everywhere in my Cubeview
Please do let me know for the same

Assuming you have a rule attached to your cube:

['A']=N: ['B'] - ['C'];

The fact it works in some cells but not others suggests that it either isn't fed or is incorrectly fed while you have skipcheck turned on?
If that is the case then you either have the options of feeding it correctly or more sensibly just deleting the rule and creating ['A'] as a consolidated element:


C - ['A']
- C - ['B'] (+1)
- N - ['C'] (-1)

[amitbehere2002]

Hi

No Rule is not attached for this consolidation
they have done is they have added the weight as -1 for Consolidation

[declanr]

Can you give more detail on how exactly it is "not working in some cells"?

Possibly a screenshot?

[amitbehere2002]

hi

Sorry i cannot post a screenshot as it is confidential
Following is the example
A B C
-170554 153056 323610
433093 433093 804006
-31603 937297 968899
236871 588224 351353
-70891 382619 453511
646378 646378 361722
480696 480696 520925
marked bold are some examples which are not working
for this i can say TM1 is not calculating properly for consolidation
i just want to know is it bug ?

[asutcliffe]

hi

Sorry i cannot post a screenshot as it is confidential
Following is the example
A B C
-170554 153056 323610
433093 433093 804006
-31603 937297 968899
236871 588224 351353
-70891 382619 453511
646378 646378 361722
480696 480696 520925
marked bold are some examples which are not working
for this i can say TM1 is not calculating properly for consolidation
i just want to know is it bug ?

I'd say this is almost certainly not a bug.

I'm assuming you have a consolidated element A with children B and C where B is weighted 1 and C is weighted -1. Is C fed for the examples that aren't working? Is there a C: level rule getting applied to A in the examples where it's not working? Why don't you use "Trace Calculation" on the cells that aren't giving the correct result?

[amitbehere2002]

Hi

In my scenario
A is parent of B and C and where B is also a parent of some Elements and weight for B is -1
C with the weight of +1
so the formula will be A = B(-1 weight) + C(weight 1)
formula is correct but it is not working in some of the calculation as mentioned above

[asutcliffe]

so the formula will be A = B(-1 weight) + C(weight 1)

I have to put the weight as Negative for one Consolidation,I want put the formula is A = B - C

So which is it?

In any case, in the "wrong" examples you've given, it looks like A is equal to B suggesting C might be a rule calculated cell that isn't fed. Alternatively, but probably less likely, a rule may be applied to A. So I suggest you look at the following:

Is C fed for the examples that aren't working? Is there a C: level rule getting applied to A in the examples where it's not working? Why don't you use "Trace Calculation" on the cells that aren't giving the correct result?

edit: school boy typo