Page 1 of 1
Negative Weight Issue
Posted: Thu Sep 20, 2012 8:39 am
by 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
Re: Negative Weight Issue
Posted: Thu Sep 20, 2012 9:10 am
by amitbehere2002
amitbehere2002 wrote: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
Re: Negative Weight Issue
Posted: Thu Sep 20, 2012 11:15 am
by 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.
Re: Negative Weight Issue
Posted: Fri Sep 21, 2012 7:25 am
by 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
Re: Negative Weight Issue
Posted: Fri Sep 21, 2012 7:45 am
by declanr
amitbehere2002 wrote: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)
Re: Negative Weight Issue
Posted: Fri Sep 21, 2012 7:53 am
by amitbehere2002
Hi
No Rule is not attached for this consolidation
they have done is they have added the weight as -1 for Consolidation
Re: Negative Weight Issue
Posted: Fri Sep 21, 2012 7:55 am
by declanr
Can you give more detail on how exactly it is "not working in some cells"?
Possibly a screenshot?
Re: Negative Weight Issue
Posted: Fri Sep 21, 2012 8:05 am
by 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 ?
Re: Negative Weight Issue
Posted: Fri Sep 21, 2012 8:14 am
by asutcliffe
amitbehere2002 wrote: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?
Re: Negative Weight Issue
Posted: Fri Sep 21, 2012 8:22 am
by 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
Re: Negative Weight Issue
Posted: Fri Sep 21, 2012 8:42 am
by asutcliffe
amitbehere2002 wrote:
so the formula will be A = B(-1 weight) + C(weight 1)
amitbehere2002 wrote: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:
asutcliffe wrote: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