The CIO Dashboard Financial Widget does not show Financial Year in the dropdown after Fiscal Periods setup to Month - Known Error

The CIO Dashboard Financial Widget does not show Financial Year in the dropdown after Fiscal Periods setup to Month Description On the CIO Dashboard there is a widget for Financial insight into the costs imported from the General Ledger.

After the Fiscal Periods have been setup, and data from the General Ledger is imported against the child fiscal period, for example FY17 M10 or October, when accessing the Financial widget on the CIO Dashboard, there is no ability to select the parent FY17 year within the dropdown to report progress over the entire financial year. The only options are the child fiscal periods.

Steps to Reproduce

1. Go to Fiscal Calendar -> Generate 2. Set Fiscal Unit to Month 3. Set end year to 2018 4. Generate Calendar 5. Import some values in the general ledger staged data 6. Go through cleansing, bucketing, allocation 7. Open CIO Dashboard, year is not an option to select, only month and quarter.

Workaround This is expected behaviour, CIO board is deprecated since Jakarta, and t he code is designed to show only the immediate parent in the Fiscal drop-list.

Since we set month in this case, we will see only its immediate parent - quarters.

As a workaround t o add Year to the drop list, please refer to the following code placed in the Script Include:

' ITFM_CIO_Dashboard '

/sys_script_include.do?sys_id=391d352387102100eb9b5d88e3e3ecb4

var year = gr.fiscal_year; if(!contains(rows, year.toString())) { var yRow = {}; yRow.name = year.getDisplayValue(); yRow.value = year.toString(); yRow.type = year.fiscal_type; yRow.startdate = year.start_date_time; yRow.enddate = year.end_date_time; rows.push(yRow); } The code should be placed between line 160 and 161. As this may vary in other instances, the modified script include file is attached .