dbTalk Databases Forums  

SSAS 2005 don't return a list of members!!!

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


Discuss SSAS 2005 don't return a list of members!!! in the microsoft.public.sqlserver.olap forum.



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

Default SSAS 2005 don't return a list of members!!! - 11-20-2006 , 05:52 PM






Hi,

In the management interface or using a custom MDX query to return a subset
of members doesn't works on 1 server....

I have a dimension with 40 000 members, the management interface can't
display the full list and stop after 1000 members but display a "click here
to filter"
So I click here...
then I add a filter on the name of the member everything works fine until I
try to find the members which starts with a name greater then G
H to Z values return nothing!!!!

another instance on the SAME server based on the SAME cubes return
values!!!!!
I have synchronized the dev instance with the prod instance and executed the
same queries, same result, my prod server refuse to return members after the
G letter.

what I have missed???
its the only server with this issue, I have 8 instances deployed on
different servers and all other works fine.

thanks for your guides.

Jerome.



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.