TM1-v952 - MDX issue with retrieving Alias/Attribute

[robertb]

Hi,

I am still learning MDX and i've got a problem with an Expression and DIMENSION PROPERTIES.
As stated in http://www.tm1forum.com/viewtopic.php?f=3&p=1417
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 all

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

[Marcus Scherer]

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