Hello everybody,
I have the following type of report in Report Studio.
It's very simple - just a List and Chart with Date and DataItem1 measure.
(http://stancho.com/cognos/reportstudio.jpg)
The Chart and the list are using the SAME query.
I'm just showing the data in two different ways (in List and in Chart).
When I run the report I have the following result:
(http://stancho.com/cognos/run.jpg)
No data is shown in the chart!
DataItem1 is something like:
total([ds].[data1]) / [ds].[data2]
Aggregate Function: None
Rollup Aggregate Function: None
I need these properties set to None because the formula for DataItem1 is more complex (total([ds].[data1]) / [ds].[data2])...
I tried to duplicate the query and set a different query to the chart - the same happens.
The problem happens when using chart! I tried with different charts but still no data...
If I change "Aggregate Function" and "Rollup Aggregate Function" properties to Automatic I have some data
in the chart but it's of course wrong because this makes the formula for DataItem1 wrong
Do you have any ideas?
Thanks and Regards,
Stancho
Hi Stancho
The reason that your chart is empty is because no aggregation has been applied to 'Data Item1'.
Either have your aggregation like this:
Aggregate Function: Automatic
Rollup Aggregate Function: Automatic
This may change the value of your total then u may need to change your Aggregate functions to:
Aggregate Function: Automatic
Rollup Aggregate Function: Summarize
In my experience this is an aggregation issue so some playing around with the aggregate values will solve the issue.
Hope this helps
Abu
Hi Abu,
thanks a lot for you quick answer!
But why is it working in List with aggregate = none (the same report).
What is the differences between List and Chart in this case?
I played with the aggregate properties.
If I changed them to auto/auto or auto/summarize I get data shown in the
chart but it is invalid. It is also invalid in the List report (the same data).
That happens because the aggregate properties change my aggregation.
I want to have total([ds].[data1]) / [ds].[data2].
But it is changed to total(total([ds].[data1]) / [ds].[data2]) ( for every single value...).
BR,
Stancho
Abu,
thanks again a lot!
If i change the aggregation properties to:
Maximum/Minimum...
Automatic
it is working because I have only one value and it is a maximum and a minimum and everything...
But it is strange what's the difference?