Hey all,

I am working on a solution in SSAS2005...

In the example I am working on I have created a sample cube. I am
being asked to use a dimension that is setup as follows:

Sales
---> Manager +
--->---> Sales Code +

---> Location ~
--->---> Sales Code (same name, different key) +

It is a similar setup to a shared members dimension in Essbase. I have
created the parent child dimension table and created unique keys for
the sales code level and shared the names, thus building the structure.
Now the problem is the fact table is only on one of the Sales
Codes...How do I create the custom rollup formula to have it so when i
drill down the Sales Code data from the manger branch is display under
the location branch.

Thanks!
D