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
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
HmongThoobNtiajTeb. com/
Free forum : hi. Free forum : 2709rsgamboa6219. Free forum,
Free forum : Forum IT Teknik Komputer dan Jaringan SMKN 1 SLAWI
LEGO Island Discussion, modding, news and more!
Techy Boards, a growing technology discussion forum! For fans of nintendo, xbox, playstation or anything else!
Search
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"






