Filtering with Attribute Functions

You can use filters to restrict access to data for base members sharing a particular attribute. To filter data for members with particular attributes defined in an attribute dimension, use the attribute member in combination with the @ATTRIBUTE function or the @WITHATTR function.

Note:

@ATTRIBUTE and @WITHATTR are member set functions. Most member set functions can be used in filter definitions.

For example, assume that user PJones is assigned this filter: Access: None. Member specification: @ATTRIBUTE(“Caffeinated_False”).

The next time user PJones connects to Sample.Basic, his spreadsheet view of first-quarter cola sales in California (Figure 147, Results of Filter Blocking Access to Caffeine-free Products) shows that he has no access to the data values for any base dimension members associated with Caffeinated_False. Sales data for Caffeine Free Cola is blocked from view. Note that Caffeine Free Cola is a base member, and Caffeinated_False is an associated member of the attribute dimension Caffeinated (not shown in the above spreadsheet view).

Figure 147. Results of Filter Blocking Access to Caffeine-free Products

This images shows a spreadsheet in which Sales data for Caffeine Free Cola is blocked for the user.