Master data performance

Hi Gurus,

I have some concerns with Data Modeling a master data Infoobject into an Infocube. The master data object will have hundreds of millions of rows. It is for my realignment process that will have ship-to/material, so I really have no choice about the number of records I need to store.

Does anybody have any data that can support the general experience in terms of performance of :

a) adding records to the MD object and

b) querying the Cube?

Shall I store the MD object as a line-item dimension for better query performance?

Regards,

Alex