Java tutorial
/** * TNTConcept Easy Enterprise Management by Autentia Real Bussiness Solution S.L. * Copyright (C) 2007 Autentia Real Bussiness Solution S.L. * * This program is free software: you can redistribute it and/or modify * it under the terms of the GNU General Public License as published by * the Free Software Foundation, either version 3 of the License. * * This program is distributed in the hope that it will be useful, * but WITHOUT ANY WARRANTY; without even the implied warranty of * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the * GNU General Public License for more details. * * You should have received a copy of the GNU General Public License * along with this program. If not, see <http://www.gnu.org/licenses/>. */ package com.autentia.tnt.bean; import java.io.File; import java.net.URISyntaxException; import java.net.URL; import javax.faces.context.FacesContext; import javax.servlet.http.HttpSession; import org.apache.commons.logging.Log; import org.apache.commons.logging.LogFactory; import com.autentia.tnt.manager.report.ReportManager; import com.autentia.tnt.util.JPivotUtils; import com.tonbeller.jpivot.olap.model.OlapModel; public class JPivotBean { private static final Log log = LogFactory.getLog(JPivotBean.class); private OlapModel olapModel; private URL cubeURL; public JPivotBean() { showTable(); } public OlapModel getOlapModel() { return olapModel; } public void setOlapModel(OlapModel olapModel) { this.olapModel = olapModel; } public String showTable() { try { ClassLoader loader = Thread.currentThread().getContextClassLoader(); File file = new File(loader.getResource("com/autentia/tnt/jpivot/jpivot_test.xml").toURI()); cubeURL = file.toURL(); String mdxQuery = "select {[Measures].[Muestras]} on columns , {([Contacto])} on rows from [Informe]"; this.olapModel = JPivotUtils.executeOlapQuery(mdxQuery, cubeURL, (HttpSession) FacesContext.getCurrentInstance().getExternalContext().getSession(false)); } catch (Exception e) { log.error("cannot generate the jpivot cube: ", e); return "error"; } return "jpivot"; } }