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 |
Cleared COG-112 with 100% score today. What next certification should i go for?
Looking for IBM COGNOS Certification C1000-065 , C2020-605 , C2090-621 , C2090-623 Dumps?
what use of surgate key in project
if there are list,crosstab,chart how can you apply a single filter to all object?
What is Performance Tunning Test?
Can you explain new content durability?
What is Dynamic Grouping? what is diff between grouping n levelspan?
if a page have 3different layouts(list,crosstab,chart)can you show the 3 leyouts in 3 different formates (pdf,excel,csv)?
i'm searching on cognos..i want to know real time scenarios..persons having real time exp or undertaking trainings or who searching on cognos...can send me the details...for proper guidence..for project and interview preparation..pls help me out..my mail-id is ammu2india@gmail.com..hope u will respond as soon as possible..thanks..
What is looping and how to avoid it in framework manager?
Explain what is the difference between microstrategy and cognos reporting tool?
How to do Performence Tunning in Cognos Reports?