I have a second hierarchy that is dependant on the first hierarchy. In
the first hierarchy there are 4 levels. In the second hierarchy I have
3 levels. What I want to do is grab a mix of level 3 and level 4
members from the first hierarchy and stick them at a level 3 in the
second hierarchy.

How do I set this up for the second hierarchy since it has to resolve
the aggregates first on the first hierarchy?

Come to SQL PASS in Dallas in 2 weeks.
http://www.sqlpass.org/events/summit05/index.cfm
http://ew.sqlpass.org/ew/pass/displa...&event_id=1251
I am giving a presentation on aggregation design with AS2K. It will be a
very interesting talk. One of the subjects will be how to do by-hand
aggregation design.
--
Dave Wickert [MSFT]
dwickert (AT) online (DOT) microsoft.com
Program Manager
BI Systems Team
SQL BI Product Unit (Analysis Services)
--
This posting is provided "AS IS" with no warranties, and confers no rights.


<paulp (AT) avanade (DOT) com> wrote

Cool! Thanks Dave for the invitation. I will make sure I attend.
So...how do I create these manual aggregations in AS2005? Is it the
"Calculate" in the calculation tab of the the cube?

I wish it was that easy. :-)
No, you have to alter the aggregation design using a XMLA script.
--
Dave Wickert [MSFT]
dwickert (AT) online (DOT) microsoft.com
Program Manager
BI Systems Team
SQL BI Product Unit (Analysis Services)
--
This posting is provided "AS IS" with no warranties, and confers no rights.


<paulp (AT) avanade (DOT) com> wrote