Support #12179: [SCP ID :##5948##] : Download Report BSNeBiz Transaction Enquiry - BSN CDB Support - Penril Support System

Support #12179

[SCP ID :##5948##] : Download Report BSNeBiz Transaction Enquiry

Added by Zahir Abd Latif about 3 years ago. Updated over 2 years ago.

Status:

Work Completed-End life cycle

Start date:

August 06, 2021

Priority:

Normal

Due date:

Assignee:

Zahir Abd Latif

% Done:

100%

Category:

Spent time:

Target version:

Description

Hi,
Kindly attend below request:-

Report took time to download and date filter not working

5948 - Download Report BSNeBiz Transaction Enquiry.pdf (1.16 MB) Nurul Athira Abdul Rahim, October 08, 2021 17:04

History

#1 Updated by Nurul Athira Abdul Rahim about 3 years ago

Assignee changed from Nurul Athira Abdul Rahim to Najmi Pasarudin

#2 Updated by Najmi Pasarudin about 3 years ago

Status changed from New - Begin Life Cycle to Development / Work In Progress

#3 Updated by Najmi Pasarudin about 3 years ago

% Done changed from 0 to 50

#4 Updated by Najmi Pasarudin about 3 years ago

% Done changed from 50 to 90

#5 Updated by Najmi Pasarudin almost 3 years ago

Status changed from Development / Work In Progress to Internal Testing
Assignee changed from Najmi Pasarudin to Nurul Athira Abdul Rahim

Issue:
IBAM > BSNeBiz Transaction Enquiry > Download take 2-3 minutes to download even after filter to 1 month data.

Finding:
BSNeBiz code re-use database object as report data.
This is a problem because database object has many relationships and requires time to setup in report file.
In production, it also takes more time to filter data according to BSNeBiz query.

Solution:
Only assigned selected database table column into report file.

Test steps:

Access IBAM > BSNeBiz Transaction Enquiry > Download. Do not filter anything in advance search.
Expected result, excel file is downloaded within a minute or less and content sync with IBAM screen
Repeat testing by filtering date by 1 month and 1 year