What is diffence between query calculation and layout
calculation?

Answers were Sorted based on User's Feedback



What is diffence between query calculation and layout calculation?..

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

What is diffence between query calculation and layout calculation?..

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

What is diffence between query calculation and layout calculation?..

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

What is diffence between query calculation and layout calculation?..

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

Post New Answer

More Cognos Interview Questions

What is meant by report studio short cut?

2 Answers  


how many facts&dimensions tables in a sales project?can any body name those dimensions and fact tables please

6 Answers   TCS,


Hi all... how can we publish packages using bmp scripts to Path:Public Folder Packages Folder

0 Answers   IBM,


can you tell me what are the dimension tables are used in project

0 Answers   GalaxE,


what is the security module used in cognos?

2 Answers   Cognos, IBM,


how many types of keys are there i.e primary key and foreign key etc..?

2 Answers   IBM,


How do you create IQD in FWM? Pls, give the procedure with an example. I told him that we could create using Native SQL method in FWM; it is correct or do you do another method there?

4 Answers  


Explain the difference between native sql and cognos sql?

0 Answers  


how to improve performance in report studio level

1 Answers   Wipro,


In my Report C-id c-name Revenue are the query items I need to display the report has Alternative colors for rows and Revenue >=1000 has display in another color? i.e Both c-id,c-name are applying the alternative color(red,yellow) condition and revenue (blue) u think..How its possible? Iam doing for alternative colors i defined Two dataitems as running-count and Mod... and next in Boolean varaible define as [Query1].[Data Item2] = 1 or 0 and [Query1].[Revenue]>=1000 as like this (it's correct or not) and define in condition explorer yes and no purpose two colors(here how to define 4 revenue color) By selecting the list columns body style its applying only the Body and run report it working only for alternative colors Next i defined by using same Boolean condition for revenue like this. For selecting only the Revenue Body and define as yes 4 one color and no for another color? But here it the revenue column also applying only the alternative color condition and it's taking the >=1000 condition... So,i need to display 2 columns have alternative colors and 3rd column >=1000 cell have another color any body pls give me the replay/answer in step wise..... Thank u Basha

0 Answers   TCS,


what are the names of the reports that you prepared?

0 Answers   IBM,


what was the actual purpose of portfolio in cognos ?

1 Answers  


Categories