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

3. The vice president of sales has requested a graphical display of the same information provided in our last crosstab report (whatever I mentioned in above question) for an up coming presentation. We need to provide a chart report that shows which regions generate the most revenue and sales volume.

2682


How Metrics Studio is better than Report Studio?

2687


What you mean by drill across?

1075


What is difference between content store and content manager?

1030


What is the complex report you faced in real time?

2233


What is cognos powerhouse?

1082


How do we drill through from a powerplay cube to reportnet?\

2404


What you mean by drill across and what is the difference between drill through, drill across?

1085


What are the types of studio?

1204


Name the types of report?

1011


9. What was the most complex type of report you dealt with?

2283


Hi I need real time senarios and how to explain project in the interview pls let me know my email id m.n.prathyusha@gmail.com.Please help me out with this pls pls pls muthireddi@gmail.com

2197


What are the services provided in cognos 8?

1078


What r the names of the reports that you prepared?

1018


Define query studio?

1046