Focal Point Banner


As of December 1, 2020, Focal Point is retired and repurposed as a reference repository. We value the wealth of knowledge that's been shared here over the years. You'll continue to have access to this treasure trove of knowledge, for search purposes only. Moving forward, myibi is our community platform to learn, share, and collaborate. We have the same Focal Point forum categories in myibi, so you can continue to have all new conversations there. If you need access to myibi, contact us at myibi@ibi.com and provide your corporate email address, company, and name.


Connect to myibi
Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [SHARING] WebFOCUS and SAP BW (MDX Query)

Read-Only Read-Only Topic
Go
Search
Notify
Tools
[SHARING] WebFOCUS and SAP BW (MDX Query)
 Login/Join
 
Member
posted
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
 
Posts: 18 | Registered: September 01, 2008Report This Post
<JG>
posted
You should not be sending MDX queries to SAP BW.
However if you mean the query generated by the WebFOCUS adapter that is a different thing.
You can see the MDX that is generated by turning on the client traces and if you are having a problem
you can paste this code into the MDXTEST function screen in SAP GUI to check what has been generated
works with WebFOCUS taken out of the equation.

There are a number of rules specific to cube processing in general principally to do with
how you navigate and what you select on

BW is not designed to be used as a datamart and you will have major performance problems trying to
retrieve thousands of rows. (BW has an inbuilt limit that prevents more than 1 million rows being processed)

Performance against SAP BW is atrocious when issuing complex requests when compared to relational DBMS
sources

From a documentation point of view most of what is available is either in the Adapter admin documentation
or in the devstudio online help under "SAP BW Adapter, reporting rules"
 
Report This Post
Member
posted Hide Post
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,
 
Posts: 18 | Registered: September 01, 2008Report This Post
<JG>
posted
quote:
6GB out of 8GB total memory


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.
 
Report This Post
  Powered by Social Strata  

Read-Only Read-Only Topic

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [SHARING] WebFOCUS and SAP BW (MDX Query)

Copyright © 1996-2020 Information Builders