Hi All,
pls explain what is data validation rules in cognos.
Thanks in Advance.
Regards,
Balu.
Hi,
I'm not sure if my answer will be the right one but I can tell you how we do it here.
1- Check each query subject to be sure the number of row return is good
2- Test aggregate on each fact tablet on unique key, do the same for dimension and compare to select make in the database, not the select produced by cognos but one written by an other tools like toad sqlPlus
3- Test group of dimension against one fact
4- Test group of fact and 2 dimension and compare result
5- test group of fact against a group of dimension and compare result
To do that is long and fastidious but that way we are sure the data Cognos burst are good
Thanks