FINBI PROD: GL KPI Income Statement and Balance Sheet is not working
When checked for the time filter Monthly -Adj1 2010, the below query is getting executed for fetching the DATE_FLD and its corresponding DATE_KEY?s but the DATE_FLD value is ?NULL? in the table ?DIM_DATE_GREG? Query : SELECT DATE_FLD,DATE_KEY,YEAR,MONTH_IN_YEAR,WEEK_NUMBER_THIS_YEAR,QUARTER FROM DIM_DATE_GREG WHERE DATE_FLD=(SELECT MAX(DATE_FLD) FROM DIM_DATE_GREG WHERE YEAR = 2011 AND MONTH_IN_YEAR =13 GROUP BY YEAR,MONTH_IN_YEAR) Hence the KPI is resulting with No records found, Please update the same to the customer
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 is FINBI PROD: FINBI ARC PROD instance experiencing downtime?
When we analyze any KPI that contains more data then Java Heap Space exception occurs. In such case kindly select less number of filters and analyze the KPI. Also, increase the Tomcat Memory setting to overcome this problem.
The crosstab KPI is not working. Why?
The reason might be the measures selected in the KPI are dimensional measures, and there are no base measures to display week wise. If you add one base measure, the same crosstab KPI will work properly. If you require further help, please contact the ...
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, ...
The new filter for manual KPI is not working
The default value for the filter must have been 'ALL' instead of number. So, change the default value to number in 'ADMIN_FILTER_DEFINITION' table in the admin database.