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
Explain the characteristics of cognos?
Mention the difference between ‘macros’ and ‘prompt’?
what r the reports u faced critical and how it can be solved .. any once can u give a best ans for interviw
What is the advantage of using shortcuts?
What is called cognos reporting tool?
how can you get the errors in job? when loops are araised we get error?
hi all i am searching for cognos jobs pls inform about the jobs to:santosh.koora@gmail.com
Write some methods to apply securities in framework manager model?
Hi All, I have 1.6 years of experience in cognos in India. I always wanted to do a MS program to earn some money in US. But I think I am little late in taking the decision. As If I have to write my GRE it will be August or September of 2012 and will have to apply for fall 2013 as fall 2012 admissions are almost done now. So my concern is how will be my career do if my MS is at this stage,. i,.e. 3 years experience in Cognos and 2 years MS program in and again looking for job in U.S. Have I been too late in taking the call? I heard that MIS (Managing Information Systems) is having very good placements now. So guys, please advice me in taking the decision to have a good career and also in terms of earning money as I have few financial problems to solve (which I am hoping to solve when I get job in US after completion of my MS program). Thanks a lot friends. I really appreciate and thank one and all for their valuable comments in this site.
Can you define materialized view?
Explain the different types of views used in cognos.
What you mean by drill across?
What is the difference b/w macros and prompt?
how can we Upgrad the reports from version Impromptu 6.0 to 7.0 and Power Play from version 6.6 to 7.0 ?
how you burst the reports? If you are bursted reports is not reached to destination how you identify?when you import data into catalog you have complex columns names.how do you change the name of those columns?