Interested to Buy Any Domain ? << Click Here >> for more details...
how to create calculate column in report studio
- 4 Answers
- 9114 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 |
Can you define pivot?
--------------How to do Report Testing in Reports?
How to give a securites in object level&datalevel&pakege lavel in frame work manager?
Explain informatica architecture?
if at all asked.wat is u r cube name?wat would be a appropriate answer? plz help me
Hi Friends,what are The Advantages In Cognos 10 Compared To Cognos 8.4?Enhancements in Cognos 10? Please Ans Me Pls
What is the use of powerplay web viewer in cognos?
Please Answer this Questions: 1.In FWM We have to create Hierarchies, Condition is we don't know the correct levels in the Hierarchies, in this case how can we find out the levels (year->Quarters->month->day)in data? 2. In FWM Standalone Filter is for Reusable purpose & Embedded Filter we cant resuse.but is this possible to convert the Embedded filter to standalone filter? 3.What are the differences between Relational Database Model & Multi Dimensional Database? 4.In Drill Down/ Drill Up, How to specify the limits for example in a report there is 6 Drill down is possible, but i want only 3 Drill downs, the report should not allow 4 Th Drill Down.How to make this ? 4. What are the limitations in Select and Search Prompt ?
suppose if u r report having 1000 tables i want to dispaly alternate rows means 1,3,... how we specify that pleaes ans me
What are the differences between Cognos 8 and Cognos 7.x version?
1.Can we use 2 packages in report studio at a time is there any alternative for this? 2. What are Star Dimensions and Star Facts? 3.What are dimensions and facts in project ? 4.What is difference between 3 NF and Star Schema ? 5. What Is Data Modelling? 6. How much time do u need to create a report ,if u have four dimensions and 1 fact ? 7. How do u create a Model ? 8. How do u connect a Parameter in a list ,such a way it has to show relative objects in Cross tab ? 9. To display region list in separate pages ,how do u do ?
What is the Main Difference between Conditional Block and Render Variable in Cognos. Both are used for Condtional rendering.But what is the Main Diff?
Teradata 
