BISAMPLE : Creating Logical Dimensions With Parent Child Hierarchy
STEP 1 :
Right Click on Connection Pool > Import Metadata.
Select Tables,Keys,Foreign Keys and NEXT.
Import the highlighted Tables into BISAMPLE.
The imported tables will appear under BISAMPLE as shown in the below screen shot.
Select Tools > Update All Row Counts.
Rows will be updates automatically.
Put the cursor on the table name,the updated count will appear as show in the below screen shot.
Right click on any table > View Data…
The table data can be viewed.
Right click on any table > New Object > Alias…
Create Alias as shown in below screen shot.
Create Alias for all the 3 imported tables as shown in below screen shot.
STEP 8 :
Right Click on the imported tables > Physical Diagram > Selected Objects Only.
Join D52 Sales Rep Position to D50 Sales Rep as per the below screen shot.
Create BMM Layer : Right Click on Sample Sales > New Object > Logical Table…
Name the Logical Table as D5 Sales Rep.
Drag rows from D50 Sales Rep(Physical Layer) to D5 Sales Rep(BMM Layer).
Right Click D50 Sales Rep > Rename.
> Rename as LTS1 Sales Rep
> Drag rows from D52 Sales Rep Position to D5 Sales Rep.
Drag DISTANCE from D51 Sales Rep Parent Child to D5 Sales Rep.
STEP 15 :
Rename DISTANCE to Closure Distance.
STEP 16 :
Select D5 Sales Rep & F1 Revenue > Right Click > Business Model Diagram > Selected Tables Only.
STEP 17 :
Join F1 Revenue to D5 Sales Rep.
STEP 18 :
Right Click D5 Sales Rep > Create Logical Dimension > Dimension with Parent-Child Hierarchy…
STEP 19 :
Enter in the Name box H5 Sales Rep & Click on Browse… as shown in the below screen shot.
STEP 20 :
Click on View…
STEP 21 :
Confirm Sales rep Number is selected for D50 Sales Rep_key.
STEP 22 :
Select Browse for Parent Column,rename it as D5 Sales RepDim.
> The Browse window shows the columns other than the member key.
> Deselect Show Qualified Name.
STEP 23 :
Select Manager Number as the parent column for the parent-child hierarchy.
Below Screen shot should appear.
STEP 24 :
Click on Parent-Child Settings…
STEP 25 :
Select Parent-Child Relationship Table button.
STEP 26 :
Select the D51 Sales Rep Parent Child.
STEP 27 :
In the Parent-Child Relationship Column Details set the columns as per below screen shot :
STEP 28 :
Expand H5 Sales Rep.
STEP 29 :
Delete all columns from the Detail level except for Sales Rep Number & Sales Rep Name.
Step 30 :
Create a new key named Display Key,map it to Sales Rep Name & click on User for Display(follow the below screen shot).
STEP 31 :
Select F1 Revenue > Sources > LTS1 Revenue & follow the below screen shot > OK.
STEP 32 :
Drag D5 Sales Rep from BMM to Presentation Layer under Sample Sales.
STEP 33 :
Rename D5 Sales Rep to Sales Rep.
STEP 34 :
Rearrange the Seqence as per below screen shot.
STEP 35 :
Double Click on H5 Sales Rep > Display Columns,confirm that Sales Rep Name is there.
STEP 36 :
File > Save > Check Global Consistency.
Fix if any errors or warnings before proceeding.