Welcome to MSDN Blogs Sign in | Join | Help

Browse by Tags

All Tags » Filters   (RSS)

Excel 2010 is better than the PPS Planning AddIn

Posted Thursday, October 15, 2009 10:00 AM by petereb
Although the model of using an Excel AddIn can be a little clunky (especially for what PPS Planning called the contributor scenario) I think my team did a pretty good job getting some very usable reporting elements. Now I get to point you to things my Read More...
0 Comments

Radio Silence

Posted Friday, July 17, 2009 4:00 PM by petereb
Well radio silence has been maintained quite successfully. Sorry for the lack of updates but with Planning development ended I haven't had a lot to say… Office 2010 (aka Office 14) is finally starting to see the light of day. I know some of you by now Read More...
1 Comments

HOWTO: Dynamic rows or columns with a dimension property filter

Posted Monday, May 12, 2008 4:00 PM by petereb
To filter rows and columns by a filter selection has previously been discussed here . But one thing you might not have noticed is that the list of property values (aka the filter scope) is static. If a new member property appears the form needs to be Read More...
0 Comments
Filed under: , , , , ,

HOWTO: Filter rows and columns by selecting from a filter

Posted Friday, May 09, 2008 4:00 PM by petereb
(Sorry for the gap since my last post, things have been a bit busy lately in Peter Eb. land…) One simple way to do this filtering is to enable suppress blank rows or suppress blank columns. Then when there is no data (non-null) in the cube for those rows/columns Read More...
2 Comments
Filed under: , , ,

HOWTO: Hide filters for dimensions that confuse users

Posted Thursday, April 24, 2008 4:00 PM by petereb
For data entry forms (and even some reports) its pretty important to keep contributors focused on their specific task. Its especially easy for users who are not familiar with OLAP or PPS to be confused by some things: "TimeDataView" and "Business Process" Read More...
7 Comments

What does the error "filter selection for dimension XYZ is not in the filter scope"?

Posted Tuesday, April 22, 2008 1:00 PM by petereb
This is a confusing error for users and form authors alike, especially since the add-in help does not have a glossary entry for "filter scope". I fear I came up with the error text, so I apologize. So to hopefully rectify this situation, we Read More...
1 Comments
Filed under: , , ,

HOWTO: Make 1 filter control more than 1 matrix

Posted Monday, April 21, 2008 2:00 PM by petereb
A common request by form authors is to create a "start here" worksheet page where contributors can change some global filters. Then they advance to other worksheets in the workbook to do their actual data entry. Other times authors just want to link multiple Read More...
4 Comments
Filed under: , , ,

Why not use the "where clause" for filters instead of "on pages"?

Posted Friday, April 18, 2008 3:00 PM by petereb
Short answer : In SP1 the PPS Planning add-in will use the where clause and life for MDX experts will be back to normal.* Long answer : Because of the extra properties needed for writeback. The CellSet returned by AdoMd.Net does not return member properties Read More...
5 Comments

HOWTO: Validate 2 filter selections match using a member property

Posted Friday, April 11, 2008 12:02 PM by petereb
A recent post by "abdulmohi" in the PPS Planning forums asked about linking or cascading filters. So that once one filter was selected, another filter would be updated to match the first. In abdulmohi's case it was obvious what the linkage should be because Read More...
2 Comments
 
Page view tracker