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 defined as Query studio?
how the values be passed to prompts in report studio? when a data item is dragged n dropped in to report, after the default query generated first which sql will the query query hit for processing means (native or cognos)? plz answers to these questions?
3 Answers TCS, Thomson Reuters,
what is the difference between aggregation and role up aggregation ?
if at all asked.wat is u r cube name?wat would be a appropriate answer? plz help me
Define the slice and dice?
Write types of folders present in cognos?
Can you please tell me the limitation of Excel file when exporting from report to Excel? I can export to HTML and PDF but I can't export to Excel. The report is more than 13000 rows. When exporting to Excel, system can view it. After that, I save the report to an Excel file. The size of Excel file is more than 11 MB. But I can't view this file by Excel. Please help me to solve this problem. Thanks!
what is materialised view? why we use it in data warehousing?
What is difference between primary key and unique key constraints?
What do you mean by Drill down and Drill Up?
What are all types of Batches?
In how many ways we can apply the security to a cube in Transformer? Explain?