MDX: UniqueName and FullName of member

the uniquename :

[work item history area].[parent_id].&[1323].datamember
[work item history area].[parent_id].&[1333]

how currentmember's full name mdx without use vba function? , think multi levels.

     
[work item history area].currentmember    should

[work item history area].[parent_id].[apple].[ipod]

how can write mdx fullname of currentmember ?

@ scenario, dis-care unique focus on readable.


thanks,
bob

hi bob,

try using:

[work item history area].[parent_id].currentmember.member_unique_name
[work item history area].[parent_id].currentmember.member_name
[work item history area].[parent_id].currentmember.member_value
[work item history area].[parent_id].currentmember.member_key
[work item history area].[parent_id].currentmember.member_caption

these "intrinsic member properties", , of them desribed in:

http://msdn.microsoft.com/en-us/library/ms145528.aspx

---

boyan penev --- http://www.bp-msbi.com

SQL Server  >  SQL Server Analysis Services