When working with an OLAP data source, the BI user may need to get a summary view of the data and understand the distribution of dimension members across a hierarchy or buckets. With the SAP Business Objects 4.0 Universe one can define measures in the information design tool to profile OLAP members across a level-based hierarchy, a parent-child unbalanced hierarchy or an attribute hierarchy. Such measures may be a simple count like number of products or a ratio like percentage of females. With the SAP Business Objects 4.0 Universe one can also define buckets like profit range or age group using MDX objects such as calculated member and named set. Follow the URL below to see the MDX constructs involved and the many examples of profiling and bucketing put into practice.

http://www.sdn.sap.com/irj/scn/index?rid=/library/uuid/d0d486e9-e124-2f10-b3b7-f5a7a1c46e24