What is diffence between query calculation and layout
calculation?
Answers were Sorted based on User's Feedback
Answer / leena k skariah
In Query Calculation, we can create a calculation/query
item based on either the Source package or the data items
of that query.
In Layout calculation,we can create a new calculated item
based on only the query data items, not from the source
package.
| Is This Answer Correct ? | 12 Yes | 6 No |
Answer / 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 |
Answer / arun pandiyarajhen
In Query Calculation, we can use the dynamic functions like current date, current time, etc.
In Layout calculation,we cannot use dynamic functions as in Query Calculation.
| Is This Answer Correct ? | 3 Yes | 9 No |
Answer / sowjanya
Both are used to generate an user-defined column.
For layout calculation,we can generate a new query item based
on all the query items present in a package
But for Query calculation,we can generate a new query item
based on only the query items present in the current Query(/
report)
| Is This Answer Correct ? | 7 Yes | 14 No |
Can you define a datastore in cognos?
How to pass parameter value into html design page? (That is YOU Create a html page and use that page in your cognos 8 report header.take <html item> my question is how to use parameter value in the html page .)
--------------what is MemberCaption?
HI,can one suggest best institute for cognos Training in Hyderabad
---------------Can we use more than 1 Fact table ?
how to Explain a complex report at the time of interview ? please post the answer very urgent?
what is the difference between cognos8 fm and cognos reportnet fm?
Whrer u can save the Report net documentation in our local system?
Can you define query studio?
actually 2 members working in same module.at a time is possible to work on same module? i add some tables,another person also add some tables how the synchronization betn the two in same module? pls ans me and expain to me.....
what is dash board?
. how will we hide the “report title ” in pdf format, but title should be remain unchanged in html format.