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
how can you get the errors in job? when loops are araised we get error?
Explain the difference between native sql and cognos sql?
How create measures and demensions?
i have one file i saved in csv how can i take these file into framework manager
I have a reports on cognos ep7series version3 with database SQl2000.Now i am migrating database SQL2000 to SQL2005.Then What happens to cognos reports and also there is reports cubes then how can i handle this problem please give me step by step solution b'coz i am new to cognos ep7series
2. We have asked to create a repots showing sales by region in order to determine which regions are generating the most revenue and highest sales volume. The report needs to include the revenue and quantitiy sold of each subcategory with in category.
------------------What is Inline Query?
What is the enterprise class platform architecture of cognos 8?
What are the steps to import the two data sources in framework manager?
Write types of folders present in cognos?
What are the different types of reports present in cognos?
what is log in cognos?
What is difference between content store and content manager?
Can you define fan trap?
What are all the types of gateway used in Cognos?