ernestoo

What is MongoLab?MongoLab is a hosted MonoDB service that offers one free database to developers wanting to learn the technology. It's a very elegant way to start learning or developing a small application. I started using this earlier in the year and had created a couple of collections on it. What is the MongoDB Aggregation Framework?Traditionally in SQL databases you have the concept of a GROUP BY and an aggregation function like average or sum. In MongoDB, aggregation wasn't ever as easy, in order to do any aggregation you'd have to write your own complicated MapReduce jobs. Along comes MongoDB version 2.2, which includes the aggregation framework. So consider this SQL statement: SELECT sum(duration) FROM calls GROUP BY disposition And here it is translated to MongoDB, I've attempted to color code the translations: }runCommand: { aggregate : 'calls', pipeline : [ { $group : { _id : '$disposition', durations: { $sum : '$duration' } } } ] }} Easy enough! There's much more to this of course. Here's a great reference: http://docs.mongodb.org/manual/reference/aggregation/ MongoLabs and Aggregation FrameworkSo to use this on MongoLabs you'll have to start a new database, old ones are on an older version, according to this helpful article All free/starter databases created after Nov 30, 2012 will be running 2.2.x will have Aggregation Framework Support Why Do I care? Well I had some mongoDB Jaspersoft samples that would bring in an entire un-aggregated dataset into memory and then use the JasperReports library to do aggregations in-memory. This is fine and dandy if you're dealing with tens of thousands of records. When you move into millions of records this becomes a bit harry and I'd rather my database do the work! So using my example query from above, I was able to create this very cool looking report in iReport:http://3.bp.blogspot.com/-HzfF8TdDjGs/UMHe79U7pGI/AAAAAAAACtc/fnzJR9libs0/s640/Screen+Shot+2012-12-07+at+11.35.15+AM.png Where can I learn more about Reporting and Analytics on MongoDB?First place to look is the Jaspersoft community wiki: http://community.jaspersoft.com/wiki/mongodbMy colleague, Matt Dahlman has some excellent examples on his blog: http://mdahlman.wordpress.com/tag/mongodb/

IntroductionThis page is meant to give an overview of the auditing features of JasperReports Server. Note that this is only valid for an Enterprise license. Audited EventsLoginEventExampleusernamejasperadminorganizationorganization_1loginFailureBAD_CREDENTIALSexception[toc]Run ReportEventExamplereportParam*Product_Name (Squash)reportRenderingTime267reportRenderingStartTime2012-12-03 16:00:25queryExecutionTime162queryExecutionStartTime2012-12-03 16:00:34reportExecutionTime3844reportExecutionStartTime2012-12-03 16:00:44dataSource/datasources/SampleJNDIsqlQuery*select accounts from table where name="sample'domainQuery* exception*note that the extended values for these events are int the "Prop Long Value" column of the Audit tables Copy ResourceSave ResourceUpdate ResourceDelete ResourceSave ResourceSchedule ReportAd-Hoc EditingEventExamplefilteremployee.employee__position_title in ('HQ Human Resources')fromCacheYESadhocActioneditAdhocFilter, removeColumn, insertColumn, undoAlldatasource/Domains/supermartDomainsqlQuery*select department from table where department = 'HR' domainQuery*<!--?xml version="1.0" encoding="UTF-8"?--> <query xmlns="http://www.jaspersoft.com/2007/SL/XMLSchema"> <queryfields> <queryfield id="employee.employee__department_description" /> mdxQuery adhocStepId17 (this is a running count of steps user took) *note that the extended values for these events are int the "Prop Long Value" column of the Audit tables See AlsoEnabling JasperReports Server 5.x Audit Feature

Why?You've developed some cubes in MS SSAS and you want to consume them in Jaspersoft. This has always been possible from iReport to create static or parametrized reports and publish them to the server, in version 5.0 the ability to connect to JasperReports Server through the ad-hoc interface is enabled. PreparationYou should first set up your Microsoft SQL Server to accept XML/A connections through IIS - this is not trivial and is largely outside of the scope of this article. One of the most useful sources of information was this article: URLVersionhttp://msdn.microsoft.com/en-us/library/gg492140.aspx#bkmk_editSQL Server 2012http://msdn.microsoft.com/en-us/library/gg492140(v=sql.105).aspxSQL Server 2008R2You should have 2 types of authentification Enabled: Windows Authentifiaction (to have ability to connect from Visual Studio) and Basic Authentification - Jaspersoft uses this to send user/password to the MS-SSAS server Testing the connection: you should use iReport to test the connection to the server, this is the first test and if it doesn't work you won't be able to connect to the Cubes via the server either. In iReport, create a new connection of type 'XMLA Server' and input your URL and password. The URL if you set the server up correctly should be in this form: http://my-web-srv01/OLAP/msmdpump.dll Once you do this then press the "Get metadata" button. If all goes well you'll see a screen like this: Only after this is working, move to the next step! Making the Connection from the ServerAfter you've tested the connection with iReport, move on to the server. Find the folder you want to create the connection in, then right click on it and press "OLAP Client Connection" The next screen should be filled out as follows, note that the red letters correspond to the letters from the iReport screenshot above, this was very helpful in discovering the information needed to fill out this screen NOTE: the Data Source (in this case WIN-B3GSCF9OA47) should map to the IP address of the server. Test this ahead of time by trying to ping it. If this doesn't work then add the host to your hosts file Now save the connection and attempt to create an ad-hoc view from it, the tool should read the catalogs: TroubleshootingAbsolutely make sure that you can ping the server using it's fully qualified domain name (not it's IP).Make sure Basic authentication is enabled on MS SSASMake sure you can reach your server in a web browser, you'll get an error but it should not be a 404 error or a time out (http://my-web-srv01/OLAP/msmdpump.dll)What does the log of MS SSAS say? Is there a failed connection attempt?Anything in the jasperserver.log? If not you can try to add: com.jaspersoft.jasperserver.api.metadata.olap.service.impl.OlapConnectionServiceImpl=DEBUG andcom.jaspersoft.ji.adhoc.action.tree.OlapConnectionTreeProvider=DEBUG[/code]to log4j.properties to get more logging on the JasperReports Server side Be patient if you're on a remote connection, XML/A is not very fast and transfers lots of information over the wire, latency between Jaspersoft and Microsoft is relevantYou can disable cache or change some related settings in the file ../WEB-INF/applicationContext-olap-connection.xml, this example effectively disables cache: <!-- olap4j caching config --><!-- see javadoc here http://www.olap4j.org/api/org/olap4j/driver/xmla/cache/XmlaOlap4jNamedMemoryCache.html --><property name="OLAP4J_CACHE" value="org.olap4j.driver.xmla.cache.XmlaOlap4jNamedMemoryCache" /><property name="OLAP4J_CACHE_NAME" value="JasperServerXMLACache" /><property name="OLAP4J_CACHE_MODE" value="LFU" /><property name="OLAP4J_CACHE_TIMEOUT" value="1" /><property name="OLAP4J_CACHE_SIZE" value="1" />[/code]See AlsoJasperReports Server OLAP User Guide, Working with XML/A Connectionshttp://www.olap4j.org/api/org/olap4j/driver/xmla/cache/XmlaOlap4jNamedMemoryCache.html