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.
| Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
-----------------What is Determination Model?
What you mean by drill across?
What are products of cognos?
How can we Maintain the Cube Security by Category level and Dimension level ?
Why need staging area database for dwh?
What is the diff between the following Report output-- HTML O/P, PDF O/P, EXCEL 2000 and EXCEL 2003 of report outputs? Listout main differences?
What is the difference between a cascading report and drill through report?
What do you mean by drill across?
What do you mean by drill through report?
What are the themes in a data warehouse?
------------------What is Inline Query?
how can you get the errors in job? when loops are araised we get error?
What is the advantage of using shortcuts?
What is defined as Query studio?
Define report item?