Using SAP_AGGREGATES_DEACTIVATE to deactivate a single aggregate

[Former Member]

Hello,

is there a way to use the report SAP_AGGREGATES_DEACTIVATE to deactivate just a single aggregate of a cube? As I know so far the aforementioned report deactivates all the aggregates of the cube specified.

I have no ABAP experience and I am totally new to ABAP. Has anyone experience concerning the modification of the report SAP_AGGREGATES_DEACTIVATE so that it is able to deactivate just a single aggregate?

My question also targets the case vice versa, that is activating/filling a single aggregate (possibly by using report SAP_AGGREGATES_ACTIVATE_FILL).

Thanks to any answers in advance!

Best regards,

Philipp

[Former Member · Accepted solution]

Hi,

Just curious, for filling up or deactivating a single aggregate why goto the effort of modifying the ABAP code when you can easily do it by going to the cube manage screen and doing it in less time from there. Anyway once you trigger the job, it'll be executing in the backend and you only need to check it in SM37.

Cheers,

Kedar

[Former Member · Accepted solution]

Hi Kedar,

the purpose of using that reports is to have them included in a process chain and thus to automate the deactivation and activation/filling of (single) aggregates.

Our department searches for a solution that covers the automatic deactivation/activation of aggregates through a process chain. But we do not want to deactivate/activate ALL aggregates; rather we'd like to have the opportunity to parameterize the selection of single aggregates.

Regards,

Philipp

[Former Member · Accepted solution]

Hi,

Ok got it. You can check to see if you can use the following function modules to do that :

RSDDK_AGGREGATES_FILL - Filling up aggregates

RSDDK_AGGREGATES_DEACTIVATE - Deactivating aggregates.

These FMs have input parameters for aggr id and cube id. So, you can also create variants for the same and then put them in process chains.

Cheers,

Kedar

[Former Member · Accepted solution]

Hi Kedar,

I will give that a try, sounds good!

Regards,

Philipp

[Former Member]

Hi,

SAP_AGGREGATES_ACTIVATE_FILL - to fill all the aggregates on a particular info cube.

SAP_AGGREGATES_DEACTIVATE - to deactivate all the aggregates on a particular cube.

RSDDK_AGGREGATE_DIRECT_FILL - fill an aggregate from a given aggregate or cube.