Problems using the SAP OLE DB for OLAP Provider to access BW data
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