QOD 23/09/2003

Question

Post reply

QOD 23/09/2003

Keith Henry

Hall of Fame

Points: 3759
More actions
September 23, 2003 at 2:08 am

#106506

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.

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

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

stubob SSCommitted Points: 1839 More actions · Answer 1

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

Data: Easy to spill, hard to clean up!

Keith Henry Hall of Fame Points: 3759 More actions · Answer 2

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.

Brian Knight One Orange Chip Points: 27249 More actions · Answer 3

🙂 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

Brian Knight
Free SQL Server Training Webinars

Mark Harr SSCrazy Eights Points: 9921 More actions · Answer 4

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

Mark

Keith Henry Hall of Fame Points: 3759 More actions · Answer 5

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.

brendt hess Hall of Fame Points: 3256 More actions · Answer 6

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....

Keith Henry Hall of Fame Points: 3759 More actions · Answer 7

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.

andybibby SSC Enthusiast Points: 179 More actions · Answer 8

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... <:\

dbamark SSCommitted Points: 1694 More actions · Answer 9

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

Keith Henry Hall of Fame Points: 3759 More actions · Answer 10

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.

johnsonj SSCrazy Points: 2159 More actions · Answer 11

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.

brendt hess Hall of Fame Points: 3256 More actions · Answer 12

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'.