Post reply

System Error occured: Out Of Present Range

  • November 18, 2008 at 10:10 pm

    #154926

    Hi...

    when i ran this query,

    WITH MEMBER MEASURES.[%Screened3d] as

    ' SUM( FILTER([CandidateInfo].[DaysToScreening].CHILDREN,

    CINT([CandidateInfo].[DaysToScreening].CURRENTMEMBER.PROPERTIES("KEY")) <=30 ) ,measures.[VALUE])/ measures.[VALUE]',format_string = "#,##.00%"

    select {measures.[%Screened3d]} on columns,

    {[Time].[Month].&[200709]} on rows

    from [Assumption_Process_Performance]

    I got the error:

    #Error: Following System Error occured: Out Of Present Range

    Can anyone help me in solving this...??

    Regards,

  • November 20, 2008 at 7:15 pm

    #901377

    [CandidateInfo].[DaysToScreening] can't have ".Children". It's an attribute, not a member.

    NB. Two things:

    Take the quotes off the expression definition. You'll then get inline syntax checking from most of he tools.

    Don't know why you're "testing" the 30 members. This isn't likely the best approach, and remember order processed (and hence the Key) isn't guaranteed. Check the SQL used to process the dimension and you'll note there's no ORDER BY statement. Reconsider how you're doing this.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply