what is field set? what is the query calculation and layout
calculation?

Answers were Sorted based on User's Feedback



what is field set? what is the query calculation and layout calculation?..

Answer / gnani

Field set is same as block but with caption.

Using Layout calculation we can add runtime information to
report like rownum,page no.,date,time...
Using Query calculation we can perform scrubbing.
i.e u can calculate query items with arithmetic operations.
eg; [unit price]*[quantity],

Is This Answer Correct ?    10 Yes 2 No

what is field set? what is the query calculation and layout calculation?..

Answer / adi

field set is a container here we can add other insertable
objects its looking like frame


using query calculation we can add new data items in report
designer page by applying calculations on source query items
ex:revenue=unitprice*quantity

by using layout calculation we can add run time information
by appying calculation on existing data items in reporting
environment

Is This Answer Correct ?    8 Yes 0 No

Post New Answer

More Cognos Interview Questions

can we join 2 different queries? One has 10 columns and other has 5+ columns?

2 Answers   IBM,


Define metrics studio?

0 Answers  


What is difference between page break and section report? What is main advantage datawarehousing over oracle?

0 Answers  


Which lifecycle we will use for reporting?

0 Answers  


How to a create header dynamically in a crosstab report in cognos 8.1?

0 Answers  






suppose there are 15 countries like (US, UK, ENGLAND,INDIA,JAPAN.......)i want a value prompt in the report and this value prompt should contain groups like group1(US,UK,ENG), group2(INDIA,US,UK), group3 (ENG,JAPAN,INDIA)and in the value prompt the values should be group1,group2,group3 how can we do this?

4 Answers  


advantages of cascade prompt ???

7 Answers   iFlex, Oracle,


How can you schedule a report based on different time zone ?(ex: local time should be same as 10 am . Japan should get the report at 10 am. USA should get the report at 10 am).Is that possible?

1 Answers   HCL, iGate,


is there any difference between operational database and data base?if yes what r they?

0 Answers  


how u create security to reports ????

10 Answers   iFlex, iGate,


What are the types of catalogs in cognos?

0 Answers  


i have a table with 3 columns country,empname,salary and i want the query for get the  name of the employees who is getting top 2 nd highest salary for individual country? Thanks in advance 

2 Answers   IBM,


Categories