If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

what is data validation rules

Started by balu, 08 Dec 2010 06:04:21 AM

Previous topic - Next topic

balu

Hi All,


   pls explain what is data validation rules in cognos.


Thanks in Advance.

Regards,
Balu.

jive

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