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 ?
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / 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 |
Answer / 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 |
How will u execute a stored procedute from a reportstudio
how to solve many -many relations ship in frame work manager?and how to avoid cartigen product in frame work manager?
what are determinants?
How can i approach to write Congnos Certification? What exactly should i do? Can anyone guide me plz?
cognos reportnet is molap or rolap ... somebady telling cognos reportnet is molap and other will be telling rolap ... i need extract answer
What are the differences between Cognos ReportNet 1.1, Cognos 8? and enhancements in cognos 8?
Is cognos models are version compatible?
can you apply grouping on crosstab?
What is TRAP in Framework manager?What's the use of TRAP? Where We are using this?
Explain the different stages in creating a report in cognos report net?
write a query to display to 10 max record from the employee table?
what are the joins present in reportnet?which is most widely used?