Solved

PerformancePoint connection error to Analysis Services DataSource

Posted on 2013-01-03
3
1,605 Views
Last Modified: 2013-01-09
I am trying to establish a data source connection in PerformancePoint Dashboard Designer  to Analysis Services. I have been successful in making other types of connections, but not Analysis Services. My successful attempts include by using the Unattended account:

    Connecting to the PerformancePoint Service Application config database (just a test)
    Connecting to a SharePoint list
    Connecting to a SQL Server database

Why then can I not create a connection using the Analysis Services data source?

I have done the following:

    Created a Secure Store entry for PerformancePoint
    Started the PerformancePoint Service
    Added the "Unattended Service Account" to PerformancePoint

The Analysis Services is running on our development SharePoint Server so I am using that server name as the connection name. When I do that and click on the database drop-down I get an error "Cannot connect to server. Make sure the server is available and is running at least Microsoft SQL Server 2005 Analysis Services".

Now, I had previously created an Analysis Services PowerPivot cube when setting up PowerPivot. So when I try using that as the name "abcdev\powerpivot" I do not get the error when clicking the drop-down, however, the drop-down is empty. I get no error and the drop-down appears as if it were holding a single line item, but it is not ... it is blank. Is this where I have gone wrong? Do I need to do something more or different with Analysis Services?

Plus, I cannot find any good documentation on PerformancePoint Dashboard Designer. I saw on Amazon there was a "SharePoint 2010 PerformancePoint Unleashed" book. Is there any other good resources?

Thanks.
0
Comment
Question by:vpit
3 Comments
 
LVL 44

Accepted Solution

by:
Rainer Jeschor earned 400 total points
ID: 38743399
Hi,
did you configure the user (unattended account) in SSAS to have access to the SSAS database / cube?

In regards to resources: afaik this is the only one which is dedicated to Performance Point services. You might find also more information in some MS Business Intelligence / BI with SharePoint books.
Some good urls:
http://blogs.msdn.com/b/performancepoint/
http://office.microsoft.com/en-001/dashboard-designer-help/up-to-speed-with-performancepoint-dashboard-designer-HA101818158.aspx

HTH
Rainer
0
 
LVL 38

Assisted Solution

by:Justin Smith
Justin Smith earned 100 total points
ID: 38743684
Typically you have to grant access on the actual SSAS instance, to your unattended account.  You would then need to grant it access to the specific cube/db.
0
 

Author Comment

by:vpit
ID: 38759202
I solved the issue as I needed to install SSAS and BIDS on my local instance of SQL Management Studio AND install SSAS on the external database server housing the SharePoint content databases. Our SQL DBA had not installed SSAS on that server yet as there were no requirements yet to do so ... until now.
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

I used to be SharePoint evangelist in our company, so my Outlook always full of questions about how to do this, or where I can find that. One day I found such an email with the following question: "how to attach 3-State workflow (one of the workflow…
There is one common problem that all we SharePoint developers share: custom solution deployment. This topic can't be covered fully in this short article, so all I want to do in this one is to review it from a development-to-operations perspectiv…
Internet Business Fax to Email Made Easy - With eFax Corporate (http://www.enterprise.efax.com), you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, fr…
As a trusted technology advisor to your customers you are likely getting the daily question of, ‘should I put this in the cloud?’ As customer demands for cloud services increases, companies will see a shift from traditional buying patterns to new…

910 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

17 Experts available now in Live!

Get 1:1 Help Now