how to create calculate column in report studio
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 |
What is the difference between a cascading report and drill through report?
How create measures and dimensions?
In Drill through, Reports are executing successfully when rename & run the created reports? Pls tel me the reason?
how do you test reports in reportnet? what do you record in unit testing documents? pls give answer in detail......
how to handle multifact?
how u create cubes in ur project
How do we run stored procedure?
Can you explain the advantage of using shortcuts?
what is the difference between aggregation and role up aggregation ?
How to create users and permissions in cognos?
what is session parameters? what is use?
diff b/w dimension and regular dimension