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 ?