Hello experts,
We are running BPC 7.0 MS with SQL 2008. We have drill through capabilities in some applications and we run SSIS packages to bring data from Staging database to the bpc table (Both bpc and staging are in same server).
Now we are planning to bring BI 7.0 and upgrade to 7.5 MS for better drill through capabilities. I would appreciate if someone explain how the data flow happens in a similar environment (R/3 - BI and BPC 7.5 MS) I am looking in terms of how SSIS is setup and whether they use staging database for drill throughs.
I keep hearing about 7.5 MS with improved drill through features. Can someone shed light on that area as well.
Thanks in advance.
Mani