on 07-16-2013 6:38 PM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.