Interested to Buy Any Domain ? << Click Here >> for more details...
how to create calculate column in report studio
- 4 Answers
- 9177 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / krishna
Using query calculation we can creat new column
| Is This Answer Correct ? | 4 Yes | 1 No |
Answer / gopal
By Using Query Calculation.
Simply drag query calculation and write a Expression according to your requirement.which derives an additional information from datebase.
| Is This Answer Correct ? | 1 Yes | 0 No |
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 |
hi my name is siraj i want to know cognos queriy language
what is the use of layout calculation?
What is the usage propertys in Framework Manager?n Ie we set EMP ID as a Fact and what will happen?Actullay EMPID is a Identifier....
write the sql query to display 5th and 10th row in a table?
You get a parsing error when you run a report. What will be your first steps to resolve the error?
Can you define confirmed dimension?
------------------What is Inline Query?
What do you understand by user class in cognos?
what is the use of layout component reference
what is the difference between group and association?
explain how to create powerplay reports?
Hi Friends, What is the Max no.of rows in a report & a page? If we have Master, Detail Reports, I have define drill through, Requirement is When i run Master Report it should run in HTML, when i drill through to detailed report it should get into PDF is it Possible in Cognos? Thank You Kumar
Teradata 
