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 / 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 |
Post New Answer View All Answers
Does anybody have the sample of delivery document of cognos, or provide some link of websites Thanks
When we save a report in report studio with what extn it save?
Can you explain cognos planning?
Define metrics studio?
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...
Can you define dimension?
5. Which type of report you build more, list, crosstab or chart and why?
can we insert all types of charts in a list report? what r the realtime prompts?
What is dtm?
--------------Diff b/w ODS and OLAP?
how to explain health care project and which reports we can create in health care doain?
how the values be passed to prompts in report studio? when a data item is dragged n dropped in to report, after the default query generated first which sql will the query query hit for processing means (native or cognos)? plz answers to these questions?
i have taken quantity on ANx-axis & months on y-axis(months r not in oreder )when i run the reoprt i need months in proper order .how can i do this ?
It is possible to test 2 query subjects at a time in CRN1.1 & C8 FWM?
If we are migrating lower version of Cognos reports (e.g. from Ver 7.0 to Cognos 8) then how we migrate Impromptu Catalog (ver 7.0) in Cognos 8? Do we create FM model for that? Please explain.