Statement Cycle versus MTD, Financial/Banking Industry

parbie at 18h42
07
Sep
2010
Statement Cycle versus MTD, Financial/Banking Industry

Banking industry reporting requirements often call for viewing monthly data both on a calendar month and on a statement cycle. What are some best modeling practices for dealing with a snapshot of MTD transactions and Statement-Cycle-to-Date transactions? Is it common to have two types of snapshot fact tables, one rolled up at the monthly and one rolled up from previous statment date to current statement date?

I a
About
This topic belongs to the forum
  • Data Warehousing and Business Intelligence based on dimensional modeling and the Kimball Lifecycle.

  • Numbers of topics : 1858
  • Numbers of messages : 8714
  • Numbers of users : 3801
  • Numbers of points : 1672
Similar topics
Hi, I want to build a Enterprize Banking Data Model. So I want to know the basic conformed dimensions for the different subject areas of Loan Application, Payments, Customer contacts, Account Balances. Can you provide me with any documents or a standard
Hi Please help me how to do this condition: I need to do the below condition gotoIf -->If the Page is A--> Target1 gotoIf -->If the page is B--> Target2 Just let me know how to check if the page is A then one set of code need to be executed if i
Dear community, I would like to ask you for helping me with a star data model / reporting problem. The simplified data model is: FACT_SALES (DATE_ID, PRODUCT_ID, CUSTOMER_ID, PLANT_ID, SALES_AMOUNT) DIM_PRODUCT (PRODUCT_ID, PRODUCT_NR,
Hello, I am looking for a list of dimension tables to track historical changes on for a banking data warehouse, based on "best practices". Customer is a prime candidate. Are there others? Thanks, Ike
We recently purchased a industry specific physical BI data model from a vendor. Along with the physical data model, this purchase also included ETL support from the vendor and canned reports that were designed by the vendor. There has been quite a bit o
Forums from same category
See also
more_less
Informations

4 Replies For the topic :
"Statement Cycle versus MTD, Financial/Banking Industry"

This topic has been viewed 1875 times.

Last message :
07/09/2010 at 18h42 by "parbie"