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

Top