You can translate the question and the replies:

SAP BW MDX Optimised Query

Hi, We currently have a base view on SAP BW, which includes a large number (30) of characteristics. The intention is to provide the view to users, who will then only select two or three characteristics for their report. The problem we have is the MDX that gets executed will always include all of the characteristics, regardless of the query selection. We have seen that in other sources, such as MSSQL, only the fields selected in a query, are requested from the Database. Is there a way to force the MDX that is sent to SAP BW, to only request the selected fields in a users query. At the moment we are experiencing timeouts and memory issues in SAP BW due to the way the MDX is generated. Thanks in advance for any help. Regards, Gary Elliott
19-02-2019 11:34:03 -0500

1 Answer

Hello, The "denodo-v70-update-20190205-beta" update was released this month. It includes the following enhancement that should address the behavior you are looking for: "Added support for projection punning of unused attributes when pushing down queries to SAP BW sources." This enhancement removes the attributes from the MDX delegated queries which are not projected in your query. This feature is currently only available in the beta update. The final update is planned to be rolled into the update for general availability sometime in March. Hope this helps.
Denodo Team
22-02-2019 14:49:25 -0500
You must sign in to add an answer. If you do not have an account, you can register here