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?
