Skip to Content
author's profile photo
Former Member

MDX always returns Description

Hi,

I am using MDX statment to retrieve result. The statement is as follows:

SELECT NON EMPTY {[3A7PQ1PWB93XPLS4ENBRGNUGR].[75FX3HW29XHBF3ZD279PGG5UR]} ON COLUMNS,

NON EMPTY

{[0MATERIAL Z00KSTDHIERARCHY].LEVELS(01).MEMBERS} ON ROWS FROM [Z_PYMNTS/ZZZ_MDXTEST_QUERY] SAP VARIABLES [ZC_YRWK] INCLUDING [0CALWEEK].[200401] [ZC_CC] INCLUDING [ZC01CNTRF].[X]

The result always contains description of Hierarchy nodes. I want the result to show node value of hierarchy . How should we adjust the .MEMBERS Part above.

The attributes of 0material in the query is Key.

Best Regards,

Anil

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

1 Answer

  • Best Answer
    author's profile photo
    Former Member
    Posted on Feb 15, 2005 at 04:52 PM

    Hi,

    please add the properties:

    SELECT NON EMPTY {[3A7PQ1PWB93XPLS4ENBRGNUGR].[75FX3HW29XHBF3ZD279PGG5UR]} ON COLUMNS,

    NON EMPTY

    {[0MATERIAL Z00KSTDHIERARCHY].LEVELS(01).MEMBERS}

    properties

    [0MATERIAL].[20MATERIAL]

    ON AXIS(1) FROM [Z_PYMNTS/ZZZ_MDXTEST_QUERY] SAP VARIABLES [ZC_YRWK] INCLUDING [0CALWEEK].[200401] [ZC_CC] INCLUDING [ZC01CNTRF].[X]

    kind reg.

    Michael

    Add comment
    10|10000 characters needed characters exceeded