Tagged Questions

a business intelligence server integrated with SharePoint. Includes PerformancePoint Server 2007, which was an addition to SharePoint 2007, and PerformancePoint Services 2010 and 2013, which is included with SharePoint.

learn more… | top users | synonyms

0
votes
1answer
33 views

SharePoint 2010 Performance Point & PowerPivot Software Requirements

We're currently looking into SharePoint 2010 and we're decided what we need as a business. We're at a point where we are looking to upgrade our MS SQL Server from 2008 to SQL 2012 Enterprise Edition ...
0
votes
1answer
40 views

sharepoint dashboard Designer

I have enabled the Business Intelligence center in my sharepoint site. Once i done that. I tried clicking the "RUN DASHBOARD DESIGNER". It is not opening the dashboard designer.exe. It is showing me ...
0
votes
1answer
54 views

How to set a default value to a filter in performance point?

I have a issue while defaulting a value to a filter in performance point. In the filter right now I have three things: ALL, INVISIBLE ACCOUNTS, VISIBLE ACCOUNT. when I deploy the dashboard to ...
1
vote
0answers
58 views

Group Similar elements in PPS Graphs using MDX query - SharePoint 2010

Hi All, I am trying to generate a report using PPS in SharePoint 2010. We have sem at the bottom axis. SQL table is like this. m1 m2 sem year 43 40 A F 70 99 A R 79 70 A F 13 22 A R 35 30 ...
0
votes
1answer
45 views

Generating reports using PPS-SharePoint2010

Hi All, I need to generate some reports (bar graphs, pie charts etc) using Performance Point Service in SharePoint 2010. I am able to generate reports. I am facing issue when I am ...
0
votes
1answer
44 views

create a performancepoint predefined chart list to select users as they wish

I have requirement for a MSBI dashboard which have pre designed charts, scorecard so that user can customize there dashboard as they want by selecting them from library, can this be possible in ...
1
vote
0answers
75 views

MDX for inner query Max Date filter

I need to create MDX query for a PerformancePoint report based on following SQL, any ideas? pointers? SELECT count(*), sum(balance) FROM SerialBalance b WHERE balance > 0 AND EffectiveDate = ...
0
votes
0answers
62 views

In Azure - Dashboard Designer connectivity to an SSAS data source

In MS Azure, when I started preparing PerformancePoint Services on SharePoint 2013, the first step listed was Install ADOMD.NET from the SQL Server 2012 Feature Pack I could not install ADOMD.NET in ...
0
votes
1answer
198 views

Performancepoint cascading filter connection formula in MDX

I have dimension with hierarchy A - B and a time dimension. I have made 3 different filters from that dimension in Performancepoint 2010, to use as cascading filters. Cascading works fine, but ...
0
votes
1answer
52 views

Retrieving a PerformancePoint dashboard in Windows 8 application

I am using SharePoint 2013 and Windows 8 application. Is it possible to connect to a PerformancePoint dashboard via the application and display items like the dashboard, graphs with drill to/drill ...
0
votes
1answer
97 views

PerformancePoint data source from Oracle

I have a requirement to create KPI and dashboard for which all data comes from Oracle. I am looking for getting this data into PerformancePoint to create KPIs.. Can anybody point me to the right ...
0
votes
1answer
31 views

Can't Display different Database

Goal: Select a specific database named contoseRetailDW based on the list of different database in Peformance Point Dashboard application. Problem: The servername is correct but unfortunately a list ...
0
votes
0answers
50 views

YearToDate filter does not work in web part page

I make 4 time intelligence filters : month (year-1).month yeartodate and yeartodate-1 I make test report and then a dashboard that connects the two. When I deploy the page all works as expected. But ...
0
votes
0answers
97 views

Improving Filters Performance in Performance Points Services 2010

We currently have a set of Dashboards using SSAS (Tabular Mode) as it's only data source, the performance of the Pages and reports are excellent with the exception of two page. These two pages uses a ...
0
votes
1answer
49 views

An exception occurred while analyzing a cell in the decomposition tree

I am facing an issue with decomposition tree in PPS error: an exception occurred while analyzing a cell in the decomposition tree how to fix this issue and what is the cause of this issue???
1
vote
1answer
348 views

SSRS Impersonation for Datasource

I am working to deploy a reporting solution using SSRS and PerformancePoint. I have 4 databases I have pull from. 3 I have full control over the other I only have an additional domain account that has ...
0
votes
0answers
250 views

SSRS report in PerformancePoint dashboard not rendering competely

I've got a PerformancePoint dashboard in SharePoint 2010, and at this stage it's comprised solely of a single Reporting Services report, and a PerformancePoint filter. The report contains a Matrix ...
0
votes
1answer
45 views

Is it possible to connect multiple scorecards to a single analytic chart in PP 2007?

I know how to connect a scorecard to a chart in PerformancePoint but I am not sure connecting multiple scorecards is possible by any means? To connect a scorecard to a chart, I simply place them in ...
1
vote
0answers
354 views

Sharepoint 2010 Enterprise (PerformancePoint) KPI using multiple data sources

Sharepoint 2010 Enterprise (PerformancePoint) KPI using multiple data sources I am attempting to create a KPI that uses multiple data sources, with the “actual” data coming from an analysis services ...
0
votes
1answer
214 views

PerformancePoint 2010 filter calendar not default to the current date

I just migrated PerformancePoint from 2007 to 2010. Everything is working fine except the calender filter which is based on Time Intelligence Connection Formula. The first time the page is accessed, ...
0
votes
0answers
116 views

SharePoint BI Row-Level Security

I am currently architecting a solution that involves utlising the SharePoint 2013 BI stack (PerformancePoint services etc) on top of SSAS cubes to provide Business Intelligence. I have two classes ...
0
votes
0answers
65 views

How can I make a copy of PerformancePoint 2007 dashboards for another environment

I want to make a copy of a set of dashboards and deploy them on the same server but in a subfolder. I could create a workspace in dashboard designer with all the required dashboards and publish ...
0
votes
1answer
149 views

Format Number in an Analytic Chart / Performace Point

Is it possible to specify the format of numbers in an analytic chart? So far, I know it's possible to give a number that belongs to a dashboard. Not so, to an analytic chart.
0
votes
1answer
133 views

Connect a Time Ingelligence Filter to Scorecard's Current Date — is it possible?

In PerformancePoint 2013, there's two types of Time Filters -- Time Intelligence, and Time Intelligence Connection Formula. The latter lets me connect the filter's "Current Time" property with a ...
0
votes
0answers
187 views

Sharepoint Dashboard Designer - Performance Point Analytic Charts

Is it possible to create an analytic chart with 2 distinct Data Sources (e.g. 2 distinct cubes )?
3
votes
0answers
114 views

How to read and display PPS scorecard comments (Annotations) programmatically?

I have created a scorecard using the Dashboard Designer. My requirement is to display the scorecard comments in a separate Web Part. So that the user can view the comments without right clicking and ...
0
votes
0answers
73 views

Way to store the Webservice Output to SQLite DB?

I am consuming a webserivce from where i need to load some dictionaries like currencylist with rates, I need to store them in to my local DB. I am using sqlite to store the library, Using Java for ...
0
votes
1answer
134 views

Easy way to modify incoming filter value from Sharepoint List?

Does anybody have a quick and dirty solution for this? I have a Sharepoint List Filter with values like: Information Technology Accounting Human Resources etc. The filter values need to be sent ...
0
votes
0answers
437 views

PerformancePoint filter to Sharepoint list

When I create a PPS filter using member selection, I choose "All", "1", "2". Let's call these Departments. I create an Analytic Grid, and when I create a connection to the filter in the dashboard, I ...
1
vote
0answers
139 views

Performance Point: Change the width of an item of the Decomposition tree

I need to expand the width of the items on the decomposition tree silverlight control. There are names in the SSAS cube that need to be shown on the decomposition tree without the need to view the ...
0
votes
2answers
97 views

Analytical chart does not display data

I am working on an analytical chart in PerformancePoint. I linked a filter (2 levels of hierarchty) to this chart with the following formula: <<SourceValue>>.children Using this formula ...
0
votes
1answer
597 views

MDX - Get the last 3 members of the selected member

I am pretty new with MDX so please bear with me. I am designing an analytical chart with PerformancePoint in which the bottom(X) axis will display a date range. The displayed date range will depend ...
2
votes
1answer
234 views

SSAS Controls with decomposition tree

I am currently working on an BI solution and I need to make some design decisions. We have already made the ELT process and have designed the cube in SSAS so now we need to present the data to the end ...
1
vote
1answer
429 views

SharePoint 2010: How do I connect FilterWebPart with ReportViewWebPart

I have the requirement to add performance point filter web part and report view web part to a page in SharePoint 2010 programmatically. I can add both web parts to the page however I have no idea on ...
1
vote
0answers
130 views

PPS in sharepoint 2010 error for analytic grid “The length of the string exceeds the value set on the maxJsonLength property. ”

I am using performance point and using the member filter connected to analytic grid.In the connection formula I have written something like below Drilldownleveltop( Drilldownleveltop( ...
1
vote
1answer
762 views

MDX query top 10 on several levels

Is there anyway that we can get the top 10 throught out the hierarchy instead of top level in MDX. I would like to write an MDX query which pulls the top 10 at each level in the hierarchy. Please let ...
0
votes
0answers
816 views

Creating a Custom Web Part Filter that Sends Data to a PerformancePoint Filter

I'm using Sharepoint 2010 and PerformancePoint, programming my webparts in C#. I am trying to create a web part that will allow me to send a plaintext (with a text box), filter value to an already ...
0
votes
1answer
259 views

Top 10 Filter Dashboard Designer

I am using performance point for showing reports in Sharepoint 2010 BI center. My requirement is to show top 10 items for all the hierarchy levels by default. User should not right click and select ...
2
votes
1answer
165 views

Proclarity on Performance point [closed]

My company wants to use Microsoft ProClarity, as I am new to BI I am not sure how to answer these question: Is ProClarity still available with standalone license? ProClarity is available on ...
0
votes
1answer
295 views

Cannot choose default parameters in Dashboard Designer

I've created a report in Report Builder 3.0 with parameters, and when I add it to the dashboard designer, I can see all the parameters from the report, but I cannot change it from <Default ...
0
votes
1answer
70 views

Parent-Member Indication that 1 (or more) Children are currently selected in a multiselect filter

Is there a setting for PerformancePoint multi-select filters that will give the user a visual queue that child members are currently selected? For example, in the image below, "2012-Week02" is the ...
0
votes
1answer
737 views

SharePoint 2010 with PerformancePoint, Excel Services and Reporting Services References

I've recently been tasked with becoming the SharePoint 2010 expert. However, to also include PerformancePoint Services (PPS), Excel Services and integration of Reporting Services(SSRS). Key points ...
0
votes
1answer
745 views

Linking two analytical charts in PPS

Is it possible to link two analytical charts on a dashboard? For example I want to be able to click on a bar in one analytical chart and have it show another analytcal bar chart depending on which ...
0
votes
1answer
259 views

Inconsistent roll up behavior in a PerformancePoint grid object

I have a basic dashboard which consists of a single "grid" object displaying 3 measures across time broken up by a business unit hierarchy... When filtering on a single item in any of the levels in ...
0
votes
1answer
616 views

PPS / Performance Point Date Range for Scorecards

How do I go about adding a From and To date range to a scorecard and analytic report? It doesn't seem to be well documented anywhere (including PPS books!) but surely a basic requirement for any ...
0
votes
1answer
144 views

how to calculate % in PPS 2010

i have these columns in the table and made this table as the FACT table and also using time intelligence filter in the PPS2010.. i have measures , sum (materials), sum (sales) and sum (material_%) in ...
1
vote
2answers
186 views

Performance Point Data Source

Working in Performance Point 2010, trying to get the data source connected to a new Scorecard. Ive created a data source from my SSAS cube and I can create a scorecard, but I want to be able to place ...
1
vote
2answers
972 views

Sharepoint Claims/c2wts issues with Performance Point/Excel Services

I have created a custom claims provider to allow users to sign into SharePoint from an existing website. This issues claims including a claim of UPN in the format username@domain. The user can log in ...
0
votes
2answers
1k views

Performance Point Filter Problem After Instillation SharePoint 2010 SP1

I am annoyingly facing Web Control Rendering error after deploying SharePoint 2010 SP1 and Aug 2010 patch. I have created Custom Performance Point Filter as per Pps2010RefSample provided by Microsoft ...
0
votes
1answer
1k views

SharePoint Performance Point Custom Filter Renderer Class Error

I have two servers (Server A and Server B) in one SharePoint 2010 farm. I am getting following error on SharePoint Dashboard page while using the custom PPS filter webpart on Dashboard. I have used ...

1 2 3