dbTalk Databases Forums  

AS2000. Problem with dimensions maintained by msmdvldm.

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


Discuss AS2000. Problem with dimensions maintained by msmdvldm. in the microsoft.public.sqlserver.olap forum.



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

Default 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



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.