locked
want to install sharepoint on desktop to show off kpis RRS feed

  • Question

  • Hi, I have plenty of access to dev and prod sql servers that are running 2008 DB Engine, RS, AS and IS instances.  Nothing except sql client tools installed on my desktop. 

    I've built a 2008 cube on a dev server and am curious to see how sharepoint and bi come together, perhaps by showing a kpi (or something) on sharepoint, preferably on my desktop.   I was told that minimally I'd need to install sharepoint 3.0 on my desktop to interface with the dev 2008 server.

    I was told I could download a free copy of sharepoint to my desktop but am not sure if the free version is enough to show off a kpi and/or if it needs other things (sql express?) installed on my desktop first.   Can someone point me in the right direction if what I'm doing is just getting started with sharepoint and its interface to SSAS?      

    • Moved by Mike Walsh FIN Tuesday, April 14, 2009 3:52 PM kpi q
    • Edited by db042188 Friday, April 17, 2009 2:57 PM
    Tuesday, April 14, 2009 2:59 PM

Answers

  • I spoke with a well respected SSAS expert yesterday who is an MS MVP.  He says you cannot display KPIs using only MS products on the free version of Sharepoint. 

    He says with the Enterprise version of SP (aka MOSS Enterprise, aka the more expensive version of MOSS that isnt free) there are 3 common ways to display KPIs that include Excel Server etc etc.  He added that the term MOSS is going away (at least the letter O) in the next release as well as Performance Point Server (not Service which is still required to do MS's PP BI displays like dashboards etc under SP) . 

    He says that due to licensing cost concerns, his company found another company that sells web parts usable on the free version of Sharepoint.  Those webparts can display KPIs and "trigger" (thru actions) rs reports whose parameters are fed to them from the action.  I just learned that these objects can actually be hosted anywhere, not just SP.  

    • Edited by db042188 Wednesday, April 29, 2009 9:20 PM
    • Marked as answer by db042188 Friday, May 1, 2009 1:41 PM
    Wednesday, April 29, 2009 4:08 PM

All replies

  • KPI questions go to Business Intelligence. Moving this.
    WSS FAQ sites: WSS 2.0: http://wssv2faq.mindsharp.com WSS 3.0 and MOSS 2007: http://wssv3faq.mindsharp.com
    Total list of WSS 3.0 and MOSS 2007 Books (including foreign language titles) http://wssv3faq.mindsharp.com/Lists/v3%20WSS%20FAQ/V%20Books.aspx
    Tuesday, April 14, 2009 3:52 PM
  • someone just told me that installing on xp wont work, at least not easily.  My desktop is xp.  That the machine has to be 2003 or 2008.  I may close this post in a few days.
    Tuesday, April 21, 2009 2:09 PM
  • I spoke with a well respected SSAS expert yesterday who is an MS MVP.  He says you cannot display KPIs using only MS products on the free version of Sharepoint. 

    He says with the Enterprise version of SP (aka MOSS Enterprise, aka the more expensive version of MOSS that isnt free) there are 3 common ways to display KPIs that include Excel Server etc etc.  He added that the term MOSS is going away (at least the letter O) in the next release as well as Performance Point Server (not Service which is still required to do MS's PP BI displays like dashboards etc under SP) . 

    He says that due to licensing cost concerns, his company found another company that sells web parts usable on the free version of Sharepoint.  Those webparts can display KPIs and "trigger" (thru actions) rs reports whose parameters are fed to them from the action.  I just learned that these objects can actually be hosted anywhere, not just SP.  

    • Edited by db042188 Wednesday, April 29, 2009 9:20 PM
    • Marked as answer by db042188 Friday, May 1, 2009 1:41 PM
    Wednesday, April 29, 2009 4:08 PM