Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-03-24 : 18:04:33
|
| SANJOY writes "Our datawarehouse has a CLIENT dimension consisting of around 15000 records. In all cubes which have this dimension, the data can be accessed from the ANALYSIS SERVICES CUBE EDITOR. But when we are trying to access the cubes from EXCEL2000 for reporting purposes we are facing memmory problems for the client dimension. Pivot tables cannoit handle more than 32700 rows and i guess this is the problem. It is arising only in the case when the client dimension is dragged inside the report layout.Plewase suggest some way to counter this problem." |
|
|
chadmat
The Chadinator
1974 Posts |
Posted - 2002-03-27 : 14:24:19
|
| What error do you get? Have you tried Office XP (I don't know if this will solve it, just a suggestion)? -Chad |
 |
|
|
|
|
|
Analysis Services and SQL SERVER2000