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 |
cognos reportnet is molap or rolap ... somebady telling cognos reportnet is molap and other will be telling rolap ... i need extract answer
can you tell me what are the dimension tables are used in project
Explain difference between powerplay transformer and power play reports?
what is the difference between java script and html in cognos?
Report studio has two SQL tabs one native SQL and another one cognos SQL which one is get more preference? which one we need to consider?
7 Answers Blue Cross Blue Shield Association, TCS,
suppose there are 15 countries like (US, UK, ENGLAND,INDIA,JAPAN.......)i want a value prompt in the report and this value prompt should contain groups like group1(US,UK,ENG), group2(INDIA,US,UK), group3 (ENG,JAPAN,INDIA)and in the value prompt the values should be group1,group2,group3 how can we do this?
Hi I have Most updated Cognos dumps like COG-112(ReportAuthor),COG-122(Admin),COG-132(Meta Data Modeller). 100%score Gurantee. If anyone intrested mail me on kris.bi121@gmail.com
How can I change reports to another package???
what is alias what is shortcut what ia alias shortcut and diff among them if u know explain clearly
What is Outerjoin?
how to Explain a complex report at the time of interview ? please post the answer very urgent?
-----------What is member Description?