This is a simple walk through to load OpenI with The Apache Open for Business Project. I chose OpenI over the implementation from Pentaho for this walk through simply on the basis that the default download uses a mysql database instead of an embeded hsql database. This walk through will utilize the sample Foodmart Database that comes with the OpenI source because a Cube has already been created to view reports and the purpose of this is to make sure everything is set up correctly. My personal implementation (down the road) will attempt to utilize minilang to obtain the results needed from mondrian and jpivot in a more integrated OFBiz manner that can benefit from the service engine. It will also hopefully change the authorization to use the ofbiz login information. Anyway on to the meat.
log4j.logger.org.openi=DEBUG log4j.logger.com.loyaltymatrix=INFO log4j.logger.com.tonbeller.wcf.log.LogTag=INFO #change the padding of the resource from 24 to 44 so that the output is formated evenly, mondrian has some larger named resources log4j.appender.stdout.layout.ConversionPattern=%d (%t) [%44F:%-3L:%-5p]%x %m%n |
<ofbiz-component name="openi" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:noNamespaceSchemaLocation="http://www.ofbiz.org/dtds/ofbiz-component.xsd"> <resource-loader name="main" type="component"/> <classpath type="jar" location="build/lib/*"/> <classpath type="dir" location="script"/> <classpath type="dir" location="config"/> <classpath type="jar" location="lib/*"/> <classpath type="jar" location="webapp/mondrian/WEB-INF/lib/*"/> <classpath type="jar" location="webapp/openi/WEB-INF/lib/*"/> <classpath type="jar" location="webapp/openi-projects/WEB-INF/lib/*"/> <webapp name="mondrian" title="mondrian" server="default-server" location="webapp/mondrian" mount-point="/mondrian" app-bar-display="false"/> <webapp name="openi" title="openi" server="default-server" location="webapp/openi" mount-point="/openi" app-bar-display="false"/> <webapp name="openi-projects" title="openi-projects" server="default-server" location="webapp/openi-projects" mount-point="/openi-projects" app-bar-display="false"/> </ofbiz-component> |
<tomcat-users> <role rolename="tomcat" /> <role rolename="role1" /> <role rolename="manager" /> <role rolename="admin" /> <user username="tomcat" password="tomcat" roles="tomcat" /> <user username="both" password="tomcat" roles="tomcat,role1" /> <user username="role1" password="tomcat" roles="role1" /> <user username="admin" password="" roles="admin,manager" /> </tomcat-users> |