Friday, August 23, 2013

Providing new user functionality directly in cubes

What if someday the SVP of Sales wants to set up sales quotas and be able to change them?  Do we institute that functionality directly into CRM?  Currently the BI sample dashboards for Sales have hardcoded values for determining what the percentage improvement over the previous year should be for all Account Directors.  If they want to change it, they can inside of PerformancePoint, but again, it applies to all ADs.  If they want the ability to set it per Region or per AD, we’d have to provide that ability.  And as BI developers, we may not have access to changing things in CRM… so what do we do?

In comes WriteBack option in SSAS to the rescue.  A few quick tweaks to the SSAS cube and voila … the SVP can set the quotas in Excel with a few clicks!  Check out this video to see how it works:  Excel 2010 Writeback to Analysis Services

Thursday, July 18, 2013

Released: Kerberos Configuration Manager for SQL Server

Haven’t tried this yet, but hey… what an idea!

http://blogs.msdn.com/b/analysisservices/archive/2013/05/23/released-kerberos-configuration-manager-for-sql-server.aspx

I believe that the “EffectiveUserName” option in SharePoint mentioned in this blog is only available in SharePoint 2013+

Definitely not in PerformancePoint on SharePoint 2010 UI

Just hit this presentation which may be more helpful than my notes (pretty pictures): http://sqlserverbiblog.files.wordpress.com/2011/12/sharepoint-bi-security-configuration.pdf

Thursday, May 9, 2013

PerformancePoint Troubleshooting

Unexpected     System.Web.HttpException: Request timed out.

What I was trying to do:

View a PerformancePoint Dashboard

Log shows:

Unexpected     System.Web.HttpException: Request timed out.

How to troubleshoot:

  1. Bump up the execution timeout for PerformancePoint by modifying the web.config for httpRuntime’s executionTimeout.  See Jeff Widmer’s blog.
  2. Turn off some of the webparts by adding this to the URL: ?contents=1?PageView=Personal. See SharePoint Steve’s blog.

This made it obvious in this situation that it was the data source that was at the heart of the issue.

HTTP request was forbidden with client authentication scheme 'Anonymous'

What I was trying to do:

Edit a Data Connection to a PerformancePoint dashboard.  I had changed it over to “Per User Identity” and it claimed it connected, but when I ran the dashboards they timed out.

Log shows:

Critical    An unexpected error occurred.  Error 27192.  Exception details: System.ServiceModel.Security.MessageSecurityException: The HTTP request was forbidden with client authentication scheme 'Anonymous'.

 

How to fix?

Turns out that there were 12 applications using the same application pool.  Who installed this?  Normally each app should have it’s own pool so it doesn’t take down the entire site when it fails.

So I created a new app pool and held my breath!

image

Then I stopped and restarted the service (which you can do from inside the Sharepoint admin console).

I switched the Data Source back to use the Unattended Execution account (for now … until I have time to work the Kerberos issues out).

Friday, March 8, 2013

Set up and Verify PerformancePoint on SharePoint 2010

In order to be able to use the Dashboard Designer, the following must be true:

  1. In SharePoint Central Admin, go to Manage Service Applications
  2. Select “Secure Store Service” … if it isn’t there, select New on the menu and then “Secure Store Service”, see Deploying PerformancePoint 2010 Soup to Nuts
  3. If there is no key, Generate a New Key and use the sp_farm password for encryption
  4. In Sharepoint Central Admin, go to Manage Service Applications
  5. Select “PerformancePoint Service” … if it isn’t there, select New on the menu and then “PerformancePoint Service”, see Deploying PerformancePoint 2010 Soup to Nuts
  6. Select Performance Point Service Application Settings
  7. Verify the Secure Store Service is using the SQL Server service account
  8. Go back and select Trusted Data Source Locations
  9. Choose “Only Specific Locations” and click apply.  Then choose “All Sharepoint Locations” and click apply … this seems to help avoid a bug when setting up data sources in Dashboard Designer.  NOTE: in the future, we may restrict the locations, so if some are set, leave them!
  10. Repeat for Trusted Content Locations
  11. Verify that PerformancePoint can connect to SSAS
    1. Open the BI Portal on the environment
    2. In the central part of the page, click the right facing tab “Create Dashboards”
    3. Click the link “Start using Performance Point Services”
    4. Click Run Dashboard Designer
    5. Click Run in the Click Once installer dialog
    6. Right-click on Data Connections in the workspace browser and select “New Data Source”
    7. In the Editor tab in the central pane:
      1. Enter the SSAS server name with processed cubes
      2. Select the Cube
      3. Click Test Data Source
    8. Right-click on Performance Point Content in the workspace browser and select “New KPI”
    9. In the Editor tab of the central pane:
      1. Click one of the links under the Data Mapping column
      2. Click the Change Source button
      3. Choose the New Data Connection that you just created and click OK
      4. Click the drop-down under the Select a Measure and it should populate with the measure of the cube
  12. Close out of Performance Point without saving