dbTalk Databases Forums  

ADOMD.NET Multiple hierarchies associated with a single dimension

microsoft.public.sqlserver.olap microsoft.public.sqlserver.olap


Discuss ADOMD.NET Multiple hierarchies associated with a single dimension in the microsoft.public.sqlserver.olap forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
AS
 
Posts: n/a

Default ADOMD.NET Multiple hierarchies associated with a single dimension - 06-16-2004 , 06:05 AM






Hello,
I've create a cube with two shared dimension TIME.YMD and TIME.YWD and a dimension named Team.
I' changed the version of ADOMD.NET from Beta to Last Version.
In the last version when I use this C# code from an aspx page to get the member of a level:

MemberCollection mc = cube.Dimensions.Find("Team").Hierarchies[0].Levels.Find("Team").GetMembers();

I receive this error:
"A DataTable named 'Time' already belongs to this DataSet."

I connect using xmla.

I removed the dimension TIME.YWD and it works.
I also installed the patch: http://support.microsoft.com/?kbid=819609

I think is a bug of the new version of Microsoft.AnalysisServices.AdomdClient !!!


Reply With Quote
  #2  
Old   
Mosha Pasumansky [MS]
 
Posts: n/a

Default Re: ADOMD.NET Multiple hierarchies associated with a single dimension - 06-16-2004 , 01:50 PM






Actually, you don't want to use msxaserv.dll from KB 819609 - because it is
pre XMLA SDK 1.1, and it was only intended as a hotfix for XMLA SDK 1.0
systems. In fact, in order to get functional system, you must restore
msxaserv.dll from the original XMLA SDK 1.1 distribution.
In order to make multiple hierarchies work, you need to install hotfix for
msolap80.dll - from the following KB article:
http://support.microsoft.com/default.aspx?kbid=819606


--
==================================================
Mosha Pasumansky - http://www.mosha.com/msolap
Development Lead in the Analysis Server team
All you need is love (John Lennon)
Disclaimer : This posting is provided "AS IS" with no warranties, and
confers no rights.
==================================================

"AS" <AS (AT) discussions (DOT) microsoft.com> wrote

Quote:
Hello,
I've create a cube with two shared dimension TIME.YMD and TIME.YWD and a
dimension named Team.
I' changed the version of ADOMD.NET from Beta to Last Version.
In the last version when I use this C# code from an aspx page to get the
member of a level:

MemberCollection mc =
cube.Dimensions.Find("Team").Hierarchies[0].Levels.Find("Team").GetMembers()
;
Quote:
I receive this error:
"A DataTable named 'Time' already belongs to this DataSet."

I connect using xmla.

I removed the dimension TIME.YWD and it works.
I also installed the patch: http://support.microsoft.com/?kbid=819609

I think is a bug of the new version of
Microsoft.AnalysisServices.AdomdClient !!!




Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.