Account transaction and account measures

User_JL3CW

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.

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:

PENDING_BALANCE:

when i run the report getting current results.

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?

User_JL3CW

some one help is most appreciated..

User_JL3CW

found solution.