Sharepoint 2007 for beginners
Posted by thomasivarssonmalmo on June 4, 2007
- Report Center and templates for BI-portals
- The use of Excel Services in BI-solutions and as an AS2005 data distributor/presenter
There are also some other features that are interesting but not directly BI. It is more about document management but these features can increase the business value of the report side of BI-solution:
- Use workflow to reject and approve individual reports(XL)
- Versioning of reports including the possibility to save snapshots or states in a report(XL)
- The possiblity to set time schedules for reports and control how long they should be presented.
What are my conclusion then?
- It is very hard to get good enough information about how this product works in a BI-perspective. I have bought "Professional Excel Services" (Wrox) written by some of the guys in the development team. This book have a lot of useful information but failed to explain how to set up a data connection in Sharepoint. Without that you cannot publish an XL-2007 spreadsheet with SSAS2005 data, you will only see error messages. I finally found this information in a virtual lab.
- Excel Services is most useful for XL-applications with advanced calculations. You can put in values and get calculation results in return but since you cannot write MDX-queries in Excel2007 you can only publish a pivot-table with very limited interactivity. I can put in values in an AS2005 cube and get values in return but that is by writeback and I am not sure that this scenario is supported in Excel Services. Pivot tables with AS2005 data can be published in a Sharepoint 2007 Dashboard instead.
- Find a good expert on Sharepoint 2007 Server that can help you with the overall view of this product.
I am still in an early learning phase regarding Sharepoint 2007 server so I could have get some things wrong. If this is the case I will return with more comments about this.