What is diffence between query calculation and layout
calculation?
Answer Posted / venkat reddy
Query Calculation
It is used to perform Data Scrubbing. Insert a query calculation into your report to add a new row or column with values that are based on a calculation. For example, you create a query calculation named Euros that converts dollars to euros by multiplying an existing dollar measure by a conversion rate. Euros can then be displayed to end users in a separate row or column.
Layout Calculation
Layout Calculation is used to provide run time information, but not used to perform any operation on the data. Create a layout calculation to add run-time information to your report, such as current date, current time, and user name. When creating layout calculations, only report functions are available to you in the expression editor. These functions are executed in the report layout, as opposed to the other functions which are executed in the query.
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
After applying date prompt and when we run the report we
fet from date and todate prompts..so when we enter
todate what do u mean by bridge group? where we r using this one? What is the enterprise class platform architecture of cognos 8? What is the information present in the cognos configuration file? how can you get the errors in job? when loops are araised
we get error? What is the function of cognos dispatcher? How do you call a store procedure within a transformation? What are query items? Write types of folders present in cognos? How can we import Excel data in to FWM?Wt is mean by Ragged
dimensions?where can we observe the Regular dimensions &
measure dimensions? what r the reports u faced critical and how it can be solved
.. any once can u give a best ans for interviw What are the advantages of shortcuts? What is meant by drill down? What is the diff between the following Report output-- HTML
O/P, PDF O/P, EXCEL 2000 and EXCEL 2003 of report outputs?
Listout main differences? 4. How many dimensions did you use in your reports?