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 ?
Answer Posted / 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 |
Post New Answer View All Answers
Can you explain dynamic query mode?
Suppose you run a report with empty data, how will you inform the end user that it has no data while running the report in report studio? Is it possible, if so how?
Cognos Online Training will be provided. prior training with all real time aspects. Comprehensive training will be given in Datawarehousing concepts , cognos 8.4 and cognos 10 versions. Contact kris.cognos25@gmail.com
What are the considerations regarding performance kept in mind while setting up cognos?
can anyone provide link to download cognos 7.2 version for download along wiht installation and configuration steps tx in advance
What is Additive function?
What is the complex report you faced in real time?
What is called a slice?
what is model and say about process how to create model and how to test model?
Define cognos report net?
Can you define confirmed dimension?
What is the diff between cognos 8.1 & cognos 8.2 & cognos 8.3? Measn whet are the enhancements are added in new versions(8.2& 8.3)?
Name the types of gateway?
Can you define a query subject?
Write types of folders present in cognos?