BISAMPLE : Using Aggregates

BISAMPLE : Using Aggregates

 

STEP : 1

Connection Pool > Import Metadata.

211

 

STEP 2 :

Select Tables,Keys,Foreign Keys & Views.

212

 

STEP 3 :

Import the highlighted tables.

213

 

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

214

 

Below Screen shot should appear.

215

 

STEP 4 :

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

216

 

STEP 5 :

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

217

 

STEP 6 :

Join F2 Revenue Aggregate with D1 Time Quarter Grain.

218

 

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.

219

 

STEP 8 :

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

220

 

STEP 9 :

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

221

 

STEP 10 :

File > Check Global Consistency > Yes.

222

 

STEP 11 :

Select Manage > Variables…

223

 

STEP 12 :

Action > New > Repository > Initialization Block.

224

 

STEP 13 :

Select on Edit Data Source…

225

 

STEP 14 :

Select Browse… in Connection Pool.

226

 

STEP 15 :

Select Connection Pool.

227

 

STEP 16 :

Below scree shot will appear.

228

 

STEP 17 :

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

229

 

STEP 18:

The below screen shot should appear after the Test.

230

 

STEP 19:

Click on Edit Data Target…

231

 

STEP 20 :

Click on New…

232

 

STEP 21 :

Enter Name as CurrentDay & click on OK.

233

 

Blow screen shot will appear :

234

 

STEP 22:

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

235

 

STEP 23 :

Click Test…

236

 

Below screen should appear:

237

 

STEP 24:

Close the Variable Manager Window.

238

 

STEP 25 :

File > Check Global Consistency > Yes.

239

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

 

Leave A Reply

Your email address will not be published. Required fields are marked *