Is there a way to have each data element displayed on each row of the crosstab?
current output Jan-13 Feb-13 Mar-13
Hierarchy1 Hierarchy2 Hierarchy3 Hierarchy4 Asset Code Worker Gross Hours Gross Hours Gross Hours
ABC abc abc abc abc 123456 10.2 8.5 9.3
123457 10.2 8.5 9.3
def 123458 10.2 8.5 9.3
123459 10.2 8.5 9.3
desired output Jan-13 Feb-13 Mar-13
Hierarchy1 Hierarchy2 Hierarchy3 Hierarchy4 Asset Code Worker Gross Hours Gross Hours Gross Hours
ABC abc abc abc abc 123456 10.2 8.5 9.3
ABC abc abc abc abc 123457 10.2 8.5 9.3
ABC abc abc abc def 123458 10.2 8.5 9.3
ABC abc abc abc def 123459 10.2 8.5 9.3
Ended up dropping the concept of running the months out to the left and just put the months all in the same column in a list report.
Cognos 10.2 seems a little backward in terms of Crosstab functionality, documentation and ease of use. Aligned column headers for crosstabs are not there by default.
I have the feeling that other products are going to eat Cognos' lunch in this space. :o
After all it is not a far stretch of the imagination to think that the summarizing one set of data could turn that data into fodder for another reporting purpose in another application.
You can put a table with n columns and one row in the innermost row node, sort your data items by order in there, and remove them from the nesting nodes (While keeping the nodes themselves) to achieve this. If this is over dimensional, it would be better than a list. If over relational, a list would serve your purpose better.
Thank you, I will give it a try. :)