Dale, I applied the sql script (attached) to your data and the ETL ran and I could see data for all the reports (however, sometimes I had to use a future date to pick up data e.g. center schedule by loan officer).
At a command prompt you type mysql -uUSERNAME -pPASSWORD mifos < dalefix.sql or you can copy the lines from the attached file and run it in any sql GUI you have. The problem was the use of single quotes in some of the office names (i.e. its a bug). However, if you can live without single quotes in the office name the attached sql fix is all you need to do (it translates single quotes for `) As I said previously, I use Mifos BI 1.3.1 and I think you should (and probably have to) too. You can get the latest Mifos BI release here (1.3.1): Mifos BI https://ci.mifos.org/hudson/job/bi-1.3.x-archive/lastSuccessfulBuild/artifact/mifos_bi-1.3.1.zip There's not a single install for mifos BI 1.3.1 but since you have already installed Mifos BI 1.2 you can upgrade just by unzipping the downloaded zip and following these instructions. 1/ In your biserver-ce\pentaho-solutions delete directories commonActions, Dashboards, DashboardsMenu, dataAccess, standardReports 2/ from unzipped directory mifos_bi-1.3.1\reports copy directories commonActions, Dashboards, DashboardsMenu, dataAccess, standardReports into you biserver-ce\pentaho-solutions 3/ from unzipped directory mifos_bi-1.3.1\reports\CDFReportingTemplate copy *.html into your biserver-ce\pentaho-solutions\system\pentaho-cdf 4/ from unzipped directory mifos_bi-1.3.1\reports\CDFReportingTemplate copy *.jpg into your biserver-ce\pentaho-solutions\system\pentaho-cdf\resources\style\images 5/ in your biserver-ce\tomcat\webapps\pentaho\WEB-INF\classes delete directory org 6/ from unzipped directory mifos_bi-1.3.1\reports\i18n copy directory org into your biserver-ce\tomcat\webapps\pentaho\WEB-INF\classes 7/ in pentaho server, do a Tools/Refresh/Repository Cache before testing any reports It's a hassle copying and deleting files but hopefully you'll be fine. If not, or if there are still issues with your reporting, let me know and I'll send you back my skype details or some other way that I can share the screen with you. John On Mon, Jul 23, 2012 at 3:21 PM, Dale Fuertes <[email protected]> wrote: > 23 July 2012 > > > Hi John, > > Here is the backup file (zip) and log file. Earlier was not zipped, just > knew of the 750kb limit. > > Thanks so much. > > > > Regards, > > Dale A. Fuertes-Pham > Email: [email protected] > > >
dalefix.sql
Description: Binary data
------------------------------------------------------------------------------ Live Security Virtual Conference Exclusive live event will cover all the ways today's security and threat landscape has changed and how IT managers can respond. Discussions will include endpoint security, mobile security and the latest in malware threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/
_______________________________________________ Mifos-users mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/mifos-users
