PivotTable and dimension refresh with SQL2005

J

Jan Klimes

Good morning,
I have OLAP cube in SSAS 2005, when I made change in
dimension,then full process dimension -> Excel 2003, Refresh Pivot
table - I see no change in dimension (only data is refreshed)!!! In
SQL 2000 + Excel 2003 it works well.
When I remove and add dimension to pivottable - then it is OK.
But it is not good way - users have their tables prepared, filtered
etc.

Have anyone seen such problem (and solution)? Thanks a lot!

Jan Klimes
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel pivot tables and SSAS 2
PivotTable Filter Automaticly adds new data 2
Pivot table hierarchical dimension expansion 0
OWC-pivottable rendering problem with Parent-child dimension 1
2003 Cube Refresh Error 0
Excel 2007 pivot table using analysis services cube as data source 0
Rebuilding the OLAP cube removes my new dimension (SQLServer2000) 0
ODBC Microsoft Access Driver Login Failed 0

Top