Interested to Buy Any Domain ? << Click Here >> for more details...
how to create calculate column in report studio
- 4 Answers
- 8967 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 |
How to pass parameter value into html design page?
what are the tabs in cognos ?
How Metrics Studio is better than Report Studio?
When we deploy the report to live the client get the data error how can we resolve that
What is Regular Dimension and Measure Dimensions and Diff b/w them ?
explain project, package ,model , modelers.........and differences b/w them?
HOW MANY LEVELS CAN BE USED IN DRILL THROUGH REPORTS
5 Answers IBM, Virtusa, Wipro,
What is main difference mapplets and mapping?
Can any one give the example for slicing and dicing of data ?(with simple query)
-----------Diff b/W Aggregate Function and Rollup Aggrigate Function?
A product manager is analysing the sales made for each product, he has requested a report containing data for specific products. To do this we will create a report that includes a prompt page that filters on specific products within specific product subcategory and category.
What is Outerjoin?
Teradata 
