Get hierarchies valuesName mdx -


i created hierarchies photo below:

http://i.stack.imgur.com/eroxq.png

on mdx query

select [accsetting].[usern].[usern] on 1 [olap_report] [accsetting].[agid].[115] 

this query return usern children of agid 115. want return usern of agid =115?

think understand - name is property of member.

create custom measure returns property.

with    member [measures].[namecolumn]     [accsetting].[agid].currentmember.member_name   member [measures].[namecolumn2]     [accsetting].[agid].currentmember.name select   {    [measures].[namecolumn]   ,[measures].[namecolumn2]   } on 0,   [accsetting].[agid].[115] on 1 [olap_report] 

reference msdn: https://msdn.microsoft.com/en-us/library/ms145583.aspx


edit

first check member exists:

select   {     [measures].[<add measure here>],     [measures].[<add measure here>]   } on 0,   {    [accsetting].[agid].[115],    [accsetting].[agid].[113]   } on 1 [olap_report] 

Comments