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
- 6935 Views
- I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
Please Answer this Questions: 1.In FWM We have to create Hierarchies, Condition is we don't know the correct levels in the Hierarchies, in this case how can we find out the levels (year->Quarters->month->day)in data? 2. In FWM Standalone Filter is for Reusable purpose & Embedded Filter we cant resuse.but is this possible to convert the Embedded filter to standalone filter? 3.What are the differences between Relational Database Model & Multi Dimensional Database? 4.In Drill Down/ Drill Up, How to specify the limits for example in a report there is 6 Drill down is possible, but i want only 3 Drill downs, the report should not allow 4 Th Drill Down.How to make this ? 4. What are the limitations in Select and Search Prompt ?
Can you define set to be cardinality?
what are the difficult problem are you involved in cognos report net and 8 and impromptu if any pls share with us
What is Additive function?
what is model and say about process how to create model and how to test model?
What is the difference between static and dynamic conditions?
Why cognos scenario is used?
how many notations are posible(cordinolity)are there in between two tables(one is fact and another is dimension)pls give me a example pls.
what are the dimensions that you have in your current project?list them?
Why is auto-regression used in forecasting used on cognos platform?
Can you define cognos decision stream?
What do you understand by ‘ibm predictive maintenance and quality’?
I have ten columns that needs to be totalled... but some columns are empty...how do i get sum all the columns even if sum are empty? Can i get a total of the rows instead of columns? if yes, what is the function to be used?
Can you define drill across?
what are all the versions of cognos and cognos8 as well as mention all the advantages nd disadvantages in cognos8 versions. any one plz answer this question.
