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
faq's on cognos
What are the different types of important services used in cognos?
what are slowly changing dimensions? Why we are used scd?
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.
Write various indexes used in cognos?
What is the enterprise class platform architecture of cognos 8?
what are the filters in framework manager and report studio?
What are the steps to import the two data sources in framework manager?
how to create cubes in transformer ?
What is the difference between the content store and content manager?
What are all the different types of prompt in cognos?
What is the deployment requirements used in cognos?
What are the two types of framework manager?
how to create measures and dimensions?
What is the difference between a cascading report and drillthru report? Why do we go for drill thru report?