21 September, 2018
A shared member is used to create alternate hierarchies. The data for shared members come from the original member. There is no storage space reserved for the shared member. The below rules must be followed for shared members.
In this example, Soda is parent member and coke, Pepsi are child members. Coke has two child members, coke-1L and coke-2L. Pepsi has two child members, Pepsi-1L, Pepsi-2L.
In the report, we want to get the total for coke and also, we want to get the total for Pepsi. In another report, we want to get the total for 1L products and the total for 2L products. Essbase doesn’t allow duplicate records. To get 1L totals, create 1L parent and add coke-1L and Pepsi-1L as shared members. Create 2L parent in product dimension and add Coke-2L and Pepsi-2L as shared members.
Shared members increase the size of the outline.
To create shared members using Rules files, use Duplicate Generation reference or parent.
Child reference member.
To create the above outline, using parent-child reference method, use the source as mentioned.
The number will remain same. Click OK.
Once the rules files file is created, double-click the outline, click outline>update outline.
Another screen appears. Click find data file, locate source file. Click find rules file and locate the rules file. Select overwrite check box. click OK.
The above source file create a hierarchy which has + symbol next it 1L and 2L members. To give ~ symbol next 1L and 2L, use the below source file
Open data prep editor open source file. Map the first field to parent for products dimension click NEXT. Select the products dimension. Select property under field type. Click NEXT for last column, select child, click OK. Click options, dimension build settings and select “allow property changes ” select “use parent child reference method ” under build method. Click OK. Validate and save the rules file.
Shared members can also created using level reference method also
coke-1L coke-1L soda
coke-2L coke-2L soda
pepsi-1L pepsi-1L soda
pepsi-2L pepsi-2L soda
open data prep editor, open the above source file. Map the first column to level for products dimension. Enter number 0 in the number field. Click next. Select level under field type. The level member increases to 1 automatically. Click next. Select products dimensions. Select field as duplicate level. The number will be only. Click next select products dimensions. Select level under type. The number increases to 2. Click options, dimensions build settings. Dimension build settings tab again. Select use level reference method. Click OK validate and save the rules file.
This method automatically creates ~ symbol on shared member parent. (EX: on 1L and 2L )
In this example, quantity parents has only one child and it need not to get calculated from.
Child, instead it simply refers the value from opening in 0 field. There is no storage.
Space reserved for “quantity ” member.
In this example, quantity parent has three child members but only opening inventory has + operator and the remaining member has ~ operator. Quantity simply referable from opening inventory field. there is no storage space reserved for “quantity” member.
TekSlate is the best online training provider in delivering world-class IT skills to individuals and corporates from all parts of the globe. We are proven experts in accumulating every need of an IT skills upgrade aspirant and have delivered excellent services. We aim to bring you all the essentials to learn and master new technologies in the market with our articles, blogs, and videos. Build your career success with us, enhancing most in-demand skills .