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 / 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 |
Post New Answer View All Answers
how to create cubes in transformer ?
What are types of batch available in cognos?
What are the two types of framework manager?
Mention the difference between ‘macros’ and ‘prompt’?
Explain what is the difference between microstrategy and cognos reporting tool?
How to join multiple db in catalog?
Write some methods to apply securities in framework manager model?
What is the difference between Open Connection command ang Open Session Command?
What are the types of folder present in cognos?
hi all i am searching for cognos jobs pls inform about the jobs to:santosh.koora@gmail.com
What is a Folder?
what are the special features in cognos reportnet?
What is meant by junk dimension?
What is the use of report studio?
What are all the components of Report Studio?