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
How to do Performence Tunning in Cognos Reports?
What are all the types of gateway used in Cognos?
how you provide security to reports? How you provide security to packages ?
What you mean by drill across and what is the difference between drill through, drill across?
Can you define snapshot?
I have ten columns that needs to be totalled... but some columns are empty...how do i get sum all the columns even if sum are empty? Can i get a total of the rows instead of columns? if yes, what is the function to be used?
1.WHAT IS XML SPECIFICATION WHAT IS PURPOSE,WHERE YOU ARE GOING TO USE.2 DIFFERENCE BETWEEN RENDER VARIABLE AND CONDITIONAL BLOCK.3.WHAT IS LINK AND SEGMENT.4.WHAT IS CONDITIONAL LAYOUT.5. DIFFERENCE BETWEEN DETAIL FILTER AND SUMMERY FILTER AND HOW YOU ARE GOING DEFINE IN SQL (DETAIL AND SUMMARY FILTER ).. WELL THESE QUESTION I BEEN FACED IN IBM COULD SOMEBODY GET SOLUTIONS PLZ..THANKS IN ADVANCE
how you migrate reports to cognos 8 from previous versions?
1. Explain your project.
----------------Diff b/w Dimensional modeling and Relational modeling?
What do you understand by user class in cognos?
Can you explain a cognos controller?
Define the slice and dice?
What are the types of security?
We can use a calculated field to dynamically create the burst recipients in Cognos 8. Can we do the same in Cognos ReportNet 1.1?