Aggregates

[Former Member]

Hi Gurus

How could we delete data from E fact table? If we deactivate the aggregates then does the E Fact table gets deleted the data.

Regards,

Charan.

[Former Member · Accepted solution]

Hi ....

A cube has 2 fact tables - E and F. When the requests in the cube are not compressed the data exists in the F fact table and when the requests are compressed the data lies in the E fact table.

Now, the compression can be done in two levels.........Aggregate level and Infocube level.......Only if you do the compression in the Infocube level then only data move from F fact table to the E fact table.....

When the requests are compressed all the request ids are lost (set to NULL) and you would not be able to select/delete the data by request id. The data in the E fact table is compressed and occupies lesser space than F fact table....

So, the fact is deletion of E fact table doesn't depend on Aggregates....To delete the data from the E fact table you have to delete the content of the cube......you can delete the records based on the requestid ........so either you have to go for a selective deletion ( If you know the selection criteris) otherwise delete the whole content of the cube.....

Regards,

Debjani....

[former_member181964]

Hi,

Once you compress the cube then the data will move from F fact table to E fact table. Aggregates and E fact table is different, so if you delete the data from cube then the data will be deleted in Cube. Don't delete if it is Production System.

Thanks

Surendra

[Former Member]

Thanks for the response.

So that means If I deactivate aggregates on cube then E fact table will not be cleared. I'm working on QA system.

Charan.

[Former Member]

HI,

If you deactivate the Aggregates then if you run the Query it will hit directly the Cube.If the Aggregates are in Active then first hits the aggregates....No effect to E fact table with Aggregates.

Thanks

[Former Member]

Hi,

Yes, you are right if you deactivate the aggregates the data from the E fact table will not get deleted.

Only the data from the Aggegate tables will get deleted , but the structure will remain.

Regards,

Debjani....