what is the difference between list sequel and cross tab
sequel?
Answer Posted / ashok
As of My Assumption you are talking about the sql's generated for Lists and Crostabs.
Here is the answer
List: List SQL gives us the detail kind of Information in the Query
Crostab: Crosstab SQL gives us the Summary Kind of information for the intersection of rows and Colums.
| Is This Answer Correct ? | 0 Yes | 3 No |
Post New Answer View All Answers
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.
How to apply securities for reports in cognos connection?
What is the metric store database?
What is model filter?
how many numbers of cubes can we create on a single model? How can we navigate between those cubes?
3. The vice president of sales has requested a graphical display of the same information provided in our last crosstab report (whatever I mentioned in above question) for an up coming presentation. We need to provide a chart report that shows which regions generate the most revenue and sales volume.
Can you explain dynamic query mode?
what is stitch query in reportnet?
What is the advantage of using shortcuts?
1. We have been asked to add summary information to sales reprasentatives performance report. The report needs to be grouped by country and city to compare performance between areas Also we need to include revenue totals for each city and each country.
Can you define slice?
What is the function of model design accelerator?
is cognos 7 is better than cognos 8
How create measures and demensions?
What are all the different types of prompt in cognos?