Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to model 1 conformed dimension and 2 facts (Facts are kind of snowflake)

Sunny86Jan 5 2017 — edited Jan 10 2017

Hello All,

We have 3 tables.

Customers

LoanDetails

RepaymentDetails

How i can model this . Suppose i have to generate a report for customer wise loan amount and repayment amount how can i calculate it?

Now for example

Customer Steve got two loans from bank

Home loan - 1000USD

Car loan - 200 USD

in repayment table he has entries for his repayment every month. For example in 2016 he paid 12 times every month.

So now i joined like below

Customer - > Loan Details

Customer ->RepaymentDetails

But when we use sum(loanamount) and sum(repaymentamount) for steve in report it is totalling the 1000USD + 500 USD 12 times ..

Hope my explanation is clear. any help will be highly appreciated.

Thanks

Stv

Locked Post

New comments cannot be posted to this locked post.

Locked on Feb 7 2017

Added on Jan 5 2017

#business-intelligence-applications, #business-intelligence-foundation, #business-intelligence-suite-enterprise-edition-obiee

12 comments

856 views