AS2000. Problem with dimensions maintained by msmdvldm. -
03-15-2006
, 05:25 AM
Hi,
AS2000
I have a dimension with about 2 mln. members. The dimension has grouping
level to overcome the 64K boundary. It is only dimension in my OLAP DB that
is maintained by msmdvldm.exe.
If I try to find some dimension leaf member, that definitively exists with
MDX-query such as following
select {[Check].[Check].&[1144920]} on 0
from SalesI get error that dimension member doesn't exist.If I try to find
it with ADOMD.Connection.OpenSchema(SchemaEnum.adSchemaMem bers ...I get an
empty recordset.If I browse the ADOMD.Catolog, then I find the member
succesfully. And after it was found, both the MDX query and the
OpenShemareturn expected result.It seems as while VLD Member is not in the
client(PTS) chache, it can't find by MDX or schema query.I have no such
problems with others also quite large dimensions, that have about 1 mln.
members and that aren't maintained by msmdvldm.exe.Thanks in advanceVladimir
Chtepa |