Hi, I am a beginner to Business

[martynmac]

Hi,

I am a beginner to Business Objects so please have patience as this may be a very easy question for all the experts out there. I am currently writing a report that displays information at a weekly level. I have the following measures in the universe (amongst others):

% Calls answered within 15 Secs
% Calls answered outside 15 Secs

For each of the above measures, the percentage value is calculated using an @Select on other measure objects eg.

"@Select(Measures\Num Calls in Op Answered within SLA) / @Select(Measures\Total Number of Calls) * 100"

However, the underlying data the report is examining is stored at a daily level and there may be more than one occurrence of each day in the data. Therefore, when I try to summarise the data at a weekly level I get very high percentage figures like 1,236% for each week.

Is there any way I can accurately aggregate this daily data to a weekly level.

Thanks in advance,

martynmac

 

[blom0344]

Hello Martynmac,

I think this is a typical example when not to use calculations at universe level, but at report level instead.
If possible create an object "weeknr" and draw this in into the report along with the days and the measurements you want to use to get the percentages. Set the weeknr as a section , and you can do the aggregates on the measures within the table with measures. However do not use the measures as already calculated as percentages, but get them as counts and calculate percentages on the totals per week.

The mistake you are making now has to do with first applying percentages at daily level and THEN aggregating. Correct procedure is to first do the aggregation steps and finally calculating percentages. (adding percentages up gives no sensible result, hence the 1,236) T. Blom
Information analist
Shimano Europe
tbl@shimano-eu.com

 

[martynmac]

Thanks for the quick reply Blom0344, I understand where I am going wrong now.