Skip to Content

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

How does InfoCube deletion mode affect loading performance?

Hi all

we have a scenario where it is necessary to regularly delete the cube before loading.

As we have 2 options for deleting: with or without dimension-tables: what is the more performant way in order to avoid extensive sid-ding the next time the infocube is been loaded?

Normally, I'd expect the variant with only the fact-table to be more efficient as dims are already generated..

But what^s about the "unused" data: it will remain in the dimension-tables then for every time?

And apart from that: if the dimensions are not buffered, will the option "only fact table" really be an advantage?

So, where should the decision be based on?



Former Member

Helpful Answer

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