How can we do the unit testing?

Answers were Sorted based on User's Feedback



How can we do the unit testing?..

Answer / kranthi

Run the query against the database, then compare this
result with the original report o/p of cognos. If both the
results having equal number of records and same records,
then testing is OK.

Is This Answer Correct ?    11 Yes 0 No

How can we do the unit testing?..

Answer / rao

Unit testing is something that a report developer does from
his end before the report is passed on to UAT. Generally
TOAD is used to write SQL to validate the report. In my
case, I have used TOAD to do the unit testing.
If you don't have TOAD, I am not really sure if there is
any other to do it.

Thanks

Is This Answer Correct ?    2 Yes 2 No

How can we do the unit testing?..

Answer / jesse wolfe

Run the query with the type=XML parameter, then use XPath to
find the expected data rows and write specific asserts
against expected values. COuld do it in say VisualStudio or
any tool were you can validate against XML. Ideally, you can
jsut compare the entire document with what you were
expecting, though some items may throw you off.

We're even going to do TDD with cognos using this strategy.

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Cognos Interview Questions

How to maintain Query subject’s relationships between Database layer and Model Layer? For eg - if 2 DB layer's query subjects are copied in Model Layer - Query subjects respectively, then Where should we define relationship of both Query subjects? Either in DB layer or Model layer?

0 Answers  


Difference between cognos report net and cognos8

1 Answers  


how to hide a particular pages at time if you get blank pages

3 Answers   IBM,


What are the components of report net?

0 Answers  


-------What are the Adv of Star Schema and Snow Flake Schema?

4 Answers   Bank Of America,


how to add a new dimension in the powerplay transformer.i.e already we have devbeloped one cube. in that we want to add one new dimension cn anybody plese tell me the step by step procedure.

4 Answers  


What is the difference between regular dimension and derminant?

0 Answers   TCS,


how to create measures and dimensions?

0 Answers   IBM,


How do we implement Check Box Prompt in COgnos Report Studio?

2 Answers  


What is Report item

1 Answers   TCS,


can any body explain clearly how to explain any (sales) project in interview.actually feom where report developer work starts?pls reply as soon as possible.

8 Answers   Mind Tree,


How to add 2 different colors for alternative rows? i.e in a report all rows colors in alternative colors(2 colors)

4 Answers   Mphasis,


Categories