Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

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


Please Help Members By Posting Answers For Below Questions

What do you understand by the cognos?

977


what is power prompt in cognos ep7series?what is the use of this?

3689


In my report i want display sales rep name, country ,city how to achieve this by using repeater table

1986


What is the difference between a data mart and a data warehouse?

1044


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...

4223


What is difference between page break and section report?

1210


What is a Transformer?

1077


How to publish a package by running Java Script?

2089


What is meant by junk dimension?

1186


What is dtm?

1171


Give me any example of semi and non additive measures?

975


how u will design the report if the objects are available

2764


What is difference between primary key and unique key constraints?

992


please can you give me some banking domine calculations developed in framework manager plzzzzz thank you.

2194


All ready we have alias tables for modifications why we are using views if anybody this answer plz reply me

2095