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 u will design the report if the objects are available
how to explain health care project and which reports we can create in health care doain?
What is the use of cognos decision stream?
How can we import Excel data in to FWM?Wt is mean by Ragged dimensions?where can we observe the Regular dimensions & measure dimensions?
How can we create a dynamic column name in cognos?
1)diff between shortcut-key and alias table? 2)what is unit testing? 3)what is scorecard?
Explain the characteristics of cognos?
What do you understand by the term 'model durability'?
What project,model,parameter maps,namespace and database definitions....... what these are all contains? what are differences b/w them?
What is meant by Reportstudio shortcut?
Can you define drill down and drill up?
1. Explain your project.
Hi experts,Recently I faced one questions in MNC,They having 4 tables in FM ..One fact table CALLING X, Remaining 3 tables are there not fact calling y,z etc...We want to join individually from X to Y..please suggest.
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.
Can you define transformer?