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
Can you define a catalog and types of catalogs in cognos?
How can reports be bursted based on two groups? I want to schedule to burst a report based on product line and years and I need the burst report for every product line and every year. How can this be done? Please help..
WHAT IS METRIC STUDIO?WHAT IS SCORE CARDS HOW TO IMPLEMENT IT AND WHAT IS THE USE OF SCORE CARD?
What is main advantage datawarehousing over oracle?
what are the difficult problem are you involved in cognos report net and 8 and impromptu if any pls share with us
What is main difference mapplets and mapping?
What do you understand by user class in cognos?
Can you define framework manager?
What are the roles defined by cognos platform?
Explain what is the difference between microstrategy and cognos reporting tool?
What is defined as catalog and types of catalogs in Cognos?
What is meant by drill down?
how you migrate reports to cognos 8 from previous versions?
Can you define metrics designer?
What is defined as data mining?