Answer / pooja

Why do we need to do that? i mean why do we need to display
revenue of 2 years, when we are choosing a particular year
to display the value? What is the scenario?

Answer / nasa

scenario:

Display 2013 and 2014 revenue and compare that country wise?

report studio-> list-> drag and drop a country data item
from branch query subject

drag a QUERY CAL from tool box drop beside country column

Name: 2013_revenue
expression:
if(order_year=2013) then(sales.revenue)
else(0)

drag a QUERY CAL from tool box drop beside 2013_revenue
column

Name: 2014_revenue
expression:
if(order_year=2014) then(sales.revenue)
else(0)

drag a QUERY CAL from tool box drop beside 2014_revenue
column

Name: variance_between_2013 and 2014
expression:
2014_variance - 2013_variance

ok

save and run

Answer / uzval_vee

by using expressions, i mean by using conditional
constructs and thru graphs we can view the revenue and
caliculated data as well.

what is the difference between group span and level span

1 Answers   Satyam,

---

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

0 Answers   IBM,

---

difference between join and union in reportstudio?

2 Answers   IBM,

---

How to hide value prompt box and list when run report?

4 Answers   IBM,

---

in reportnet how u burst the reports for every 5th day, 10 th day, 15 th day, 20 th day

2 Answers   IBM, iFlex, iGate,

---

---

How is cognos model organization works?

0 Answers  

---

what is cardinality that you can give to employee and department query subjects in framework manager?

2 Answers   HCL,

---

What is the difference between static and dynamic conditions?

0 Answers  

---

wHAI IS THE DIFFERENCE BETWEEN LIST REPORT AND CROSSTAB REPORT?

7 Answers  

---

what is log in cognos?

0 Answers   IBM,

---

What are all types of Batches?

0 Answers  

---

How to pass multiple values from picklist prompt to sub report filter?

2 Answers   IBM, Infosys,

---