Skip to Content
0
Former Member
Feb 26, 2004 at 05:45 PM

Problems using the SAP OLE DB for OLAP Provider to access BW data

312 Views

I'm using the SAP OLE DB for OLAP provider (MDRMSAP) to access BW data from a Windows platform. My MDX query will execute but I am not getting the results that I was expecting. My result set contains subtotals which I do not want. However, when I run the query using BEx the subtotals are not displayed.

For example:

My OLE DB for OLAP Output (this is what I don't want)-

Customer Product $

All All 1,000

Customer A All 1,000

All Product A 500

All Product B 500

My Output from BEx (which is what I want) -

Customer Product $

Customer A Product A 500

Customer A Product B 500

I'm wondering if I am not constructing my MDX query properly. Or, if there is a setting that I should change to get the SAP OLE DB for OLAP provider (MDRMSAP) to "flatten" the data properly.

Are there any examples (or How-To's) showing the use of the SAP OLE DB for OLAP provider in Visual Basic or any other scripting language?

Is there a reference for SAP's implementation of MDX (I haven't been able to find it on help.sap.com)?

Is there a way to see the MDX command that BEx is generating to execute my queries?

Ideally I would like to do the following:

1. Design the the BEx query that I need using the BEx query designer

2. Execute the query from my Windows platform using ADO / ADO-MD in Visual Basic via the SAP OLE DB for OLAP Provider.

3. Save the results into a file or table

I think I can do all of this if I can get the data "flattened" properly.

Thanks for your help,

Trent Andrews

htandrews@yahoo.com