Data Validation

[amitbehere2002]

Hi,

As i am implementing "Top- Down Approach but i am bit more stressed on Validation issue in congos TM1 contributor"
as it is very much easier in Cognos planning
But can any one suggest my about how can i do validation in TM1


Thanks & Regards
Amit

[lotsaram]

Did you try searching the forum for "data validation"?
http://www.tm1forum.com/viewtopic.php?p=28298

[amitbehere2002]

Thank you for your reply.

but what i need is top management put in some numbers for lower level and it get transferred to respective version and after that respective version will put in their figures after agreeing or not agreeing on the same which is being provided by top management

so what i need is that we are going to calculate the variance for each of the versions but i need the validation if it is matching or not so after matching data with top management he can submit the data for lower level mangement

my Hierarchy is Top Management -> Circle ->Module ->Network -> Region

Kindly help me in the same

Thanks & Regards
Amit Behere

[lotsaram]

Thank you for your reply.

but what i need is top management put in some numbers for lower level and it get transferred to respective version and after that respective version will put in their figures after agreeing or not agreeing on the same which is being provided by top management

so what i need is that we are going to calculate the variance for each of the versions but i need the validation if it is matching or not so after matching data with top management he can submit the data for lower level mangement

my Hierarchy is Top Management -> Circle ->Module ->Network -> Region

Kindly help me in the same

Thanks & Regards
Amit Behere

Dear Amit,

Welcome to the forum. May I point you to the request for assistance guidelines http://www.tm1forum.com/viewtopic.php?f=3&t=1037
Rather than making people guess what your question is, you will probably have more success if you clearly articulate your issue up front.

[Martin Ryan]

You could have three scenarios, mgmt input, user input and variance. Variance would be a consolidation of mgmt input and user input with one of them having a weighting of -1. Variance will tell you which lines are different and by how much.

Martin