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....
Answers were Sorted based on User's Feedback
Answer / naresh
Yes it is possible, drag and drop the measures what ever you want into under Year column. now it is working fine..
| Is This Answer Correct ? | 2 Yes | 0 No |
Answer / 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 |
Hi Techies, Need your help for achieving this requirement. We have got a requirement to display a report in a page which should diplay max 20 rows but if a report is having totally 17 rows then in the 1st page it has to display 15 rows(divisible by 5) and the other two rows should appear in the next page. Similarly, If a report is having 23 records then in the first page it should display 20 (divisible by 5) and on other page it should display 3 rows. Please advice!
What is catalog and types of catalogs in cagonos and which is better?
what is a box type in cognos? what is a stitch query? what are the services that run in background when cognos is running
my cient has reports in java and the dw mart is there already, whether you will suggest for Cognos reports ?
How can we do the unit testing?
How to Improve the Performance of the Report? i need this urgently .
What do you understand by the term 'model durability'?
i wanna some client names and project names in cognos? plz send cognos resumes(3+) exp plz plz plz help me??
Can you define materialized view?
what is the procedure for scheduling conditional rendering?
what is prompt types of prompt example briefly each types of product (eg:values, date,search,prompt etc.)
how the values be passed to prompts in report studio? when a data item is dragged n dropped in to report, after the default query generated first which sql will the query query hit for processing means (native or cognos)? plz answers to these questions?
3 Answers TCS, Thomson Reuters,