QOD 23/09/2003

  • The question should have been...

    You create a new linked analysis server 2000 in enterprise manager from a SQL 2000 server. You set :

    Linked server: olap

    Provider Name: Microsoft OLEDB provider for Olap Services 8.0

    Data Source: your OLAP server name

    Catalog: FoodMart 2000

    Then you try to execute the following :

    select *

    from openquery(olap, '

    select

    {{[Measures].members} * {[Product].[Product Family].members}} on columns,

    {{([Customers].[All Customers].[USA], [Education Level].[All Education Level].[Bachelors Degree] ),

    ([Customers].[All Customers].[USA], [Education Level].[All Education Level].[High School Degree] )},

    ([Customers].[All Customers].[Canada], [Education Level].[All Education Level].[Bachelors Degree] )} on rows

    from Sales')

    And you get the following error:

    Could not create an instance of OLE DB provider 'MSOLAP'.

    OLE DB error trace [Non-interface error: CoCreate of DSO for MSOLAP returned 0x80040154].

    What did you do wrong?

    1) The MDX is wrong

    2) You should have set Product Name: MSOLAP

    3) You need service pack 3 of Analysis Services

    4) You need to set "AllowInProcess" in Provider Options

    5) The SQL server Service account does not have rights to Foodmart 2000

    Keith Henry

    Edited by - keithh on 09/23/2003 02:09:33 AM




    Keith Henry



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

  • Oh... I thought it might be like Jeopardy, where we have to guess the question.

    Data: Easy to spill, hard to clean up!

  • Jepoardy Answer of the Day (for 500): 8 licenses are required with this setup

    Keith Henry

    DBA/Developer/BI Manager

    Edited by - keithh on 09/23/2003 07:51:50 AM




    Keith Henry



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

  • 🙂 Must've been a real longgggg day that day. I went ahead and set the question to appear in full tomorrow. It's fixed now on the QOD side but will appear tomorrow. Sorry about that!

    Brian Knight

    bknight@sqlservercentral.com

    http://www.sqlservercentral.com/columnists/bknight

  • I was thinking this was just a test to see how many people just pick random answers without reading the question.



    Mark

  • 29.7% got it right

    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.

  • I like concise questions, but that was ridiculous. No wonder it was a three-point question

    Actually got it right without knowing, just by reading the error message. CoCreate is creating something in a separate process, so the most likely problem is that the create cannot be out of process, so....

  • quote:


    Actually got it right without knowing, just by reading the error message. CoCreate is creating something in a separate process, so the most likely problem is that the create cannot be out of process, so....


    How did you know the error message was related to CoCreate if you hadn't read this thread? I which case you did know what the question was!

    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.

  • It'd be good to have questions on topics that everyday people use every day...

    I'm sure people do use OLAP with SQL Server, but in my experience it's far from common.

    My 2 cents, anyway... <:\

  • All I did was pick an answer, then got the pop up screen, read the question and then choose the correct answer!!!

  • quote:


    It'd be good to have questions on topics that everyday people use every day...

    I'm sure people do use OLAP with SQL Server, but in my experience it's far from common.

    My 2 cents, anyway... <:\


    As oppossed to commonly used technology like c2-level audits and fulltext

    I thinks it should be challenging. Just about the only thing all DBAs use every day is select * from something, and I can't think of many questions on that.

    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.

  • I would like to see some questions like the tests. At some point, when I get the time [:-)], I would actually like to take them.

    Joe Johnson

    NETDIO,LLC.


    Joe Johnson
    NETDIO,LLC.

  • quote:


    quote:


    Actually got it right without knowing, just by reading the error message. CoCreate is creating something in a separate process, so the most likely problem is that the create cannot be out of process, so....


    How did you know the error message was related to CoCreate if you hadn't read this thread? I which case you did know what the question was!

    Keith Henry

    DBA/Developer/BI Manager


    When I selected a random answer in the E-Mail, it took me to the QoD page on the web site, which had the full question when I got there. That's where I read the question, changed my answer to a non-random value, and got it correct.

    Personally, I think that people who read the forum first are not 'playing by the rules'.

Viewing 13 posts - 1 through 12 (of 12 total)

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