Crosstab reports provide another perspective on the same data you see in the list report. It show information in a more compact form than in a grouped list.
They are dimensional objects that have row edges and column edges. Each edge is composed of a set of crosstab nodes. Each crosstab node contains the following:
A crosstab report shows a measure at the intersection of each row and column.
This is useful for showing more information in a smaller area.
For example, if a report shows Product line as columns, Country as rows, and Quantity as the measure, the value at the intersection of each column and row shows the quantity of units sold for that product line and that country.
Total )
Order year (Column )
—————————————————————————— Product Type(Rows) Revenue (Measure) (
on columns)
Product Line (Nested
Product Type
———————————————————————————————–
—-
Order year, order month Quantity (Measure ) (Nested on rows) (Total )
Product Type
Product Line(Total),
(Union on columns)
———————————————————————————————–
—–
Order Year, Order Method Revenue
(Union on rows) ( Measure)
Type between Order Year and Order Method
Frequently Asked Cognos Interview Questions & Answers
4
———————————————————————————–
1 , 2 5
3
Stay updated with our newsletter, packed with Tutorials, Interview Questions, How-to's, Tips & Tricks, Latest Trends & Updates, and more ➤ Straight to your inbox!
Name | Dates | |
---|---|---|
IBM Cognos Training | Jan 31 to Feb 15 | |
IBM Cognos Training | Feb 04 to Feb 19 | |
IBM Cognos Training | Feb 07 to Feb 22 | |
IBM Cognos Training | Feb 11 to Feb 26 |
Ravindra Savaram is a Content Lead at Mindmajix.com. His passion lies in writing articles on the most popular IT platforms including Machine learning, DevOps, Data Science, Artificial Intelligence, RPA, Deep Learning, and so on. You can stay up to date on all these technologies by following him on LinkedIn and Twitter.
1 /15
Copyright © 2013 - 2023 MindMajix Technologies