Skip to Content
0
May 10, 2010 at 05:31 AM

Size constraints of BW InfoProviders

17 Views

Hi,

While designing a new Data Model in BW 7.X- what is the size constraints of BW InfoProviders that needs to be considered ?

Suppose I have to bring historical data in BW of around 7 years, what is the size limitation in terms of -

a) Records in PSA table

b) Records in DSO

c) Records in InfoCube

d) Ratio of dimension table to fact table (in terms of Records count)

e) Query Throughput

f) Query Navigation Steps

Are there any standard statistics in terms of Memory allocation(GB) for the DSO, InfoCube etc or in total ?

Regards,

Amogh