Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Aggreagates from BI content

Hi All,

I would like to know how to use the aggregates from the business content. How do i know which aggregate is corresponding to which BI content infocube?

Regards,

Sofie

replied

Hi Sofie,

There are very limited Aggregates in Business Content. In my 7.4 system with BI_CONT release 7.57 SP06 I see approx. 65 Aggregates for Plant Maintenance, Production Planning, Quality Mangement and Technical Content. You can identify the respective InfoCube in the description.

Here are the tables where Aggregates' metadata are stored:

RSDDAGGRDIR - Directory of Aggregates

RSDDAGGRCOMP - Description of Aggregates

RSDDAGGRT - Text on Aggregates

RSDDAGGLT - Directory of the aggregates, texts

E.g. in table RSDDAGGRDIR you can find all Aggregates with Object Version 'D' (i.e. Business Content) and see to which InfoCube they are attached.

However, I agree with Frédéric's remark. Normally you will define Aggregates yourself based on actual performance needs and probably guided by BW Statistics.

Best regards,
Sander

2 View this answer in context

Helpful Answer

by
Not what you were looking for? View more on this topic or Ask a question