Topic
IC4NOTICE: developerWorks Community will be offline May 29-30, 2015 while we upgrade to the latest version of IBM Connections. For more information, read our upgrade FAQ.
1 reply Latest Post - ‏2012-10-08T00:44:28Z by SystemAdmin
Ratnalein
Ratnalein
5 Posts
ACCEPTED ANSWER

Pinned topic Report Studio: The meaning of "automatic" in aggregate function

‏2012-10-07T17:21:49Z |
Hallo everyone,

in the documentation of IBM Cognos Report Studio stated, that the automatic setting of aggregate function for a data element would mean, that Cognos will decide by itself -depending on the data type- which aggregation to be implemented.

My question:
What does the term "data type" mean?
Are there any differences if the data element is a list or a crosstab?
I tried to aggregate an "average" on a column in a list. At the beginning, it didnt give me the average. Until I change the setting of the aggregate function to "automatic". Why is it like that?

Thank you and regards,
Ratna
Updated on 2012-10-08T00:44:28Z at 2012-10-08T00:44:28Z by SystemAdmin
  • SystemAdmin
    SystemAdmin
    15496 Posts
    ACCEPTED ANSWER

    Re: Report Studio: The meaning of "automatic" in aggregate function

    ‏2012-10-08T00:44:28Z  in response to Ratnalein
    "data type" refers to a property of the column which defines the sort of information contained within the column. Examples of data types are:
    • integer
    • bigint
    • decimal
    • double
    • varchar
    • date

    Typically, numeric data types will be aggregated with a sum and other data types will be aggregated using a minimum for the groupings in your report. The application of these rules depends on the usage of the model item being set to Fact in the Framework Manager model. Attributes will all be aggregated with a minimum regardless of the data type. Query items defined as Identifiers will not be aggregated; they will be grouped.

    There should not be any difference if you use a list or a crosstab. However, there may be differences depending on where you put an item in a crosstab.

    As for your average calculation, I can't tell from your message how you have defined or used the calculation in your report. It would be helpful to provide some additional information. See the following link for some tips on providing this information:

    https://www.ibm.com/developerworks/forums/thread.jspa?threadID=391841