Task #3475
Data warehouse report
| Status: | Closed - End of life cycle | Start date: | September 30, 2013 | ||
|---|---|---|---|---|---|
| Priority: | Normal | Due date: | January 24, 2014 | ||
| Assignee: | % Done: | 50% | |||
| Category: | - | Spent time: | 10.00 hours | ||
| Target version: | - |
Description
pending Bank User to confirm the requirement
CR Pembuatan Table EDW Bridge untuk Aplikasi IBS - Internet Banking.doc (115 KB)
IBS performance.xlsx (10 KB)
EDW Requirement.docx (114 KB)
AppConfigEDW.properties 
(754 Bytes)
History
#1
Updated by Rayvandy Gabbytian about 11 years ago
- File CR Pembuatan Table EDW Bridge untuk Aplikasi IBS - Internet Banking.doc added
- File IBS performance.xlsx added
- File EDW Requirement.docx added
- Due date set to September 25, 2013
- Status changed from Pending Customer Feedback to New - Begin Life Cycle
- Start date set to September 10, 2013
Chee Ping,
New requirement has been acquired from Daniel Kwan. He does not specifically gives the header (what field) to include in the report. Because he insistly saying that the report can be altered according to M2U database design.
However there are some mandatory information that M2U could not provide currently, like how many times user do link/unlink account, click account & summary , etc. I would like to discuss further with you about this. Let me know if you have time to do this, else need to find more resources to do it.
Attached is the complete requirement: EDW Requirement.docx
CR Pembuatan... . doc = Sample of master table report
IBS performance.xlsx = Sample of "how many clicks" toward each of every service mentioned in report
#2 Updated by Anonymous about 11 years ago
to exclude the # of transaction/activity click by customer. if they wanted, it will issue a proposal. the rest still the same.
#3
Updated by Tan Lee Yong almost 11 years ago
- Due date changed from September 25, 2013 to October 03, 2013
- Assignee changed from Ngoh Chee Ping to Wijaya Kartono
- Start date changed from September 10, 2013 to September 30, 2013
#4
Updated by Wijaya Kartono almost 11 years ago
- Status changed from New - Begin Life Cycle to Pending Review
- Assignee changed from Wijaya Kartono to Ngoh Chee Ping
- % Done changed from 0 to 90
Hi Chee Ping,
Added reports:
- Bill Payment
- Interbank FTT
- Interbank Fund Transfer
- Mobile Reload
- Own Account Transfer
- Time Deposit Placement
- Western Union
- Mobile Reload
- EDW Statistic
#5
Updated by Ngoh Chee Ping almost 11 years ago
- Status changed from Pending Review to Development / Work In Progress
- Assignee changed from Ngoh Chee Ping to Wijaya Kartono
Finished review. But those report not able to get records after run using MainReportGenerator.java. Please fix it.
#6
Updated by Wijaya Kartono almost 11 years ago
- Assignee changed from Wijaya Kartono to Ngoh Chee Ping
Hi Chee Ping,
FYI, Please make sure to delete record in IB_RPT_LIST before generate report for particular date.
E.g. Delete record for 25/10/2013 in IB_RPT_LIST to generate report for 25/10/2013.
#7
Updated by Rayvandy Gabbytian almost 11 years ago
- Status changed from Development / Work In Progress to Pending UAT Deployment
- Assignee changed from Ngoh Chee Ping to Rayvandy Gabbytian
#8
Updated by Tan Lee Yong almost 11 years ago
- Status changed from Pending UAT Deployment to User Acceptance Test
#9
Updated by Rayvandy Gabbytian over 10 years ago
- Due date changed from October 03, 2013 to January 13, 2014
- Status changed from User Acceptance Test to Development / Work In Progress
- % Done changed from 90 to 100
Update enterprise data warehouse report, esp on the method written in hibernate,
improves searching criteria based on IBDateTime,
put appconfig outside the application.
#10
Updated by Rayvandy Gabbytian over 10 years ago
- File AppConfigEDW.properties added
- Status changed from Development / Work In Progress to Pending UAT Deployment
- Assignee changed from Rayvandy Gabbytian to Saputra Febhy Toomy
- % Done changed from 100 to 0
Mas Toomy, please deploy it in UAT. please take note that now the AppConfigEDW. properties must be put/loaded from /export/home/wasadmin/applications/AppConfig/. Attached is the properties file you can use for UAT.
#11
Updated by Rayvandy Gabbytian over 10 years ago
- Due date changed from January 13, 2014 to January 24, 2014
- Status changed from Pending UAT Deployment to Development / Work In Progress
- Assignee changed from Saputra Febhy Toomy to Rayvandy Gabbytian
- % Done changed from 0 to 50
Already handed over the Header format of EDW content to Wahyu, waiting for him to review. However, edw statistic report is now showing 0 count record, need to fix it ASAP.
#12
Updated by Rayvandy Gabbytian over 10 years ago
- Status changed from Development / Work In Progress to Closed - End of life cycle
For new update on EDW report progress, please refer to case in https://hub.penril.net/redmine/issues/4251