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 / jegadeesh j
Hi,
If you need the expression to be used by multiple reports,
then you can go for Derived queryitem in Model level in
Frame work manager.
If you need that derivation only in that Report, then
better you can do the expression for the derived queryitem
in report level.
Regards,
JJ
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What are the batches and it’s details?
What do you understand by the term 'aggregate advisor?'
What is called Cognos powerplay?
What is Fullouterjoin?
Hi.. friends, dis Bhaskar p.if any of u having realtime scenerios.. plz send to me.. my mailid s bhaskarparitala.rao@gmail.com send ASAP.. waiting for reply..
What are the components used in web tier?
How to generate the Catalog in Cognos? Basically all post describing generating the Catalog from cognos impromptu . Is there any way to generate the Catalog using Cognos Administration or Framework Manager?
What are cognos connection initial page components?
how to explain health care project and which reports we can create in health care doain?
What do you understand by the term 'model durability'?
how u burst the reports? if u r bursted reports is not reached to destination how u identify???
Can you define transformer?
----------------Diff b/w Dimensional modeling and Relational modeling?
what are the filters in framework manager and report studio?
A product manager is analysing the sales made for each product, he has requested a report containing data for specific products. To do this we will create a report that includes a prompt page that filters on specific products within specific product subcategory and category.