Which is the recommended way to connect from Crystal to SAPBI, is it via MDx or BW drivers. We are seeing big difference in the performance,
1. MDx is performing pretty slowly as compared to BW.
2. BW doesnt rollup based on the select list, irrespective of the columns selected, the rowcounts are the same
I do understand that the MDx should be go-forward option, but I get into various perf issues and memory contention issues with it whereas BW works better on these conditions.
We use XIR2, sap integration kit, AIX 5.3
Any recommendation will be great.
Thanks in advance
Venkat