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