Aggregate or Aggregation

building reports webintelligence
1

I would like to know what this aggregate or aggregation word exactly means or define in a one or more example.

I have listen that it makes aggregated measure but how come it is in Bex or Webi.?

I have a first instinct on it having a function like sum or max

But these functions will give only one cell value…right? So how come aggregated measures have a full fledge column lenght values?

Any insight would be appreciated.

Regards
Rohit

rhtrules08 (BOB member since 2012-09-08)

2

That depends on what else is in the query. If the only thing in the query was a measure with a sum on it you’d get one row and one value. But if the query also contained a dimension like day of the week, you might expect to see seven values returned.

Nick Daniels :uk: (BOB member since 2002-08-15)

3

Thanks Nick for the reply

If we have dimension as days of week we will see values., so my questions are :-

  1. What is use of aggregated here.

2.If we dont have both aggregated on sum and only just one measure without this aggregation and no dimension…then how many cells will be their?

3.Can you please elaborate it much or anything more needed to learn understand this concept to fullest

Once again, thanks for your reply

Thanks
Rohit

rhtrules08 (BOB member since 2012-09-08)

4

Hi,

Where? In an SQL statement, in a Business Objects universe or in a report?

As many as there are records in a table that’s used in a query, minus those records that don’t satisfy condition(s) in the WHERE clause.

What is the level of your knowledge of the SQL language?

Marek Chladny :slovakia: (BOB member since 2003-11-27)

5

Hi Marek

  1. In business objects universe to be used in report

  2. I am asking after aggregation is in effect for no. of cells and withou aggregation in effect no. of cells

  3. I am a sort of fresher trying to learn it and always end up learning first few topics and then forgetting due to lack of its practice as i am on the SAP BO now and dont know how to learn exactly how to learn to rounding things around it asap

I hope above makes sense to you to answer perfectly.

Regards
Rohit

rhtrules08 (BOB member since 2012-09-08)

6

Hi,

The existance and the type of the SQL aggregation function (SUM, MAX, MIN, etc) in the select part of a measure definition defines how an SQL statement generated by WebI/DeskI will look like, whethere there will be the GROUP BY clause or not and what SQL aggregation function will be used.

The aggregation function in the tab Properties of a measure properties defines how a measure behaves / rolls up on a report level when a dimension is added/removed from a data block where the measure is used.

Marek Chladny :slovakia: (BOB member since 2003-11-27)