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.