Versions Compared

Old Version 36

changes.mady.by.user Adam Monsen

Saved on

compared with

New Version 37

changes.mady.by.user Adam Monsen

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Migrated to Confluence 4.0

...

  • Mockups should be updated with this, but if not, all heading names should follow Mifos terminology, or if there is a label, should use the Label name.
  • Example:  Loan Officers may be called Field Officers at the MFI, but the report should use Loan Officer to denote this.  (right now)..  In the future, we will want to allow the MFI to specify some of this for their reports separately.
  • Example:  MFI might call "Regional Office" something like "State Office", and they can define this in Mifos Labels.  References to Regional Office should say State Office.
  • The same applies also to Filter names.  Filters should grab either Mifos terminology or the label if that exists.
  • Right now it is not possible to pull label names but at least then the terminology we use in Mifos should be in the report.
  • File Naming
    • The name of the files for a report should have the same name as the report itself. The title of the report should match this. They should be consistent.
    • The name displayed in Pentaho should also be the same.
    • Remove the word "report" from the title.

Common Terms

  • Arrears Amount - instead of just Arrears, or Amount in Arrears
  • Principal Outstanding - instead of Outstanding Principal
  • Loan Amount - instead of Portfolio Amount, etc
  • Disbursal - instead of Disbursements

Parameters

  • Filters should be listed in the order in the mockups
  • They can be left to right
  • Each parameter should have a "Select One" at the top of each dropdown
  • Date dropdowns should have a From Date dropdown and a To Date dropdown
  • Date dropdowns should default to today's date
  • Reports should not run until the "View Report" button has been clicked 
  • If a filter has an "ALL" selection, that should be at the top after "Select One".
  • Then, all choices should be listed in alphabetical order.
  • If it's at all possible, display a msg to show that a report is loading if a report is a bigger one
  • Parameters should use CDF - see Loan Classification by Product report for example

...

Dashboards: current dashboard data should come from mifos database.  Dashboards showing data older than today need to look at the D/W database.

Report Design

  • See Loan Classification by Product v2 mockup in India Cloud folder for design example
  • Title of Report should be at the top
  • There should be a heading box with the parameters that were selected.  They should just list the name of the filter, and the filter selected.
    • Example: If there is a date range to select in the parameters, the header box should just list From: 2010-01-23 To: 2010-01-24.  No need to say Date Range
    • Filters listed in the box should be aligned and no need for the left and right blue boxes.
    • If there's an Office filter, it should be listed in the box as "Office: Branch 1" instead of "Branch:" in some reports
  • If a report has more than 7 columns, the report should be in Landscape mode. Else, Portrait mode
  • Report should always fit on A4 sheet
  • If there are multiple rows of data, have alternating shading of the rows for easier viewing
  • Headings of tables should follow the example
  • There should be page numbers on each page.
  • If a table spans more than one page, the headings should be repeated on the subsequent pages.
  • Versioning - the version of the report should be displayed in the bottom left corner of each page.  This helps in determining which report the MFI is looking at in case there are problems.  These versions should be tagged w/ the report in the git repository.
  • In the footer also list who ran the report.
  • In the footer list report date as well
  • Example footer: printed by: Kay on 2010-01-11.
  • MFI Name should be listed on the top right (same row as the Mifos logo) - there is no need to call out "MFI Name" - just listing the name of Head Office should be enough
  • Totals at the bottom should be bolded but have a white background.  (No dark blue)
  • Negative numbers should be listed with (#) - ie, a -500 should be listed as (500) in the report.
  • Fonts and sizes should be consistent across each type.  For example, all column headings in one report should have the same font and size.  All parameters listed in the heading box should also be consistent (but not necessarily consistent with column headings).
  • Capitalization should also be consistent.  If there is a "# of centers" and there's also a "# of Groups" then "# of centers" should be changed to "# of Centers".  Also column headings should be capitalized.  IE "# of Groups" instead of "# of groups" or "# of GROUPS"

Localization

  • Each report should be localizable.  This means that there should be a place with all the strings that can be translated and then plugged in for a specific language.  The reports themselves do not need to be already translated (yet)
  • (P2 - post 1.0) Filters should be localizable as well.
  • The properties file should be outside of the report zip:
    • You have to use resource-labels, resource-fields and resource-messages. However, you shouldn't set 'resource-identifier' field in these items.
    • You have to add the following property to your report's settings.xml:
      Code Block
      xml
      xml
      <property name="org.pentaho.reporting.engine.classic.core.ResourceBundle">
    org.mifos.bi.reports.yourReportName
</property>
    • Please add your properties files to mifosbi repository under reports/i18n/org/mifos/bi/reports/
    • You have to put (copy or link) this org directory in the classpath of your report-designer/biserver-ce

...