Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 6930 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 |
What is main difference mapplets and mapping?
difference between impromptu and cognos8
Write some methods to apply securities in framework manager model?
For example I developed some reports on employee package now I have to develop same reports to another package.How can I change reports to another package?
When we use consume in cognos?
Wht is difference between content store and content manager?
2 Answers Satyam, Tech Mahindra,
Hi all... how can we publish packages using bmp scripts to Path:Public Folder Packages Folder
I have four region(Us, Uk, Canada, Europe) in my value prompt. Along with this I want new prompt called All. Once I click on All it should display all regions data. How can I achieve this ?
How to deploy from one server to another server?
How many number of cubes can we create on a single model? How can we navigate between those cubes?
how to create measures and dimensions?
Hi, I am Searching on Cognos 10, If any experienced person can send out a project or explain a realtime scenario that would be very helpful for me. Please be kind towards me and help me in this regard. I am really finding difficult to find a person who can guide me in this feild. Your help will be highly appriciated. My email id is asimcognos10@gmail.com. Hope you will help....
Teradata 
