Microsoft SQL Server Analysis Services, SSAS, is an online analytical processing (OLAP), data mining and reporting tool in Microsoft SQL Server.

learn more… | top users | synonyms

6
votes
4answers
7k views

How to setup Kerberos Constrained Delegation for SharePoint Excel Services and Analysis Services

This question is in continuation to MSOLAPSvc.3 service missing from kerberos delegation Target : To refresh a pivot table based out of a SSAS cube using Windows Authentication in the excel service ...
2
votes
2answers
114 views

Crunching numbers according to user-defined formulas: best approach?

I have been trying different solutions to this problem, including a completely custom data processing module; now I feel like I've run out of options and was wondering what people thought was the best ...
2
votes
1answer
754 views

Error with credentials installing SQL 2008 R2 PowerPivot on SharePoint 2010 Front End

Scenario: We have a server farm that consists of (2) back-end servers, (2) web front-ends that are accessed via the internal network, and (2) web front-ends that are accessed from outside the network (...
1
vote
1answer
67 views

Add SQL Analysis Services to a existing SharePoint Farm

Our SharePoint Farm is based on a failover SQL cluster (MS SQL 2012 Standard). The problem is, that the Analysis Services were not installed with the database engine. If I'm understanding right, it's ...
1
vote
1answer
267 views

How I Can Add SSAS TO Excel Services Application Trusted Data Provider in Share Point 2013?

I use SharePoint 2013 and I want create some Excel Report from my SSAS database. For configuration my Excel Service, I go to Central Administration and Manage service applications, then Excel ...
1
vote
2answers
272 views

Excel services refresh using Claims based NTLM?

I am able to upload reports in a sharepoint library that have embedded data connections to a cube(SQL2008\AnalysisInstance). We are not using power pivot. We are running Sql 2008 standard version. ...
1
vote
1answer
148 views

Can you build a SQL Analysis cube from term store taxonomy and user profiles?

We are using a term store taxonomy for the company organisation and each user profile has been tagged to a organisation taxonomy item. Now the demand is to view how many people are located in a ...
1
vote
1answer
240 views

sharepoint 2013 dashboard designer not connected to SSAS datasources

I created a new fresh SharePoint 2013 farm with two servers ( win 2012 R2) Application server ( running, secure store,performance point service, ) wfe server after that i created a simple BI site ...
1
vote
1answer
3k views

MSOLAPSvc.3 service missing from kerberos delegation

I'm trying to configure PerformancePoint using this article and Analysis Services is running and configured on that box, but the constrained delegation won't let me choose the MSOLAPSvc.3 service ...
1
vote
1answer
3k views

PerformancePoint 2010: Could not add an Analysis Service Data source in the Dashboard Designer

Environment: SharePoint 2010 on Windows 2008 R2 Standard + SQL Server 2008 R2, Dashboard Designer I was successfully able to add a standard SQL Table as a data source and create a Scorecard Dashboard ...
0
votes
1answer
22 views

#N/A in all fields

I'm trying to display my data in a dashboard from a cube. However the data displays as #N/A in all fields. However in VS I'm able to actually see the data. I'm sure this is probably a settings ...
0
votes
0answers
12 views

PerformancePoint: How to connect to sql/analysis services

I'm attempting to visualize list data as a chart. How would I go about requesting access/connecting to analysis services or an sql server table/cube? Much of my work is with sharePoint, so I'm not ...
0
votes
0answers
20 views

Post upgrade issues with PowerPivot

I'm testing the in-place upgrade process to get from SSRS and PowerPivot 2008 R2 to 2014. I've started by upgrading the POWERPIVOT instance on the first of my 4 SharePoint farm servers and everything ...
0
votes
0answers
158 views

PowerPivot Management Dashboard Processing Timer Job Fails

Been having an issue with our PowerPivot config that has plagued us. MS Support even has yet to resolve. So with much trial and error, we did successfully configure SSAS in SP mode, the service app ...
0
votes
1answer
411 views

Cannot Connect Cube with Sharepoint Dashboard Designer 2013

I have created a cube in SQL Server 2014 using the Adventure Works database and following the tutorial on msdn. Next, I deployed it through Analysis service to integrate it with Dashboard Designer on ...
0
votes
1answer
101 views

Review or Simulation to make user to have right access

When you work for a organization that has about 300 users in a SharePoint solution and I need to review if right user has access to right page to right information. Is there a simulation approach to ...
0
votes
1answer
1k views

Create Cube & Dimension from SharePoint 2010 List

I want to Create cube and dimension from SharePoint List and want to generate result using MDX on SharePoint List, so Please anyone can guide me how to import SharePoint 2010 List directly to SSAS ? ...
0
votes
1answer
18 views

Powerview doubleclick custom link

Is it possible to have a custom link in PowerView on a SharePoint page? For example, embedding JavaScript to open a custom dialog or anything else which would work..
0
votes
1answer
2k views

How to Create Analysis service Data Source for SharePoint Dashboard designer?

We don't have data warehouse, we want to add Reports in SharePoint dashboard designer from SharePoint list as data-source, but Reports accepts only analysis service as Data source. So can anyone ...