Hi,

I hope, this is the correct forum for the following Questions:

(I´m using XMLA Beta 1.1, whith corresponding ADOMD.NET Beta, VS.NET 2003 Enterprise)

Problem 1)

When running the following Code:

dim con As New AdomdConnection
con.ConnectionString = "DataSource='http:/localhost/xmla/msxisapi.dll';Catalog='KDW Sales'"
con.Open()
Dim cmd As New AdomdCommand
cmd.Connection = con
Dim cs As CellSet

cmd.CommandText = "SELECT { SUBSET( ADDCALCULATEDMEMBERS( { [KundeLand].[All KundeLand].CHILDREN }), 0, 200 ) } ON COLUMNS FROM [S701_AE]"
cs = cmd.ExecuteCellSet()

the call to cmd.ExecuteCellSet is throwing an exception saying: (translated from German)

"unhandled Exception, type 'System.Data.DuplicateNameException' occured in msadomdp.dll
Additional Information: A DataTable with name 'Datum' already belongs to this Dataset."
There is a 'Datum' Dimension in the cube with two different hierarchies. When I use a Cube without Dimensions with multiple Hierarchies, everything works fine. The same MDX performs well in other Frontends.

Problem 2) The cubedef.dimensions.hierarchies collection cannot be indexed by name in vb.net.
Problem 3) The cubedef object cannot be debugged and watched (Timeouts, Collections not accessible)debug.writeline works well.

Problem 4) Performance seems a little slow, compared to other Frontends.

Thanks in advance

Peter

I believe that the release notes for ADOMD.NET beta say that multiple hierarchies on a single dimension do not work. You may want to check for yourself, since my memory is sketchy.

- Paul

---
Posted using Wimdows.net NntpNews Component - Posted from SQL Servers Largest Community Website: http://www.sqlJunkies.com/newsgroups/