From Books Online:
Member Set (no mapping)
An additional way for you to manage dimensions by organizing dimension members. A flat member set has its members organized as siblings or a member set can be organized into a hierarchy as parent/child members. You must deploy your model site after defining or changing member sets to update the dimension
When you deploy a member set, you are actually deploying a copy of the dimension with a different structure. These sets can be used to set granularity of the fact data within a model/cube. You can have only one member set for each dimension assigned to a model, though you can create multiple member sets in each dimension.
For things like Exchange Rates, it may make sense to have separate global assumption models for Annual and Monthly exchange rates for granularity.
You may also want to sort the data in the dimension a different way, which is where a member set comes in handy.
Member View (no mapping)
Hierarchies of dimension members that are grouped according to member properties and they provide an alternative way to create reports on the members of a dimension using dimension member properties for analyzing groups of related members.
Member View is an essential feature of the Planning Business Modeler. It allows you to view a hierarchical order of the member properties and to get detail data related to it in a comprehensive manner. Member View is an option in Dimensions that helps to create reports, but not build models. Member View also enables you to calculate the sum of all the dimension members within the property. For instance, A car manufacturing company might have a product dimension, that has its members like sporting cars, family cars and so on. Here properties can be All Sporting Cars in Red. You can make use of the Member View to view the hierarchies of the dimension members that are grouped according to their properties.
With the application of Member View you can find the total sales of sporting cars at a particular level of dimension. Dimension members are the primary data for creating models but Member View is not used for building models. To create member views, you need to go to the Site Browser pane and select Dimension. On selecting a particular dimension, find Dimension Tasks to create a Member View. Just name the Member View in the dialog box provided and label it to identify later. The Description box should be filled with a short description of the Member View and you need to select a Member View. Add a property to the Member View and from here you can select the hierarchies for the properties. You can also select the Hide Members from View option if it is required. Finally click OK to save the Member View.
A member view is a subset or summarized version of the dimension members used in reporting. Member views are grouped by member properties. These are used to calculate sums and define hierarchies against member properties. Eg. Region - Country – City.
2 comments:
Hello, I still don't understand the meaning of a view. I use the Member Set to create hierarhy in the model and later view date in Excel. Where can I use the view? For reporting in Excel?
Regards, Matija
Here is another description of a member view.
http://69.89.31.82/~ppsblogs/?p=108
Yes, it's used for reporting purposes, not within models.
From Norm's blog.
Member Set (no mapping)
An additional way for you to manage dimensions by
organizing dimension members. A flat member set has its members organized
as siblings or a member set can be organized into a hierarchy as
parent/child members. You must deploy your model site after defining or
changing member sets to update the dimension
Member View (no mapping)
Hierarchies of dimension members that are grouped according to member properties and they provide an alternative way to create reports on the members of a dimension using dimension member properties for analyzing groups of related members.
Post a Comment