It is possible to give 2 query items has measures in cross
tab?for ex:row as products,column as year and measure as
revenue,sales year....like that.It is possible r not ?If it's
possible pls tel me the process....
Answer Posted / rao
Yes it is possible, we can drop many measures in cross as many we want.
For this, you can drop revenue under year and after this you can drop sales (2nd measure) on right side or left side of revenue when black cursor blinks.
you can drop other measures also in this way.
Hopes it will help.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
tell me two or three issues from client side and how to solve those issues?
What is cognos reporting tool?
What are the two types of framework manager?
----------------Diff b/w Dimensional modeling and Relational modeling?
Which studio is used to create reports?
What is Bitmap Index?
Can you define drill across?
I have 7500 rows. I need all rows in single reports. Which type of prompt we have used retrieving all rows and show in a report? We have dynamical queries q1, q2, q3, q4, q5. If customer selects the particular, query that only show in execution report. In case it may more then one, how do you execute the particular query item in report page? What are the difference bt OLDP and OLAP?
I have two queries in first query i have to show all values,in second query i have to show 3 values and want to hide 3 values what prompt ur going to use, why that prompt
What is called materialized view?
What do you understand by the term 'aggregate advisor?'
What is the difference between ‘macro’ and ‘prompt?
How to limit the cut,copy and paste operations for an user in reportlevel? Can anyone please send me the steps as i am new to cognos?
write a query to display the departments with no employee?
Can you define bitmap index?