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
What do you understand by the cognos?
what is power prompt in cognos ep7series?what is the use of this?
In my report i want display sales rep name, country ,city how to achieve this by using repeater table
What is the difference between a data mart and a data warehouse?
my table having data like this year month revenue 2011 jan 100 2011 feb 200 2011 mar 150 like this i want My report 2011 jan 100 2011 feb 100+200=300 2011 mar 300+150=450 like this for this where we specify the condition how will specify? pls ans me pls...
What is difference between page break and section report?
What is a Transformer?
How to publish a package by running Java Script?
What is meant by junk dimension?
What is dtm?
Give me any example of semi and non additive measures?
how u will design the report if the objects are available
What is difference between primary key and unique key constraints?
please can you give me some banking domine calculations developed in framework manager plzzzzz thank you.
All ready we have alias tables for modifications why we are using views if anybody this answer plz reply me