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

learn more… | top users | synonyms

3
votes
1answer
3k 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 ...
0
votes
1answer
15 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 ...
0
votes
1answer
18 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 ...
0
votes
1answer
64 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
1answer
30 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 ...
2
votes
0answers
81 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
0answers
18 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
0answers
32 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
0answers
23 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 ...
1
vote
0answers
20 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
0answers
73 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 ...
1
vote
0answers
37 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 ...
0
votes
0answers
7 views

BI Dashboard Designer edit filter

I am all new to SP and BI. I was given access to a BI SP site, where there is a drop-down list. This list looks like to be derived from a content item in the PerformancePoint Content list. I found ...
0
votes
0answers
13 views

External Data Refresh Failed

SharePoint BI Center, using OData feed to connect to using SharePoint API and retrieve list data then use it in excel to display power pivot chart. Error shows when refreshing the connection: ...
0
votes
0answers
102 views

SharePoint SSIS integration using oDATA Connection

I have been trying to integrate SharePoint & SQL/SSIS thru oData connection. I was able to integrate successfully once using above combination without any problems. I was able to extract data ...
0
votes
0answers
28 views

Graph-able Counts on a SharePoint List

I'm attempting to create a graph (or other visual indicator) for the status of purchase requests as they move through our OotB SharePoint 2010 site. We have developed a complex infopath form for new ...
0
votes
0answers
28 views

Sharepoint List to Excel Update Excel Webpart

I have a list that is over the 5000 view threshold. The thought process was to export this to an Excel file, run Pivot Charts and then show the charts on a SharPoint Page using the Excel Webpart. ...
0
votes
0answers
37 views

Sharepoint 2013 BI (Excel Services) - How to target the filter to a certain audience?

We have an environment that contains Windows 2012 Servers and an Active Directory, SQL Server 2012 and Sharepoint 2013 on Premises. Powerpivot has been configured and the Business Intelligence Center ...
0
votes
0answers
94 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 ...
0
votes
0answers
40 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 ...