Hyperion Planning - Member UDA

gistfile1.sql

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