Draft:
- Install Fiddler on a client machine (http://www.fiddler2.com/fiddler2/)
- Open Fiddler and make sure it is capturing traffic;
- Open BPC Excel client and a report that you are experiencing performance issues;
- On your backend, open transaction ST12, select your BPC_SYSADMIN credentials as the username and check the option "with internal tables";
- Start the trace;
- Clear your Fiddler window;
- Run your report;
- Stop the ST12 trace and the Fiddler capturing;
From Fiddler, you should get a total runtime (which will include the network time). From the ST12 trace, you can see how much is being time is being spent on the DB and on ABAP code. Reducing the total ST12 time from your Fiddler time should give you the network time.