performancepoint

What is the best book for learning PerformancePoint?

I'm tasked with providing data from my company's application to be used by PerformancePoint, so I wanted to find out as much as I could on how to use it effectively (so I can prepare my data accordingly). I've done some nosing around on der Intarweb, but wanted to find a book I could get that I can eventually use as a reference. Anyone h...

How does licensing model work for Microsoft Office PerformancePoint Server 2007?

Hi All, I am confused about the licensing model for Microsoft PerformancePoint Server. When I look at http://www.microsoft.com/business/performancepoint/howtobuy/default.aspx I see a 20,000 USD Server License, plus a 200 USD CAL license. But the language is a bit vague about what this means-- is CAl required for any user looking at r...

Performance Point, Dashboard Designer....

I am brand new to this product. Microsoft has some good free videos...but I am looking for a site where I can ask question about 'how to', or post problems..any recommendations? (http://www.microsoft.com/business/performancepoint/resources/training.aspx) Just in case this is a good site for that... I want to bring in a sql table t...

SQL Server does not exist or access denied error

I have an application that runs fine when executed off the server. When clients try to connect, they receive the following error: Failed to get data. *Data provider could not be initialized *SQL Server does not exist, or access denied on my Office Web Components (MDAC). I am guessing there is some security or server configuration error...

how to disable field list at runtime in performancepoint?

i have a dashboard that i am displaying, and whenever my users click on a pivotchart or pivottable the field list automatically pops up. how can i prevent this from occurring? ...

custom database query in sharepoint using active directory username as filter

Hello, i have a custom query in a database which i want to display to users in a MOSS via performancepoint webpart. I need to filter the report based on the username of the logged in user. How can i pass the AD username to the performancepoint webpart? Thanks ...

PerformancePoint and Sharepoint list as a data source

I was asked to create a very simple dashboard using a Sharepoint list as my data source using the Dashboard Designer tool. I can create the datasource, retrieve the list and see the data in a tabular format. Now, when I try creating a KPI or a ScoreCard out of that list, I get a 'Unable to retrieve list' error. Has anybody else run in...

MDX - TopCount plus 'Other' or 'The Rest'

I have created an MDX query which calculates the TOP 10 ZipCodes (according to my Patient Stay measure) as such: WITH MEMBER [Discharge Date].[Y-M-D].[ Aggregation] AS 'AGGREGATE( EXISTING { [Current Month] } )', SOLVE_ORDER = 0 SELECT NON EMPTY { [Measures].[Patient Stays] } ON COLUMNS, TOPCOUNT({ ORDER( HIERARCHIZE( { [Patient].[By...

Importing Analysis Services 2008 KPI's in a PerformancePoint scorecard

I am trying to import a KPI from Analysis Services into a PerformancePoint Scorecard, and when I do, The Dashboard Designer throws an error: An unknown error has occurred. If the problem persists contact an administrator. There may be additional information in the server application event log. When I examine the event log, ...

MOSS and Reporting Services

Can I provision reporting services reports to MOSS 2007 or do I need to use Performance Point? Would love to hear how people have done this. ...

Custom SQL queries in PerformancePoint DashBoard designer

Is it possible to utilize the data that is returned by a CUSSTOM SQL query on a database to create the DasshBoard elements ? So far i was ablle to connect to a specific Table and use it in AS IS form ( no interaction with multible tables ) Any pointers in this topic would be much appreciated. Thanks, IP. ...

Make scrollbars disappear in PerformancePoint Strategy Map

I have a PerformancePoint 2007 strategy map that displays in Visio Viewer within the browser. I can right-click the map and hide the toolbar & the scrollbars. When I refresh they come back. How do I set the default view of Visio Viewer to hide the toolbar and the scrollbars? ...

Installing Office 2007 breaks Data Retrieval Services in Dashboard Designer

I had Office 2003 & Dashboard Designer installed. I was creating a bunch of reports in dashboard designer that started by creating a data source using Microsoft's Data Retrieval Services to connect to a SharePoint list. I installed Office 2007 and I no longer can create a data source using Data Retrieval Services. I reinstalled Microso...

Unable to Deploy PerformancePoint Dashboard Page to SharePoint 2007

I'm creating a PerformancePoint (henceforth PP) Dashboard that contains a web report to be deployed to the a SharePoint web application that I had created. I followed the instruction in the link below. Deploy a PerformancePoint dashboard to a SharePoint site In summary, following the instructions in the link, I published the Dashboard ...

How do I expose Excel 2003 Spreadsheets to PerformancePoint 2007?

I am working on a PerformancePoint 2007 project. I have a bunch of Excel spreadsheets, and I need to get at the data. The users need to continue to enter data, they have Excel 2003, and I won't be here forever. If the users had Excel 2007 I could just use Excel Web Services in MOSS 2007, but that's a no go. What are your recommendati...

Can I change the display value of my fields coming in from SharePoint?

In Dashboard Designer I have created a pivot chart based on data in a SharePoint list, using the Microsoft Data Retrieval Services to connect. My column name is something like Number of Allocated Items but this field is displayed in the chart legend as Sum of Number_0020_of_0020_Alloca. This is really annoying, especially since my data...

Installing PerformancePoint in a distributed topology

I have to install PPS in a SharePoint farm. The SQL 2008 server hosts db, analysis, and reporting. The SP servers are 2 WFEs (Load-balanced) and an app server. They want to install PPS on the app server. In order to do this, do I still have to install PPS on the SQL box in order to get the databases on there for Planning Server? Same ...

PerformancePoint Dashboard Designer Error when creating a Filter - No Filter Data Retrieved

I'm attempting to create a filter using PerformancePoint's Dashboard Designer. After going through the wizard, however, the "Confirmation" page displays the following message: No filter data retrieved Warning 1: Filter was created but no data was retrieved. To resolve the problme, follow the step(s) below. 1. Verify that t...

Why ParameterizableWebPart get returned as an ErrorWebPart?

Hi All, I'm using WSS3.0 API to get all the webparts in an ASPX page. The following is my code: SPFile page = web.GetFile(pageGuid); SPLimitedWebPartManager wpm = page.GetLimitedWebPartManager(PersonalizationScope.Shared); WebPartFactory factory = new WebPartFactory(); fo...

Changing PerformancePoint Time Intelligence Post Formula Default Value

Is there a way to change the default value of the Time Intelligence Post Formula?? I have a Dashboard where I use From Date and To Date filters, to calculate the values between the user selected period, for those filters I use the Time Intelligence Post Formula,however the default when the user enters the page is always today's date on ...