what is field set? what is the query calculation and layout
calculation?
Answers were Sorted based on User's Feedback
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 |
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 |
can we join 2 different queries? One has 10 columns and other has 5+ columns?
Define metrics studio?
What is difference between page break and section report? What is main advantage datawarehousing over oracle?
Which lifecycle we will use for reporting?
How to a create header dynamically in a crosstab report in cognos 8.1?
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?
advantages of cascade prompt ???
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?
is there any difference between operational database and data base?if yes what r they?
how u create security to reports ????
What are the types of catalogs in cognos?
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