Questions tagged [business-intelligence]

It is a set of theories, methodologies, processes, architectures, and technologies that transform raw data into meaningful and useful information for business purposes

Filter by
Sorted by
Tagged with
5 votes
1 answer
8k views

SharePoint Online & Excel Services -> unable to refresh data connections

I'm trying to create a few very simple reports based on my SharePoint Online data using Excel. I've got as far as getting the data into Excel and creating my report, and now I'm trying to upload the ...
2 votes
1 answer
365 views

How to enable Power View in SharePoint 2013?

I use SharePoint 2013 and Performance Point Service for create Business Intelligence report. But I need more functionality in report generation. I found that Power View in this scenario can help me. ...
0 votes
0 answers
2k views

Publish Report From SAP BO to SharePoint Online

How can scheduled reports from SAP BO on-premises be published to a document library in SharePoint Online?
0 votes
2 answers
1k views

Do we need separate Unattended service account for each SharePoint Server 2013 BI service applications?

SharePoint 2013 - I'm planning to use 'unattended service account' method of Secure Store Service - for Excel, Performance Point and Visio services. I'm about to create Active directory accounts for ...
0 votes
1 answer
33 views

Any issues using BI and Project Server together on a SP2016 Farm?

We have a consulting vendor suggesting that the Farm NOT contain both BI and Project Server due to issues they've encountered in the past (I think SP2013). So I need to know if its "ok" to have the ...
1 vote
1 answer
5k views

Error in the data model when refreshing external data in Excel

I have a BI Center site, I'm trying to open an Excel sheet in the PivotView gallery but it gives me this error: Workbook cannot be opened I have uploaded the Excel sheet in another library but it ...
0 votes
1 answer
470 views

How to migrate the Project Web App 2010 site collection and BI center from farm A to farm B

We have 2 farms, both have Project server service application installed. I want to migrate all the project data as well as the BI center (with reports) from one farm to another. I have moved the 4 ...
0 votes
1 answer
96 views

Business Intelligence Center Prerequisites

I have a SharePoint 2013 Farm where the Business Intelligence Center template does not appear in Central Administration when creating a new site collection. We have Standard license key entered when ...
1 vote
1 answer
359 views

Cannot import date values in SharePoint list using SSIS

I'm using SharePoint 2013 and SSIS-Sql server 2008 r2. Excel is a data source and Sharepoint list is the destination.I have simple transformations and the data is copied to List. I can see all column ...
1 vote
0 answers
99 views

Sharepoint dashboards interaction

On a SP BI solution there are two dashboards, both interactive. The wish is when someone click on a field in the left dashboard, an action is happening in the right dashboard, that is, sorting the ...
1 vote
3 answers
9k views

Add a status indicator column in an OOTB Project Tasks List?

We have an OOTB Project Tasks List that works great for our needs. However I was looking to make it a little more quicker and easier to read. I would like to add a column called "status" and have ...
5 votes
1 answer
42 views

Error refreshing external data

I have an Excel sheet that retrieves data from a SharePoint list. I want to display this Excel sheet in my BI center, however it gives me this error that SharePoint lists are not supported Is ...
1 vote
0 answers
44 views

Using business intelligence to generate reports

We have a custom database and some web application for our clients, I will develop a interface for them to generate report(s). They will have options to select -- which will in result query a single ...
1 vote
0 answers
45 views

How can I have end-users visualizing different dimensions from the same Powerpivot on same excel file?

I need help to understand if it is possible to have end-users visualizing different dimensions from the same excel file published in Sharepoint 2013. I have a data warehouse in SQL Server 2012 and I ...
0 votes
1 answer
34 views

Business Intelligence in visual studio for Sharepoint SSIS

The Business Intelligence option in missing in visual Studio. What I need to install to have this option?? I assume I need to install SQL server full package. But can we achieve the business ...
2 votes
4 answers
2k views

SharePoint 2010 Insights (PerformancePoint): '401 Unauthorized' error on invoking 'Run Dashboard designer'

Environment: SharePoint 2010 on Windows 2008 R2 Standard + SQL Server 2008 R2 I am trying to setup the BI infrastructure Lab as outlined in this article: http://technet.microsoft.com/en-us/library/...
0 votes
1 answer
58 views

BI in SharePoint 2013?

I started learning BI in SharePoint, I'm not understanding where to start and I do not know what are all the possible options I can try, what I can leverage. I see lot of different categories and ...
1 vote
0 answers
76 views

SQL Error 18456 state 8 on SharePoint Excel Services

I installed SQL Analysis Services. I want to test it via Excel Services on SharePoint. I created new account with which I can easily login to SQL Server Management Studio: the username and password ...
1 vote
1 answer
4k views

PowerPivot Data Refresh not Working After Adding Pivot Table

I have a spreadsheet with a powerpivot data model in sharepoint 2013 sp1 with sql 2012 sp2 for the power pivot instance. The power pivot data refresh works fine when scheduled, when the spreadsheet ...
0 votes
1 answer
466 views

Can't create Performance point data source at subsite level

I cannot create PPS data source(DS) at sub-site level. For example : when I am creating DS at site : https://mysp.a.b then everything works. When I am trying to create DS at subsite : https://mysp....
0 votes
1 answer
2k views

Pivot Table Source Data in Separate Excel Workbook stored on sharepoint

I have an excel spreadsheet on the sharepoint server with my Main Data that I want to analyze. I want to make a pivot table from this sheet that will update when the Main Data is updated, but I need ...
5 votes
2 answers
1k views

Difference between KPI and Scorecard?

What is the difference between KPI and Scorecard with respect to SharePoint 2010?
1 vote
1 answer
209 views

Can Anonymous users view dashboards reports from a BI site in SharePoint 2013?

In SharePoint 2013 : Does anonymous access support for BI sites where dashboards are deployed using Performance point services and SQL Server analysis server? Where as in SharePoint 2010 this ...
0 votes
0 answers
162 views

Business Intelligence Center Create

I want to create Business Intelligence Center. I follow this steps: Configure a Business Intelligence Center When you create and configure a Business Intelligence Center, you create a new ...
1 vote
0 answers
120 views

LOB apps in SharePoint online?

I have been playing around with the SharePoint 2013 app model lately. Maybe it is because I used to build Farm soltuions for on premise installations, but I miss the opportunity to build LOB apps for ...
0 votes
1 answer
925 views

Adding column in Status indicator

I have requirement that adding one more field in the Status indicator list view programmetically.is there way to extend the Staus indicator list using programmetically?.How can i acheive this? Any ...
1 vote
3 answers
5k views

Unable to Refresh the Excel Connection in Excel Webaccess Webpart

I am using an excel workbook with pivot in it. I am using the Excess webpart to display it. As I click on the Refresh all data connection. It throws an error.The scree shot is attached. I have ...
0 votes
1 answer
311 views

Sorting a scorecard by default

I am using SharePoint Server 2013 and Performance Point Dashboard Designer 2013. I know that in a Scorecard we can sort values interactively by enabling it in View Settings. But is there any way to ...
1 vote
1 answer
731 views

Creating a KPI in Dashboard Designer

[Using SharePoint 2013 Enterprise SP1] I am trying to create a KPI in Dashboard Designer, and finding surprisingly little documentation for all its features. (Ok, maybe I'm pretty jaded and not that ...
1 vote
1 answer
359 views

Business Intelligence Center

I don't see a site template to Business Intelligence Center. How could to turn on this template ? I don't see any icon of Busines Intelligence. Is my version to low ?
1 vote
0 answers
52 views

How I can create child windows in Performance Point Service in SharePoint 2013?

I use Performance Point Service in'SharePoint 2013 for create BI Reports from SSAS. I need to create some reports that have child window. Like in this picture: Can I create a report like this? And ...
2 votes
1 answer
93 views

how do i publish a chart built in bis to another sharepoint site

I have been playing around with creating dashboards and charts using Performance Point services in the Dashboard Designer. I got the documentation on how to create them and built a couple in my BI ...
0 votes
0 answers
50 views

Customized User and Graphical Interface for reports's website

If I have about 80 reports from SSRS that need to be applied to different website at SharePoint's intranet. Let's say about 20 for a webpage, 50 for a another webpage and 10 reports in a another ...
3 votes
3 answers
157 views

Should "BI Center Site" be used for any areas that will include a mixture of data content

We have a SP farm set up and it is in it's infancy. Our department is BI. There are 10 products within our company, each with different management and BI needs, therefore we'd like to create a site ...
0 votes
1 answer
1k views

New SQL Server Report Data Source Type

I am trying to create a Report Data Source to connect a traditional relational database for reporting. The connection is successful but when I try to create a Power View report, it gives me an error "...
2 votes
0 answers
97 views

SharePoint Onine List as Datasource to Excel Services / Business Intelligence in SPO

Trying to join 2 SharePoint Custom Lists sources into an excel Services Graph. If so, any BI option for formating list data on an SPO page? Possible now under SPO 2013 A3 license? Confused about ...
1 vote
1 answer
826 views

how to add a BISM content type

I'm using Microsoft SharePoint Server 2010. I want to create a BI Semantic Model Connection file but no BISM content type exists. According to these technet instructions http://technet.microsoft.com/...
0 votes
1 answer
49 views

Is there a way to create a status list in a template different than Business Intelligence?

Can I have a status list without having to create a business intelligence center site?
7 votes
4 answers
10k 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 ...
0 votes
1 answer
78 views

What is calculated KPI

What is calculated KPI? I am not looking for "how to create it" but rather its concept. What exactly it is? How do you define calculated KPI if someone asks?
0 votes
1 answer
43 views

Extending Web Application for BI

My web application has 3 site collections. The 3 site collections are based on the Business Intelligence template. Everything is working fine using windows auth. The solution requires me to extend (...
0 votes
3 answers
89 views

Sharepoint BI Learning = where?

Where can I find video material to learn about Sharepoint BI? I'm newbie in this area.
0 votes
1 answer
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 ...
0 votes
2 answers
538 views

Cannot add new item to "Performance point content" list?

When I click on add new item the following modal dialog appears for a few seconds and disappears. When I tried from another Browser - Chrome it prompted a download but wouldnt download with the ...
2 votes
1 answer
3k views

SharePoint Online and Business Intelligence

Is it possible to create a Business Intelligence Center Site Collection in SharePoint Online? Is Performance Point available for SharePoint Online? Where do I find more info about SharePoint Online ...
0 votes
1 answer
892 views

Possible to "drill down" to a SSRS report using Performancepoint analytics charts?

I would like to open either a reporting services report or a SharePoint list when clicking a pie chart in a Performancepoint dashboard. This would replace the "standard" functionality of drilling ...
1 vote
1 answer
3k views

How to develop a business intelligence dashboard?

What are the basic needs to develop a business intelligence dashboard in SharePoint 2010 or in MOSS 2007 (I have both)? Do I need to install any services? I want to monitor different tender proposals ...