Skip to Content
0
Former Member
Sep 07, 2005 at 01:40 AM

MDX - Key figure names

167 Views

Hello

I have an MDX query as follows:

SELECT

[30GZFANNZ5WLP3LYHMTBP4A8D].MEMBERS ON AXIS(0) ,

[2JF68MYX03Z8JQ5GSD54YJ4Y5].MEMBERS ON AXIS(1)

FROM [ZEMP_C05/ZEMP_C05_Q002]

SAP VARIABLES [ZVBUDEMP] INCLUDING [ZBUDEMPL].[00000011]

[ZVFBUDYR] INCLUDING [0FISCYEAR].[Z12005]

[ZVFPCTR] INCLUDING [0PROFIT_CTR].[1000Z1092N]

The key figures of this query are in structure 2JF68MYX03Z8JQ5GSD54YJ4Y5 as all key figures end up in a structure when you define a query.

I would like to know how to access the actual key figure name. That is how/where do I get ZSTDHR (the name of the infoobject) instead of 2JF68MYX03Z8JQ5GSD54YJ4Y5.2LJWDYXIDHPWOWC100UNSUS3X

I am executing this MDX statement within an ABAP program using the standard BAPI's

Thanks for any helpsomeone may be able to provide.

Cameron