P
ptfan
A couple of years ago I was heavy user of PivotTables connected to data
in SQL Server databases. I've been on a different assignment since then
and just came back to find that the IT Dept has developed a new data
warehouse that only exposes OLAP cubes. I immediately bumped up against
some of the pivot table limitations identified in the following MS KB
article:
http://support.microsoft.com/?kbid=234700
The IT Dept is telling me that there will soon be no option for me to
do Non-OLAP ad-hoc reporting because only Cubes will be available for
analysis, and they gave me Microsoft Data Analyzer to use. That product
hasn't exactly impressed me.
Are there any other Excel users out there who have had a similar
experience? Are there other reporting tools that I should consider that
would provide as good a user experience as Excel Pivot Tables used to?
I would appreciate any input on this subject.
in SQL Server databases. I've been on a different assignment since then
and just came back to find that the IT Dept has developed a new data
warehouse that only exposes OLAP cubes. I immediately bumped up against
some of the pivot table limitations identified in the following MS KB
article:
http://support.microsoft.com/?kbid=234700
The IT Dept is telling me that there will soon be no option for me to
do Non-OLAP ad-hoc reporting because only Cubes will be available for
analysis, and they gave me Microsoft Data Analyzer to use. That product
hasn't exactly impressed me.
Are there any other Excel users out there who have had a similar
experience? Are there other reporting tools that I should consider that
would provide as good a user experience as Excel Pivot Tables used to?
I would appreciate any input on this subject.