Interested to Buy Any Domain ? << Click Here >> for more details...
What is diffence between query calculation and layout
calculation?
- 4 Answers
- 23015 Views
- I also Faced
- E-Mail Answers
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 |
What is Index?
what is the difference between application based and web based in cognos?can you please give a example from out of EP 7 series and 8 series?genrel exampel please?
Explain the characteristics of cognos?
Explain the workflow of your current project from end to end?what is the steps?
2 Answers Accenture, Cap Gemini, Cognizant, HCL, IBM, Infosys, Nokia,
Cognos TM1 1. What are the different windows in Turbo Integrator? 2. What is the use of advanced window in Turbo Integrator? 3. What is TM1 Workflow. How do you create a process in that? 4. Where is Portlet used. What are differnt windows in portlet. How can you access TM1 web from portlet? Cognos 8. 1. What is Drill-on? 2.How do you implement row level security in Framework Manager? 3. How do you create tree prompt?
How can I change reports to another package???
What are all the types of indexes in Cognos?
can anyone provide link to download cognos 7.2 version for download along wiht installation and configuration steps tx in advance
Can you define dimension?
Please answer me the below questions, It's really urgent, and ur help would be appreciated. 1. What is looping in FM? How do u control it 2. How do u create IQDs in FM? Explain 3. What are the diff u noticed between Cognos 8.2 and Cognos 8.4 4. Can we use cube as a data source? How 5. How do u connect ur database in FM? do u connect directly 6. What's the structure of your database? Say u use Oracle 7. Did you use tables or views to bring the data from your DB 8. Does the dimensions of analysis studio have hierarchy? 9. Did you create any dashboards? How u created, explain
Hi all, I have a list report with Country, City & Revenue. In the run time i want to hide the particular column. I have tried using Java script but i didn't get any out comes. Please any one share steps for me....
what is the difference between native sql and cognos sql?
Teradata 
