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

2
votes
1answer
2k 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
0answers
34 views

Create Chart (Pie, Column, Bar) in PP Designer Dashboard

Need help. I was asked to create simple chart by using data from excel workbook, sharepoint list, sql database. I was able to connect to excel workbook, sharepoint list, sql database and view data in ...
0
votes
0answers
12 views

Reporting Service: SQL Agent Status can not be determined

I am configuring Reporting Service application on my SharePoint environment, I have installed Reporting Service SharePoint AddIn onto my Application server, when i go to Provision Subscription and ...
0
votes
1answer
632 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 ...
0
votes
0answers
51 views

SharePoint postback error message on BIDS report

When deploying my report in SharePoint 2013, I got the following error message: Report parameter values must be specified before the report can be displayed. Choose parameter values in the ...
1
vote
3answers
3k 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
0answers
103 views

PerformancePoint 2013 Dashboard Library Default Content Type

Yesterday, I ran into an issue trying to migrate my PerformancePoint 2013 dashboards from my test/dev farm into production using the Export/Import option. Previously, doing so did not present any ...
0
votes
1answer
90 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 ...
0
votes
0answers
9 views

Sharepoint 2013 Business Inteligence - Connection Formula

How to connect with Excel filter from Dasboard creator? I have got a Dashboard with unique filter, and i wan't to pass connection parameter with Connection formula. How a Connection formula works?
0
votes
1answer
258 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
2answers
4k 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 ...
0
votes
0answers
60 views

Pivot Table Operation Failed business intelligence Sharepoint 2013

If i try to interact with Power Pivot in the Sharepoint Site It shows me error Pivot Table Operation Failed. I tried with gogle and search a lot of samples but nothing works.
1
vote
1answer
104 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 ?
0
votes
1answer
155 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 ...
1
vote
0answers
46 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
0answers
110 views

How I can fix columns row in sharepoint gridview?

I use SharePoint 2013 and Performance Point Service for business intelligence. I have a GridView in my page and I want after scrolling page , I can see name of my columns. I have a Grid like this ...
1
vote
1answer
63 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. ...
1
vote
0answers
24 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
1answer
53 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
0answers
31 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
3answers
129 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
1answer
612 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
0answers
61 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
1answer
565 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 ...
0
votes
1answer
30 views
5
votes
4answers
4k 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
1answer
52 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?
5
votes
1answer
306 views

Difference between KPI and Scorecard?

What is the difference between KPI and Scorecard with respect to SharePoint 2010?
0
votes
1answer
28 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
3answers
79 views

Sharepoint BI Learning = where?

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