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 ?
- 4 Answers
- 5667 Views
- I also Faced
- E-Mail Answers
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 |
hi, i am searching job in cognos and datastage, does any can provide me the real time experieced scenerios and questions related to cognos and datastage projects, so if anyone provide me the documents related this can very helpful to me, my mail id is tchiru01@yahoo.com
What is Metrics designer?
What do you understand by user class in cognos?
if a page have 3different layouts(list,crosstab,chart)can you show the 3 leyouts in 3 different formates (pdf,excel,csv)?
Can we create reports using OLTP database?How?
Define catalog in cognos and write its various types?
What is meant by junk dimension?
What is the difference between group and associare?
What is Dynamic Grouping? what is diff between grouping n levelspan?
what is the meaning of aggregation and rollup aggregation? Difference between layout calculation and query calculation? How do you hide the rows that have null values? why we use query studio? what is the use of query studio compared to report studio?
What is model?
How can you schedule the report that it displays a day old data. (My answer was to create a view, but the lady wanted some other method).
Teradata 
