I've been reciving this error while attempting to process a partition:
Out-of-process use of OLE DB provider "SQLNCLI.1" with SQL Server is not
supported.

The dimensions work, just not the processing of the partition.

This is AS2005 going against SQL Server 2005.




SELECT [dbo_vFact_HourlyActivitySummaryCurrent].[EventCount] AS
[dbo_vFact_HourlyActivitySummaryCurrentEventCount0_ 0],[dbo_vFact_HourlyActivitySummaryCurrent].[KeywordRevenue]
AS
[dbo_vFact_HourlyActivitySummaryCurrentKeywordReven ue0_1],[dbo_vFact_HourlyActivitySummaryCurrent].[BillingRevenue]
AS
[dbo_vFact_HourlyActivitySummaryCurrentBillingReven ue0_2],[dbo_vFact_HourlyActivitySummaryCurrent].[BillingImpressions]
AS
[dbo_vFact_HourlyActivitySummaryCurrentBillingImpre ssions0_3],[dbo_vFact_HourlyActivitySummaryCurrent].[CalendarDWID]
AS
[dbo_vFact_HourlyActivitySummaryCurrentCalendarDWID 0_4],[dbo_vFact_HourlyActivitySummaryCurrent].[ClientRequestTypeID]
AS
[dbo_vFact_HourlyActivitySummaryCurrentClientReques tTypeID0_5],[dbo_vFact_HourlyActivitySummaryCurrent].[TimeOfDayDWID]
AS
[dbo_vFact_HourlyActivitySummaryCurrentTimeOfDayDWI D0_6],[dbo_vFact_HourlyActivitySummaryCurrent].[CountryCode]
AS
[dbo_vFact_HourlyActivitySummaryCurrentCountryCode0 _7],[dbo_vFact_HourlyActivitySummaryCurrent].[KeywordID]
AS
[dbo_vFact_HourlyActivitySummaryCurrentKeywordID0_8 ],[dbo_vFact_HourlyActivitySummaryCurrent].[AdID]
AS
[dbo_vFact_HourlyActivitySummaryCurrentAdID0_9],[dbo_vDim_AccountManagerCurrent_5].[BusinessUnitID]
AS [dbo_vDim_AccountManagerCurrentBusinessUnitID2_0]

FROM

(


select * from vFact_HourlyActivitySummaryCurrent where CalendarDWID = 2730
and TimeOfDayDWID = 0

)

AS [dbo_vFact_HourlyActivitySummaryCurrent],

OPENROWSET

(

N'SQLNCLI.1',

N'',

N'[dbo].[vDim_AccountManagerCurrent]'

)

AS [dbo_vDim_AccountManagerCurrent_5],[dbo].[vDim_AdCurrent] AS
[dbo_vDim_AdCurrent_5],[dbo].[vDim_CampaignCurrent] AS
[dbo_vDim_CampaignCurrent_5],[dbo].[vDim_SalesRelationshipCurrent] AS
[dbo_vDim_SalesRelationshipCurrent_5]

WHERE

(


(

[dbo_vDim_SalesRelationshipCurrent_5].[AccountManagerID] =
[dbo_vDim_AccountManagerCurrent_5].[AccountManagerID]

)

AND

(

[dbo_vDim_CampaignCurrent_5].[SalesRelationshipID] =
[dbo_vDim_SalesRelationshipCurrent_5].[SalesRelationshipID]

)

AND

(

[dbo_vDim_AdCurrent_5].[CampaignID] =
[dbo_vDim_CampaignCurrent_5].[CampaignID]

)

AND

(

[dbo_vFact_HourlyActivitySummaryCurrent].[AdID] =
[dbo_vDim_AdCurrent_5].[AdID]

)

)

For some reason the server appears to consider that this partition requires
to join data from multiple data sources... You may want to check if the DSV
for the AccountManagerCurrent table has a DataSourceID attribute in the XML.

Its strange to see the joins to the multiple tables too -- you may want to
check that the granularity of the measure group matches the granularity of
the fact table. Should the server really be following a join from:

[vFact_HourlyActivitySummaryCurrent].[AdID] = [vDim_AdCurrent_5].[AdID]
[vDim_AdCurrent_5].[CampaignID] = [vDim_CampaignCurrent_5].[CampaignID]
[vDim_CampaignCurrent_5].[SalesRelationshipID] =
[vDim_SalesRelationshipCurrent_5].[SalesRelationshipID]
[vDim_SalesRelationshipCurrent_5].[AccountManagerID] =
[vDim_AccountManagerCurrent_5].[AccountManagerID]

Or is there a better way to get from the fact table to the AccountManagerID
key column?

Thanks,
Akshai
--
Try out the MSDN Forums for Analysis Services at:
http://forums.microsoft.com/MSDN/Sho...ID=83&SiteID=1

This posting is provided "AS IS" with no warranties, and confers no rights
Please do not send email directly to this alias. This alias is for newsgroup
purposes only.

"Jesse O." <jesperzz (AT) hotmail (DOT) com> wrote

Got it.

It was an added DataSourceID reference in the XML for Account Manager.

It was the same ID as all the others, however Account Manager was the only
one specifically set for it.

Thanks for your help.


"Akshai Mirchandani [MS]" <akshaim (AT) online (DOT) microsoft.com> wrote