how to add a new query item by using 2 query subject?
For Ex: i want to create a revenue query item in products
query subject(revenue=Quantity*Unitprice).
Quantity is in products query subject & unit price in orders
query subject
it will be possible in report studio(perment/temporerally)
otherwise u have create in Freamework Manager...
pls any body knows explain /answer me ?
- 4 Answers
- 5700 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / pavan kumar
By Using Query Calculations we Add new Query Item. In New
Query Item Give Nmae as a "Revenue" After that in
expression def window write "Quantitiy*UnitPrice".See This
a Temporary Column.
| Is This Answer Correct ? | 2 Yes | 1 No |
Answer / balanandam
if u create Revenue column in fm as add new query item it can be reusable. otherwise u can create in report studio using query calculation available in tool box. but it can be used for only that report.
u can follow any of above as u r requirement.
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / jegadeesh j
Hi,
If you need the expression to be used by multiple reports,
then you can go for Derived queryitem in Model level in
Frame work manager.
If you need that derivation only in that Report, then
better you can do the expression for the derived queryitem
in report level.
Regards,
JJ
| Is This Answer Correct ? | 0 Yes | 0 No |
architecture of cognos8
What are all the types of report?
what is the difference between java script and html in cognos?
What are the steps to create DMR model in FM? Give me brienf discription as interview point of you?
example for generated prompt
How to create a dynamic column name in Cognos?
6 Answers Aditya Birla, Polaris,
I have a report with list and cross tab in same page,How do you restrict one user can see only the list and other user can see both?
These are few Interview questions i faced.I hope to get help here. 1.Can we convert a Crosstab to List? 2.How do you approach and who tells you what exactly the way report has to be developed so that i meets the client requirements? 3.Can we link the List and Chart thats created in the same report? 4.Where do you edit sql in cognos8 ? 5.What is the difference between native sql and oracle sql? 6.What is the difference between MOLAP and ROLAP? 7.What is the use of BI in datwarehousing? 8.What are set functions? 9.How do you test a report? 10.What are the variables you find in toolbox? 11.How many types of filters are there in cognos8? All the answers r welcomed .U can reach me at vinod.davala@gmail.com
Can any one help me about cubes in cognos.How to create the cubes and how to migrate from development to QA and also what is the procedure to refresh teh cubes.
What is Model Versioning or Versioning in Cognos Framework Manager?
Difference between cognos report net and cognos8
i thought to keep fake experience..as a fresher i can't enter..bcos there is a large gap after my graduation..4 years..any person who enter with fake exp describe how to attend the interview process..
Teradata 
