Thomas.I Microsoft BI & Analytics

A Site Dedicated to General BI Issues and MS BI Issues: Architecture and Technology

Sharepoint 2007 for beginners

Posted by thomasivarssonmalmo on June 4, 2007

I have struggled during the last two weeks with Microsofts document management, search, content management and Bi-portal, Sharepoint Server 2007.  This product is really big and it is impossible to focus on that product because you can make a career by only working with Sharepoint 2007 Server.  I am used to work with ProClaritys Analytics Server and Dashboard Server, but this is something else.
 
My interest is about the following features:
  • 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.

Advertisements

One Response to “Sharepoint 2007 for beginners”

  1. Shahar said

    <<<
    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.
    >>>
    The book is specifically about programming against Excel Services – not setting it up. The Beginning Exce Services book is probably what you want for deployment etc.  

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

 
%d bloggers like this: