企业绩效管理网

 找回密码
 立即注册

QQ登录

只需一步,快速开始

查看: 463|回复: 1

TM1-v952 - MDX issue with retrieving Alias/Attribute

[复制链接]

86

主题

402

帖子

589

积分

高级会员

Rank: 4

积分
589
QQ
发表于 2014-3-16 05:57:01 | 显示全部楼层 |阅读模式
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

本帖子中包含更多资源

您需要 登录 才可以下载或查看,没有帐号?立即注册

x
回复

使用道具 举报

78

主题

397

帖子

582

积分

高级会员

Rank: 4

积分
582
QQ
发表于 2014-3-16 07:17:36 | 显示全部楼层
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
回复 支持 反对

使用道具 举报

您需要登录后才可以回帖 登录 | 立即注册

本版积分规则

QQ|手机版|小黑屋|企业绩效管理网 ( 京ICP备14007298号   

GMT+8, 2020-10-20 20:18 , Processed in 0.166895 second(s), 12 queries , Memcache On.

Powered by Discuz! X3.1 Licensed

© 2001-2013 Comsenz Inc.

快速回复 返回顶部 返回列表