Hi,
We have a client dimension which has about 15000 records. The cubes having this dimension can be processed without any problem and data can be accessed and seen from the AS Cube editor. The problem arises when we are connecting to AS thru' Excel2000. Only when we are dragging the client dimension in the report layout an error message is displayed saying that excel pivot table cannot handle so many rows. We have tried this out with 8000 rows in the client dimension and it works fine. Can somebody suggest something on how to tackle this problem.
Regards
Sanjoy