Skip to Content
0
Former Member
Oct 05, 2005 at 12:41 PM

Query Hierachies with MDX

14 Views

Hi colleagues,

currently I´m trying to execute MDX-Statements with a tool called TurboQueryLight.

I want to extract specific Hierachies out of the SAP BW and tried following Statements so far:

SELECT .MEMBERS ON COLUMNS,[PPROCTNTN].MEMBERS ON ROWS FROM SAP VARIABLES INCLUDING .[FDA44FDDE546E74C9217783AFB06AA5B]

SELECT .MEMBERS ON COLUMNS,[PPROCTNTN].MEMBERS ON ROWS FROM SAP VARIABLES INCLUDING .[CRM_40_KEYCAPS]

With both Statements I get ab Error like:

OLAP Data adapter error: Invalid MDX command with FDA44FDDE546E74C9217783AFB06AA5B (or CRM_40_KEYCAPS)

Any idea how to initialize the SAP VARIABLES coorectly to get a specific hierachie?

Your help in this will be much appreciated

Regards

S.Löffler