Darius, This is unfortunate. So, if my starting point is to expose these services, is there some guidance Mike or you could give me on where to begin? Do you have a pattern for REST services that you would like followed? I definitely would like to discuss when you all slow down and have a chance to assist. In the meantime, I'll plug around the wiki and reporting code and see what I see :)
Gretchen Moran Enterprise Architect and Technical Account Manager [cid:[email protected]]<http://www.pentaho.com/> The Commercial Open Source Alternative for Business Intelligence 5950 Hazeltine National Drive, Suite 340 * Orlando, FL 32822, USA +1 407 812-OPEN (6736) * 407 517-6206 * 321 848-8207 Get your free download today at http://www.pentaho.com<http://www.pentaho.com/download>. From: Darius Jazayeri [mailto:[email protected]] Sent: Wednesday, October 19, 2011 4:09 PM To: Gretchen Moran Cc: [email protected] Subject: Re: Spiking on the Pentaho Report Designer OpenMRS datasource We don't yet have REST web services for this, but that seems like the way to go. That could be added directly in the reporting module, allowing you to use the pentaho designer with OpenMRS as long as you know the url/port. We would probably also want to create a small "reporting.pentaho" module that would allow you to run those reports from within the OpenMRS UI. -Darius On Wed, Oct 19, 2011 at 10:56 AM, Gretchen Moran <[email protected]<mailto:[email protected]>> wrote: Hi guys, In the interest of attracting others who might be interested, I've replied to the list to continue our conversation. Your comments below Darius make perfect sense and I think represent a feasible and constructive target. If Mike could work with me to speed up finding the best way to query the OpenMRS system for the functions you mention, I would be very grateful. To give you all a primer on what is available on the Pentaho Reporting SDK side - There are two very small but key interfaces that we will need to implement to get a Pentaho report to consume a cohort/dataset combination: the DataFactory interface, which handles interacting with the source of the data, and the TableModel interface, which is the interface that the engine expects an implementation of after having queried the DataFactory for data. The DataFactory interface methods all account for parameterization; as such, as long as our DataFactory implementation processes the parameters that are handed to it, the engine (and the Report Designer tool) already recognize and allow parameter definition and pass them along to the engine that would process the query (which in our case is OpenMRS, which layer I'm not certain yet). Interestingly enough, for a spike or POC, we may not need to implement our own DataFactory, as the Report Designer already exposes a DataFactory that is a Java RMI DataFactory. Simply put, you can reference any Java method that returns a TableModel and use the DataFactory as is, which already has the UI bits in place in the Report Designer. This isn't an end product, but can quickly allow us to test feasibility of the feature set. There is another, newer DataFactory called the Sequence DataFactory that exposes similar functionality that I will look into. The Pentaho Reporting SDK also has some lower level DataFactories that we may want to consider extending. There is a HQL DataFactory and an SQL DataFactory. I mention these because I am not certain at what level or with what protocol I should be talking to OpenMRS. So that leads to my questions: Is there a service (http, REST, WSDL, other) that will allow me to retrieve the results of the functions that Darius lists below? If not, what is your recommended approach for communicating between a client tool and the OpenMRS system? HQL? Straight JDBC? A few hints (as Darius offered :) ) as to where to begin to interrogate the code would be greatly appreciated! Thanks so much for your time, Gretchen From: Darius Jazayeri [mailto:[email protected]<mailto:[email protected]>] Sent: Tuesday, October 18, 2011 6:43 PM To: Gretchen Moran Cc: Michael Seaton Subject: Re: Welcome back! Update Okay, we can definitely have a brief framing discussion if that would help. My quick thought is that we want to expose some things from the reporting module. In the report tool you would pick 1. a cohort definition 2. a data set definition And in pentaho you'd then get a data set with (usually) the cohort definition as the rows and the data set definition as the columns. (For each of those choices you'd need to provide values for any parameters, and ideally also being able to link them to parameters in the pentaho report.) Mike can point you to the right Java snippets for all these if that would help... "list all cohort definitions" "get the parameters for one particular cohort definition" "list all data set definitions" "get the parameters for one particular dataset definition" "evaluate a cohort definition" "evaluate a dataset definition against a cohort" -Darius _________________________________________ To unsubscribe from OpenMRS Developers' mailing list, send an e-mail to [email protected] with "SIGNOFF openmrs-devel-l" in the body (not the subject) of your e-mail. [mailto:[email protected]?body=SIGNOFF%20openmrs-devel-l]
<<inline: image001.gif>>
