Hi,
I have the classic "Inventory Problem" and have tried the various
recursive approaches to find the last balance.

I keep getting "internal errors". I have also seen a recent post by
Mosha, that identifies a problem with SP2 whereby if something
recurses more than 30 times, an internal error occurs.

Two questions:

1) Is recursion the best way to handle this if i have to recurse
possible hundreds of times?
2) If not how else can I do this - efficiently?

I could force a balance say every six months and avoid the 30 limit but
I'd rather not.

Many thanks

No real magic here. Getting a generic solution is hard.
This is why AS2K5 does it natively. There is a new aggregation function
called "LastNonEmptyChild" which does exactly what you are looking for.
Unfortunately it isn't available in AS2K -- it is a new AS2K5 feature.
--
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.


"Peter" <peterr (AT) intellimaxsolutions (DOT) com> wrote

Mosha's article also said that this issue was fixed in SP3 and above.
Would this not be an incentive to upgrade to the latest SP?

--
Regards
Darren Gosbell [MCSD]
<dgosbell_at_yahoo_dot_com>
Blog: http://www.geekswithblogs.net/darrengosbell

In article <1127281667.726217.255130 (AT) z14g2000cwz (DOT) googlegroups.com>,
peterr (AT) intellimaxsolutions (DOT) com says...