Solved

PerformancePoint connection error to Analysis Services DataSource

Posted on 2013-01-03
3
1,616 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

Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

Question has a verified solution.

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

Suggested Solutions

For SharePoint sites, particularly public-facing ones, there are times when adding JavaScript, Meta Tags, CSS Styles or other content to the page <head> section is more practical than modifying master pages.  For instance, you could add the jQuery l…
The vision: A MegaMenu for a SharePoint portal home page The mission: Make it easy to maintain. Allow rich content and sub headers as well as standard links. Factor in frequent changes without involving developers or a lengthy Dev/Test/Prod rel…
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…
Nobody understands Phishing better than an anti-spam company. That’s why we are providing Phishing Awareness Training to our customers. According to a report by Verizon, only 3% of targeted users report malicious emails to management. With compan…

809 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