I thought I'd share some of the questions that came up during my recent Business Scorecard Manager course (see http://community.softteq.com/blogs/john/archive/2006/05/21/61.aspx).

Q1: What do the 2 columns required for KPI ODBC queries correspond to?
A1: They correspond to the previous and actual value. e.g. select

Q2: Can a Scorecard View be selected based on the user viewing it?
A2: Microsoft has indicated that this functionality can be achieved, but not via configuration in Business Scorecard Manager. It is done via Sharepoint using the concept of Audiences or alternatively using Personal Views.

Q3: What are the Security Best Practices for BSM and Sharepoint
A3: There are currently no best-practices from Microsoft for BSM, however given that the public view/interaction with scorecards is all via Sharepoint, then security issues can all be addressed via Sharepoint.

Here is the link to the Sharepoint Admin Guide which has a section on security:

http://www.microsoft.com/downloads/details.aspx?amp;displaylang=en&familyid=a637eff6-8224-4b19-a6a4-3e33fa13d230&displaylang=en


As you can see, it will be important that you have a close relationship with those responsible with your Sharepoint site, as Sharepoint holds the key to managing security and visibility of your scorecards.