Oracle Business Intelligence

Products Banner

Account transaction and account measures

Received Response
1
Views
2
Comments

Hi All,

I have account and account transaction tables with following columns.

account: account_id, avilable_bal, pending_bal

Account transation: txn_id, account_id, amount, txn_date etc.

I have designed in BMM layer like this.

pastedImage_1.png

I have joined account as inner join in acc_transaction table.

But for measures (In Fact table) avail_balance, pending balance i mapped like this.

AVAIL_BALANCE:

pastedImage_2.png

PENDING_BALANCE:

pastedImage_3.png

when i run the report getting current results.

pastedImage_4.png

I mapped "ACCOUNT"."PENDING_BALANCE"  for both ACCOUNT and ACC_TRANSACTION tables (for both measures as shown above)

Do i require to map both tables in both measures?

Answers