I'm new to SSAS & would really appreciate any help!
we have an Employee dimension that contains oranizational structure & has parent-child relationship (employee_id as primary surrogate key & parent_id self referencing employee_id) as Employees hierarchy.
there's a number of linked fact tables that link back to dimEmployee.
here's the problem - when I use MS excel & pivot table & link employee id or name or any attributte of the dimEmployee to my fact tables everything is good, but when I use Employees hierarchy (so that it displays the tree on the left etc) then the linking isn't happening & instead I see only global total for each line.
how can I fix this?!
Thanks!
I'd like to know it too...
I had similar case where I had to add additional column for an operator (+/-) & use accounting intelligence & it did the trick for me.
No comments:
Post a Comment