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