|
Home > Archive > MS SQL Server OLAP > September 2005 > Problem with Recursing too Many levels
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Problem with Recursing too Many levels
|
|
|
| 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
| |
| Dave Wickert [MSFT] 2005-09-21, 7:23 am |
| 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@online.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@intellimaxsol
utions.com> wrote in message
news:1127281667.726217.255130@z14g2000cwz.googlegroups.com...
> 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
>
| |
| Darren Gosbell 2005-09-21, 7:23 am |
| 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_do
t_com>
Blog: http://www.geekswithblogs.net/darrengosbell
In article <1127281667.726217.255130@z14g2000cwz.googlegroups.com>,
peterr@intellimaxsol
utions.com says...
> 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
>
>
|
|
|
|
|