Answer Posted / sreenivasulu pokuru

There are two ways to create a calculated data item.
1)By using a Query calculation object.
2)by using a data item in query explorer.

example:
i want calculate revenue with existing data items sales
and price.
revenue=sales*price
steps:
1)go to query explore
2) drag a query from tool box
3) add data items (sales,price) from datasources into query
4) drag a data item from toolbox
5)write an expression (sales * price)
6)rename as Revenue for that data item in properties pane.
7)drag those three values into report page.

if u have any queries send to my
mail:sreenivasulu.cognos@gmail.com

That's it.

Hi Buddies...i am lalitha. i am willing to appear for cognos bi-author certification. can anyone of you send me cognos dump. please please help me.

1894

---

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

1982

---

---------------Tell me about DWH Concepts?

2216

---

Explain what is the difference between native sql and cognos sql?

1049

---

I have two queries in first query i have to show all values,in second query i have to show 3 values and want to hide 3 values what prompt ur going to use, why that prompt

2321

---

Explain the difference between powerplay transformer and power play reports?

1074

---

How to join multiple db in catalog?

1062

---

What is the difference between a cascading report and drillthru report? Why do we go for drill thru report?

995

---

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

1115

---

can we insert all types of charts in a list report? what r the realtime prompts?

2259

---

What is an olap designer?

1014

---

What actually a project contains?

1150

---

Explain what is the main advantage of impromptu over cognos reportnet?

1087

---

my table having data like this year month revenue 2011 jan 100 2011 feb 200 2011 mar 150 like this i want My report 2011 jan 100 2011 feb 100+200=300 2011 mar 300+150=450 like this for this where we specify the condition how will specify? pls ans me pls...

4282

---

What do you understand by the term 'aggregate advisor?'

1010

---