BISAMPLE : Using Aggregates

STEP : 1

Connection Pool > Import Metadata.

STEP 2 :

Select Tables,Keys,Foreign Keys & Views.

STEP 3 :

Import the highlighted tables.

STEP 3 :

Right Click on

> SAMP_REVENUE_FA2 > New Object > Alias… F2 Revenue Aggregate 

> SAMP_TIME_QTR_D > New Object > Alias… D1 Time Quarter Grain

Below Screen shot should appear.

STEP 4 :

Select D1 Time Quarter Grain,D2 Product & F2 Revenue Aggregate > Right Click > Physical Diagram > Selected Object(s) only.

STEP 5 :

Join D2 Product with F2 Revenue Aggregate as per the below screen shot.

STEP 6 :

Join F2 Revenue Aggregate with D1 Time Quarter Grain.

STEP 7 :

Drag the following columns from D1 Time Quarter Grain to their corresponding columns in D1 Time.

Note: Make sure to drag them to their corresponding columns & Rename the D1 Time Quarter Grain to LTS2 Time Quarter Grain.

STEP 8 :

Drag Units & Revenue from F2 Revenue Aggregate(Physical Layer) to F1 Revenue(BMM Layer).

STEP 9 :

Rename the F2 Revenue Aggregate logical table source to LTS2 Revenue Aggregate in BMM Layer.

STEP 10 :

File > Check Global Consistency > Yes.

STEP 11 :

Select Manage > Variables…

STEP 12 :

Action > New > Repository > Initialization Block.

STEP 13 :

Select on Edit Data Source…

STEP 14 :

Select Browse… in Connection Pool.

STEP 15 :

Select Connection Pool.

STEP 16 :

Below scree shot will appear.

STEP 17 :

Enter the SQL Query as per the below screen shot in the empty box and click Test…

STEP 18:

The below screen shot should appear after the Test.

STEP 19:

Click on Edit Data Target…

STEP 20 :

Click on New…

STEP 21 :

Enter Name as CurrentDay & click on OK.

Blow screen shot will appear :

STEP 22:

Create 2 more variable by repeating step 21 for CurrentMonth & CurrentYear.

STEP 23 :

Click Test…

Below screen should appear:

STEP 24:

Close the Variable Manager Window.

STEP 25 :

File > Check Global Consistency > Yes.

Congratulation!!!! You have successfully completed all the steps in development of repository.