Welcome to Sign in | Help
in Search

performanta filter

Last post 05-24-2007, 7:42 PM by das. 0 replies.
Sort Posts: Previous Next
  •  05-24-2007, 7:42 PM 1942

    performanta filter

    Salut,

    Am mai scris odata dar din cauza intreruperii sitelui postarea s-a pierdut; oricum welcome back !.

    Deci am aveam probleme cu urmatoarea cerinta: sa se selecteze toti clientii (de fapt media vinzarilor) care se afla la o distanta mai mica de x km de un punct dat.

    Am facut o dimensiune [Dim Gis] in care se afla coodonatele tuturor clientilor si urmatorul query care rezolva cerinta de mai sus dar are o mare hiba in privinta performantei: dureaza mult.

    SELECT non empty {[Measures].[Avg] } ON COLUMNS,

    non empty [Dim Type].[Name].Members ON ROWS

    FROM [DW]

    WHERE (filter([Dim Gis].[Coord].MEMBERS,

    mdxclasslibrary.dist(

    [Tbl DW Dim Gis].[Coord].CurrentMember.Name,

    "44.43667763671138","26.06771349906921",1

    )>0

    )

    )

     

    Sugestii pentru imbunatairea vitezei ?

    ps: mdxclasslibrary.dist este o procedura in c# care calculeaza distanta intre doua puncte definite prin latitudine si longitudine

     

     

     

    Filed under: ,
View as RSS news feed in XML
Powered by Community Server (Commercial Edition), by Telligent Systems