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
Post a Comment