Friday, September 11, 2009

Excel Services / SharePoint Reporting

Excel Services sounds great until you hit the limitations.

If you ain't got a cube behind your excel workbook then forget about it!

Or you need to do funky things like uploading your data with some fancy macros.....but enough said about that...

But how easy is it to set up a few cubes to link to your data....depends if you speak to someone like me or not! Will need to blog about that soon relative to simple data reporting as compared with fancy analysis....e.g. a customer list lookup!

We get most people using reporting services because it is easy to use if you have excel experience.
Plus things like scheduled reporting and dril through is soo nice.

As you can see there are many more questions raised than simple answers.
That said, the next version in SharePoint 2010 might be a little better. What will be better one hopes is the confusion about what you can do etc.

Labels: , ,

0 Comments:

Post a Comment

Subscribe to Post Comments [Atom]

<< Home