PerformancePoint Server 2007 SP2 Now Available

The following Microsoft Office PerformancePoint Server 2007 SP2 products are now available on the Microsoft Downloads Center. PerformancePoint Server 2007 SP2 (64-bit) on MS Downloads PerformancePoint Server 2007 SP2 (32-bit) on MS Downloads PerformancePoint Server 2007 Management Reporter SP2 on MS Downloads Note: We are also releasing a script from MS Downloads, which PerformancePoint Server…

12

ProClarity 6.3 SP2 is now available

The ProClarity 6.3 SP2 is now available from the Microsoft Download center.  Attached to this blog you will also find the following documents (if you are at the blog home page, click on the posting header to see the attachment): ProClarity 6.3 SP2 ReadMe Requirements Installing ProClarity 6.3 SP2 on Microsoft Windows Server 2008  …

1

Filters for Tabular Data Sources and Tabular Filters Explained

When using a tabular data source your first thought may be to use the Tabular Values filter type in Dashboard Designer when wanting to apply a filter to your data source.  However, the Tabular Values filter, admittedly poorly named (we are working on that), should not be used when creating a filter to apply to…

3

Extending the Business Intelligence Conversation with Twitter

In an effort to coalesce all of the discussions that are taking place across the Social Network about PerformancePoint Server 2007 and our other Business Intelligence applications and platforms, I’ve created a Twitter alias: microsoftbi. I’ll be linking to relevant blog posts, videos, Web pages, and forum threads that offer new or interesting takes on…

3

Mapping Dashboard Filters to Analytic Charts and Grids

Been asked about this capability a bit recently, so thought I would create  post specifically around this topic. When creating  Analytic Charts and Grids you have 2 ways to create these.  First, using the Analytic View Designer (AVD – design tab) or second, by manually entering MDX on the Query tab. Analytic View Designer Queries…

4

Get Model meta data for a model site from Planning database

While most of Planning system’s meta data is stored in native relational tables in the Planning database, there are some meta data is stored in xml format in the database, for example, model meta data. You may need to get model meta data from the Planning databases. Here is a sample SQL query to get…

1

Get CurrentPeriod value for each model inside a model site from Planning DB

While most of Planning system’s meta data is stored in native relational tables in the Planning database, there are some meta data is stored in xml format in the database, for example, Current Period for each model inside a specific model site. You may need to get CurrentPeriod value for the model from the Planning…

0

Turning off the Toolbar in Excel Services Report Views

When integrating Excel Services Report Views into your PerformancePoint dashboards it is possible to control whether the Excel Services toolbar is displayed or not.  To adjust the settings, open the Excel Services report view in Dashboard Designer.  Click on the Edit tab and click on the Toolbar Options button in the ribbon. Selecting “Full Toolbar“,…

0

Free Form Text Search Filter – Sample

Patrick Husting and his team have extended the code sample on our blog and created a Free Form Text Search Filter for PerformancePoint – if you are interested in this capability, I encourage you to take a look at his recent post: http://performancepointinsider.com/blogs/bsm/archive/2008/09/16/creating-free-form-text-search-filters-for-performance-point.aspx   Alyson Powell Erwin alysonp@microsoft.com

5