Our architecht has selected to go with the DAtawarehouse database
being on another server and the reporsitory being on the analyis
server.I wanted to know what implications this would have when we have
large cube sizes of about 20 million rows and we have to get the data
from another server to process the cubes.Also If we have migrated the
repository would the data be available on the analysis server when
users query the server?


Thanks in anticipation.


Ajay

I've used an Oracle server as the source data and still seen incredibly fast
processing times compared to an Essbase server. Shouldn't be a noticeable
performance degradation.
"Ajay Garg" <ajayz90 (AT) hotmail (DOT) com> wrote