I have a hierarchy in my Tabular model as Manager > Supervisor > Employee > PayPeriod and I'm using this in my pivot table filter.
When I select the PayPeriod in the filter I'd like to get the parent items. I've tried using ([Attributes].[Hierarchy with Payroll Date].[PayrollDate].&["&$R$1&"T00:00:00].parent) in my CUBESET but what's happening is it's selecting the very first Employee that's a parent of that PayPeriod. How do I get the selected employee, supervisor, and manger from this filter?
I'm in the early learning stages of MDX so I apologize if this is a mundane question. I literally learned about .parent yesterday
When I select the PayPeriod in the filter I'd like to get the parent items. I've tried using ([Attributes].[Hierarchy with Payroll Date].[PayrollDate].&["&$R$1&"T00:00:00].parent) in my CUBESET but what's happening is it's selecting the very first Employee that's a parent of that PayPeriod. How do I get the selected employee, supervisor, and manger from this filter?
I'm in the early learning stages of MDX so I apologize if this is a mundane question. I literally learned about .parent yesterday
