after creation of aggregates , how do we know that...

Former Member · ‎02-03-2012

best cases for creating aggregates

aggregates advantages

Please search the forum before posting a thread

Edited by: Pravender on Feb 4, 2012 10:59 AM

Former Member · ‎02-04-2012

try to execute the query in RSRT..

see

Former Member · ‎02-03-2012

Hi

You check the performance by running the query again. below link will give all the performance improvements need to take care in BI system

Regards,

Venkatesh

Former Member · ‎02-03-2012

Hi,

If you created and filled aggregates, but are unsure as to whether it makes sense to have a

particular aggregate, then you can switch off the aggregate in the aggregate maintenance

(select aggregate: Aggregate > Switch On/Off). With aggregates that are switched off you see

a gray light in place of a green one. The effect of this is that the aggregate is no longer used

by queries. Aggregates that are switched off, however, are still kept consistent. They can thus

be used again directly as and when they are switched back on again. The advantage over

deactivating or deleting is that the aggregate must not be refilled again, and switching off is

thus particularly well suited to simple testing. As described in the previous section, you can

now execute a query or trace which would really use the aggregate. Compare the time that is

required by the database to the time that is required by the query using the aggregate. If the

query is not considerably slower then you can deactivate or delete the aggregate.

Please go through below document

after creation of aggregates , how do we know that aggregate working proper