cancel
Showing results for 
Search instead for 
Did you mean: 

SAP BW OLE DB Provider

former_member569483
Discoverer
0 Kudos

Hi everybody,

Actually I read cubes using MDX queries via SAP BW OLE DB Provider from QlikView (BI suite), but I need to know if is possible to read master data via MDX and via OLE DB.

Has Anybody had a similar experience with this? Not from QlikView necesary...

Thanks and regards,

Ricardo Reaño

Accepted Solutions (0)

Answers (1)

Answers (1)

Henry_Banks
Product and Topic Expert
Product and Topic Expert
0 Kudos

Hi,

if you want to do a 'master data report'  with MDX universes,  just include the 'dimensions/characteristics' into the query panel of your reporting tool, WITHOUT any Measures included.

this means there will be no intersect on the crossjoin of the MDX query, and you will get a full scan of master data tables.

please note that the masterdata settings in the bex query are not surfaced by the MDX API - see limitations note 820925

regards,

H