How to handle "As Of Reports" by Microsoft SSIS process, SSAS cube and SSRS report?

Vote count: 0

A simple scenario:

A bank named aBank. The aBank has multiple customer accounts. Each account has multiple transactions. There are only two types of transactions: Deposit and Withdraw.

In the source database, there are two tables: AccountInfo (Id, AccountCode) and Transaction (Id, TransDate, TransType, TransAmount, Balance).

Now the management team would like to have a report in SSRS to show the balance of the whole bank as of an input date.

For example, they want to know the balance of the whole bank in 2010-03-05 or yesterday.

What is a good practice to design the SSIS package, the SSAS cube and the SSRS report?

Thank you.

asked 10 secs ago

Albert Wang

Let's block ads! (Why?)

How to handle "As Of Reports" by Microsoft SSIS process, SSAS cube and SSRS report?