Tag Archives: Named Sets

Named Sets are dimension members or set expressions that are created with reuse in mind. Many of these named sets would make great dashboard filters, but there is no easy way within PerformancePoint to easily make this happen. In the example we’ll use today, there will be some named sets built around the Time dimension of a time and billing cube. The concepts shown here could easily be used with other types of dimensions. While the Time filter in the PerformancePoint dashboard would allow you to setup the sets we will establish for this example, think in terms of more complicated logic that could not be so easily set. For example, a client might want the “Last 5 Working Days”, or “Last Full Sales Cycle”. These sets would require a more complex MDX solution. I am going to use a dimension to simplify the data sourcing, but you could just as easily skip the “Create Utility Dimension” section and just modify the data source to a SQL table for your Named Sets filter.  
Read more...