dbTalk Databases Forums  

Large Dimension throws "Member not found" error

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


Discuss Large Dimension throws "Member not found" error in the microsoft.public.sqlserver.olap forum.



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

Default Large Dimension throws "Member not found" error - 07-19-2005 , 08:01 AM






Hi all,
I have a retailer cube with large products dimension
(around 400,000 members, and 4 levels).
Until recently, when we installed MS Olap SP4, we had no problem
with this Cube.
But since the SP4 installation, we get strange behaviors:
If i try to execute an MDX query that displays/filter the
Results by any of the Product dimension leaf members, i got
an "Member not found" error.
HOWEVER, if i try to execute the same query in the MDX sample
application, AFTER i drill (only drill - no selection is made)
to the Parent of any Product leaf member, i get results.

Any ideas are warmly welcome.


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.