September 23, 2003 at 2:08 am
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
September 23, 2003 at 7:07 am
Oh... I thought it might be like Jeopardy, where we have to guess the question.
Data: Easy to spill, hard to clean up!
September 23, 2003 at 7:51 am
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
September 23, 2003 at 8:07 am
🙂 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
http://www.sqlservercentral.com/columnists/bknight
Brian Knight
Free SQL Server Training Webinars
September 23, 2003 at 9:57 am
I was thinking this was just a test to see how many people just pick random answers without reading the question.
Mark
September 23, 2003 at 10:09 am
29.7% got it right
Keith Henry
DBA/Developer/BI Manager
Keith Henry
September 23, 2003 at 3:32 pm
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....
September 24, 2003 at 1:55 am
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
September 24, 2003 at 2:30 am
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... <:\
September 24, 2003 at 5:59 am
All I did was pick an answer, then got the pop up screen, read the question and then choose the correct answer!!!
September 24, 2003 at 9:20 am
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
September 24, 2003 at 9:45 am
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.
September 24, 2003 at 1:30 pm
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