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.

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.

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.

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)

What are the types of studio present in Cognos?

0 Answers  

---

What is the difference between macros and prompt?

2 Answers   IBM,

---

Hi Experts, Can a single package be shared by multiple users?

3 Answers  

---

What are shortcuts? Where it can be used? What are the advantages?

0 Answers  

---

How to pass parameter value into html design page?

1 Answers  

---

What is the difference between a cascading report and drill through report?

0 Answers  

---

diff b/w dimension and regular dimension

1 Answers  

---

How can we Maintain the Cube Security by Category level and Dimension level ?

0 Answers  

---

what is the difference between cascading prompt and drill-thru

4 Answers  

---

How to use Cascade Macro in Report studio? Anybody know about Cascade Macro & and the procedure to use?

1 Answers   AIG, Niteo,

---

I have Date,product,Quantity_Sold columns and I want Product, MTD(month Till date),YTD(Year Till Date) as output. Can anyone help me with the logic in getting MTD i.e quantity sold from 1st of this month to till date (i.e. 01- 11-2013 to 26-11-2013) and YTD i.e QTD sold from 1st date of the year to till date(i.e. 01-01-2013 to 26-11-2013). Sample output model: Product MTD YTD

1 Answers   L&T,

---

hi, this is harish. i had finsihed cognos course recently.can some one help in the area of project explination, interview questions,real time scenarious....this is my maild id nanagupta907@gmail.com

0 Answers  

---