使用SQL语句查看 Hyperion Planning 维度成员的UDA

使用以下语句，可以查询某个维度下成员的UDA属性：

select

O.Object_Name as Name,

OA.OBJECT_NAME as Alias,

U.UDA_VALUE as UDA

from hsp_member_to_uda M

inner join hsp_uda U

on M.UDA_ID=U.UDA_ID

inner join hsp_object O

on M.MEMBER_ID=O.OBJECT_ID

inner join hsp_alias A

on M.MEMBER_ID=A.MEMBER_ID

inner join hsp_object OA

on A.ALIAS_ID=OA.OBJECT_ID

inner join hsp_member D

on D.Member_Id=O.Object_Id

inner join hsp_object OD

on D.Dim_Id=OD.Object_Id

-- Specify Dimension

where OD.OBJECT_NAME='Entity'

order by O.Object_Name

显示效果如下图所示：