mdx hierarchy return parent and child in query -
i have following query
with member [measures].[period key] axis(1).item(1).item(1).hierarchy.currentmember.uniquename member [measures].[year key] [dim date].[year].currentmember.uniquename select { [measures].[valuation] ,[measures].[period key] ,[measures].[year key] } on 0 ,( [dim date].[hierarchy].[quarter].allmembers ,[dim platform].[platform key].allmembers ) on 1 [cube];
i want year key return uniquename in hierarchy instead, want use in parameter. in form cause errors field definition expecting result in hierarchy form. possible?
assuming hierarchy year-semester-quarter-month-date, how using
[dim date].[hierarchy].currentmember.parent.parent.uniquename
if have year-quarter-month-date in place,
[dim date].[hierarchy].currentmember.parent.uniquename
what doing it's looking @ current quarter , returning it's corresponding year going in hierarchy tree using .parent
function.
Comments
Post a Comment