![]() |
||||||||||||
Go ![]() | New ![]() | Search ![]() | Notify ![]() | Tools ![]() | Reply ![]() | ![]() |
Member |
Hi, Is it possible to send complex MDX query to SAP BW. What we are hearing from SAP team that we should not send complex MDX query to SAP BW. If that is the case do we have answer for the below points • Do we have bestpratices for handling qureys(MDX) for SAP BW. • Do you people have faced any issues for geting huge amount of data from SAP BW.(for example more than 50K ) • Is SAP MDX qurey capable of handling some complex calculations. • How is the overall performance with SAP BW compared to other Datasourse ex. Oracle, DB2 Please do the needful. Thanks.This message has been edited. Last edited by: Kerry, WebFOCUS 7.6.4,7.6.9 OS: Windows XP HTML,EXCEL,PDF | ||
|
Member |
Hi JG, Thanks a lot for your quick response. your response is very helpful for us. We are generating the query using the WebFOCUS adapter only. When we run that query (from WebFOCUS) via SAP GUI,it is taking lot of memory(6GB out of 8GB total memory). If we do simple count or compute (like adding two feilds or doing percent calc), the query fails even for 600 records. Without any compute also, when we retreive more than 50,000 records (Not definite one ) , the query fails. This error is not consistent(same qurey sometimes returning someother time its failing). we can not able to trace it. Reports using SAP Cubes are still in development phase.We are afraid to move to production.(need to know how far its reliable ) Please give some suggestions to resolve it. Thanks. Devi 7.6.9 HTML EXL2K SAP BW.This message has been edited. Last edited by: Devi C, | |||
|
<JG> |
That implies that the WebFOCUS request is not passing a good MDX request and the vast majority of the processing is being done by WebFOCUS with much more data than you think. Monitor the WebFOCUS server console to see how many rows are actually coming back. AVOID defines against BW if at all possible. Try to screen your data so that the minimum number of rows are returned. If the Queries are being developed specifically for use by WebFOCUS try to make sure that the query contains the required rollups at the correct level and ONLY retrieve at the level required. If the queries are generic consider tailoring them specifically to your needs for WebFOCUS. WebFOCUS is not a replacement for BEX or a BW web Query, it is an alternative method allowing additional features and the ability to merge BW with other sources. It bites if you abuse it. | ||
|
Powered by Social Strata |
![]() | Please Wait. Your request is being processed... |
|