how to create calculate column in report studio

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


Please Help Members By Posting Answers For Below Questions

faq's on cognos

3832


What are the different types of important services used in cognos?

778


what are slowly changing dimensions? Why we are used scd?

807


A product manager is analysing the sales made for each product, he has requested a report containing data for specific products. To do this we will create a report that includes a prompt page that filters on specific products within specific product subcategory and category.

1808


Write various indexes used in cognos?

742


What is the enterprise class platform architecture of cognos 8?

804


what are the filters in framework manager and report studio?

791


What are the steps to import the two data sources in framework manager?

803


how to create cubes in transformer ?

835


What is the difference between the content store and content manager?

775


What are all the different types of prompt in cognos?

744


What is the deployment requirements used in cognos?

1425


What are the two types of framework manager?

888


how to create measures and dimensions?

807


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

724