Why does the FINBI KPI AR - Billers Transaction Count report generation taking a long time?
The KPI you are analyzing refers to viewsql to fetch data. To reduce the time taken for report generation, alternatively create this view in the database so that retrieval of data will be faster from the database. Once this view is created in the db, delete the viewsql of the aggregate table- 'VW_AR_BILLERS_TXN_COUNT' in the 'oracle.dbmodel.xml' file.
Related Articles
Why does FINBI PROD: KPI YOY AR Comparison taking a very long time?
The query has to be optimized to solve the issue. Please check the below query and optimize it to improve the performance: SELECT DIM_AR_TXN_TYPE.TXN_TYPE_CODE,DIM_AR_TXN_TYPE.TXN_TYPE_DESC,DIM_DATE_GREG.MONTH_NAME,SUM(TRANSACTION_COUNT)"C1734", ...
Why the KPI is taking long time to laod?
If there are a large number of pre-selected values which are saved as part of filter, the KPI might not respond at times as it has to pre-load and read the object containing such large number of filter values. You could select these filter values ...
Why does KPI grid loading takes long time and makes the browser hang?
After about 500 rows loaded into the KPI grid, the application will stop responding and displays a script error. Then, after a brief period the control to the IE will resume back. The resolution to this Issue is shared as below: - There is a ...
Login Page: New Products added taking longer time to Load
The portlet - 'New Products Added' available in the login page is meant to view a list of products for last 1 week/1 month etc. We have observed that there were close to 320 Products in the last 1 week. Therefore, the login page is taking longer time ...
KPI grid loading takes long and makes browser hang.
We have rectified this Issue. After about 500 rows load into the KPI grid, the application will stop responding and displays a script error. Then, after a brief period the control to the IE will resume back. The resolution to this Issue is shared as ...