Please suggest me on the below case,
Currently my Cubes build using a pull and push method. The Dimensions are pulled into the cube from source(oracle) ,the pull takes about 40mins – 1hr using the EIS technology. The implementation we made was using single thread technology and hence is quite slow.
The new implementation of Essbase saw the introduction of multithread performance for EIS (As per Oracle rep). I would like to know if we can improve performance and reduce build times.
Please let me know about multithread concept in EIS and how to apply it? will it workout to reduce the build time?
Refer these two url
http://docs.oracle.com/cd/E40248_01/epm.1112/eis_sysadmin/frameset.htm?launch.html -> will help you find out using trace log file and why your ODBC pull is so slow to pull the dimension from oracle db
Also check if your have your server network spikes up when this dimension pull batch is being triggered