Forum Replies Created

Viewing 15 posts - 106 through 120 (of 138 total)

  • RE: What did you do before SQL?

    I was a high school maths and IT teacher. I was reduced to teaching MS Works due to nothing else being licensed by the school. I...




    Keith Henry


    According to everyone I know I "do something with computers?" for a living, so there you go.

    September 22, 2003 at 4:20 am

    #475219

  • RE: Scientific Number Formatting

    quote:

    if you're into using beta s/w, the beta for ADOMD.Net is out, which would remove any interop issues.




    Keith Henry


    According to everyone I know I "do something with computers?" for a living, so there you go.

    September 22, 2003 at 2:05 am

    #475206

  • RE: QOD 22 Sep 2003 - Licensing

    Why would you ever want to set this up? 4A/2P makes sense, but 2A/4P? Pay two whole extra processor lics for a server that you hardly ever...




    Keith Henry


    According to everyone I know I "do something with computers?" for a living, so there you go.

    September 22, 2003 at 1:52 am

    #475203

  • RE: Scientific Number Formatting

    Cool, but boy thats ugly. You're getting the same resultset as if you just got a OLEDB recordset object straight from MSOLAP, which is what I guess...




    Keith Henry


    According to everyone I know I "do something with computers?" for a living, so there you go.

    September 19, 2003 at 9:18 am

    #475072

  • RE: big bonus for answering on-the-day

    All I was saying is that I had a rough idea on the day about how many people got the answer, and today 80% have got it by...




    Keith Henry


    According to everyone I know I "do something with computers?" for a living, so there you go.

    September 19, 2003 at 7:05 am

    #475039

  • RE: Scientific Number Formatting

    quote:

    But I'm running an MDX query using the SQL stored procedure. When I get the resultset back in QA




    Keith Henry


    According to everyone I know I "do something with computers?" for a living, so there you go.

    September 19, 2003 at 2:27 am

    #474990

  • RE: MS Access versus SQL Server

    quote:

    Access As The UI With Linked Tables From SQL Server

    Never never ever...




    Keith Henry


    According to everyone I know I "do something with computers?" for a living, so there you go.

    September 18, 2003 at 2:20 am

    #474816

  • RE: Scientific Number Formatting

    You can also use any VBA or Excel functions in calculated measures

    Keith Henry

    DBA/Developer/BI Manager




    Keith Henry


    According to everyone I know I "do something with computers?" for a living, so there you go.

    September 18, 2003 at 2:14 am

    #474815

  • RE: MS Access versus SQL Server

    Just to confuse things Access 2000 on can use sql as the back end. The choice is not Access vs SQL but "MS Jet 4.0 Engine" vs...




    Keith Henry


    According to everyone I know I "do something with computers?" for a living, so there you go.

    September 17, 2003 at 8:39 am

    #474655

  • RE: Level Depth

    maybe member.properties("leveldepth")

    Keith Henry




    Keith Henry


    According to everyone I know I "do something with computers?" for a living, so there you go.

    September 17, 2003 at 8:30 am

    #474651

  • RE: greater than > and less than < in MDX

    How about

    filter( {
        descendants([startdatedim].[all],[year],self_and_after)
        * descendants([enddatedim].[all],[year],self_and_after)



    Keith Henry

    According to everyone I know I "do something with computers?" for a living, so there you go.

    September 17, 2003 at 7:02 am

    #474623

  • RE: Connection Problem in IIS

    Could be related to SSPI/Kerberos as MSOLAP is notoriously difficult with NT Security delegates and the like. Look at what account IIS connects to MSOLAP under and...




    Keith Henry


    According to everyone I know I "do something with computers?" for a living, so there you go.

    September 17, 2003 at 3:34 am

    #474585

  • RE: add non additive measures to a cube

    You can remove the "all" level, but part of the point of dimensions is this combination of values (can be SUM, COUNT, AVG)

    Keith Henry




    Keith Henry


    According to everyone I know I "do something with computers?" for a living, so there you go.

    September 17, 2003 at 3:29 am

    #474582

  • RE: different measures for different levels of cube

    Not in one cube. All measures will be availiable at all levels. You can remove the "All" level of a dimension if totals don't make sense. ...




    Keith Henry


    According to everyone I know I "do something with computers?" for a living, so there you go.

    September 17, 2003 at 3:27 am

    #474580

  • RE: greater than > and less than < in MDX

    MDX slices don't work like SQL where clauses. You don't have fields as such, just members of dimensions

    Say you wanted all data between two dates:...




    Keith Henry


    According to everyone I know I "do something with computers?" for a living, so there you go.

    September 17, 2003 at 2:51 am

    #474577

    • Viewing 15 posts - 106 through 120 (of 138 total)