TM1-v952 - MDX issue with retrieving Alias/Attribute

hnhening

Hi,

I am still learning MDX and i've got a problem with an Expression and DIMENSION PROPERTIES.
As stated in
and checked with http://mdx.mosha.com/default.aspx
I want to use Dimension Properties to show labels/aliases instead of keys in column- and row-headers.
In fact TM1 parses the mdx code and displays the keys but it ignores my Dimension Properties.
Aliases and attributes are maintained.

Code: SELECT
  {
[fiscal-year].Members
}
  DIMENSION PROPERTIES MEMBER_CAPTION    /*parsed but ignored!*/
ON COLUMNS ,

NON EMPTY
    {       //start of row definition
      [consolidation-group].[M-EU].Children
    }
  DIMENSION PROPERTIES MEMBER_NAME  /*parsed but ignored!*/
ON ROWS

FROM [corporate-cons]
WHERE
  (
    [consolidation-unit].[M]
   ,[reporting-category].[AAA]
   ,[fiscal-year].[2011]
   ,[item].[0123]
  );


->How can i retrieve speaking names instead of the keys? (TM1 9.52)
Any suggestions will be appreciated.

Thanks in advance
Robert

cat-hao

Hi Robert,
I don't understand completely what you*re trying to do or expecting from MEMBER_.
[fiscal-year].Members will give you the Principal element names of the dimension elements.

Assuming you mention an alias and want to retrieve the principal element name (in this pdata example [ann茅e] is the french name (alias) for the [Year] element in dimension [month])

SELECT {[month].[ann茅e].children]} DIMENSION PROPERTIES MEMBER_CAPTION ON COLUMNS,
{[region].[Americas].children} DIMENSION PROPERTIES MEMBER_NAME ON ROWS
FROM SalesCube
WHERE ([actvsbud].[Budget], [model].[T Series], [account1].[Sales])

then labels will be:
                          1 Quarter        2 Quarter               3 Quarter              4 Quarter
North America        820276,7648        682765,5616        674946,0382        900200,7685
South America        64614,0362        50544,9995        51564,7855        70097,3488

HTH,

Marcus