Parent-child hierarchy & fact data?

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.

Parameters to run different reports?

Is it possible to have a parameter to run different reports depending on what
the user select for the parameter?
For example I want to have Employee, Customers, Inventory, etc for the
report parameter. When the user clicks on Employee it will bring the
employee report with all the parameters needed for that report. If it's
possible, what's the syntax.It sounds more like you're wanting separate actions, that is different
elements on a page that hyperlink to different reports. Check out the
Action property of text boxes, for example. You can specify the various
parameters in the action. Does that do what you want?
--
Cheers,
'(' Jeff A. Stucker
\
Business Intelligence
www.criadvantage.com
---
"chang" <chang@.discussions.microsoft.com> wrote in message
news:467B6B2C-5D16-4107-B81C-BC4AC06E5711@.microsoft.com...
> Is it possible to have a parameter to run different reports depending on
> what
> the user select for the parameter?
> For example I want to have Employee, Customers, Inventory, etc for the
> report parameter. When the user clicks on Employee it will bring the
> employee report with all the parameters needed for that report. If it's
> possible, what's the syntax.|||Jeff, thanks for replying. It's not related to the Hyperlink action I think.
From my understanding of the Hyperlink Actioin, I can have a textbox jump to
a report, but is it possible to use that as a drop down box that has the name
of each report? Probably I can play with the Hyperlink Action and see if
this will work.
Thanks for the suggestion.
"Jeff A. Stucker" wrote:
> It sounds more like you're wanting separate actions, that is different
> elements on a page that hyperlink to different reports. Check out the
> Action property of text boxes, for example. You can specify the various
> parameters in the action. Does that do what you want?
> --
> Cheers,
> '(' Jeff A. Stucker
> \
> Business Intelligence
> www.criadvantage.com
> ---
> "chang" <chang@.discussions.microsoft.com> wrote in message
> news:467B6B2C-5D16-4107-B81C-BC4AC06E5711@.microsoft.com...
> > Is it possible to have a parameter to run different reports depending on
> > what
> > the user select for the parameter?
> >
> > For example I want to have Employee, Customers, Inventory, etc for the
> > report parameter. When the user clicks on Employee it will bring the
> > employee report with all the parameters needed for that report. If it's
> > possible, what's the syntax.
>
>