If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Nested Total line

Started by terry_stjean, 06 Apr 2010 01:34:12 PM

Previous topic - Next topic

terry_stjean

I have a report which has a nested level in the columns. The data source is a cube.
The report I am trying to develop looks like:
                                                        Jan     Feb    Mar   Apr ..............
Customer 1           Product 1                  xxx     xxx     xxx    xxx
                          Product 2                  xxx     xxx     xxx    xxx
                          Total Product            xxx     xxx     xxx    xxxx
Customer 2           Product 1                  xxx     xxx     xxx    xxx
                          Product 2                  xxx     xxx     xxx    xxx
                          Total Product            xxx     xxx     xxx    xxxx
Total Customer      Product 1                  xxx     xxx     xxx    xxx
                          Product 2                  xxx     xxx     xxx    xxx
My problem is with the Total Customer line.
I can add the Total Product line in the Product level.
I can get the Total Customer line working, however when I add the Products level in the Total Customer line, I get errors like "aggregate dataItem is not expected to nest non-measure.
This report also allow the user to drill down.
Any help would be great.

CognosPaul

With a crosstab like this I don't think you really need to use any aggregative functions.

Your crosstab should be set up like this:


Measure          | Months |
-----------------+--------+
Level   | Level  |  123   |
        | Measure|  123   |
--------+--------+--------+
Measure | Level  |  123   |
        | Measure|  123   |


Make sure the crosstab has the "Has Fact Cells" set to yes. Wherever you have Measure in the crosstab node simply change the source type to text and rename it.

Note this will only work if you're using a full level. If you want to use a set of members you should use total(currentMeasure within set [Set1])