Show Data Members on Parent-Child Hierarchy

Author: Kepion Product Team

Introduction

In the MODELER, you can enable the MembersWithData feature from SQL Server Analysis Services (SSAS). This feature is useful when data is assigned to parent members of a Parent-Child (PC) Hierarchy and you need to show their data as separate members on your Forms.

Example

Let's explore a scenario where we have sales people tracking their total sales. Each sale is associated to a sales person, as shown below.

If we organize the sales members to their reporting structure, we get the following. Notice that it is difficult to see the "sales" associated with Sales Person 1, because it is showing the aggregation of the children members in addtion to its own.

With Data Members enabled, the same report will show the following:

From the MODELER, select a Member List that is configured in Hierarchy mode. Under the MANAGE tab, check the MembersWithData (SSAS) checkbox. 

Note: Be sure to deploy the application once you have this feature enabled.

Now, you can configure your reports to show the full PC hierarchy, including the Data Member for each parent member in the hierarchy.