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. |