How refresh data in Mondrian db.

[grzesiekb]

I have mysql - dw db and ETL (Ketl) when run Pan.sh (ETL) I don't have new data in pivot4j. How I may refresh data in Mondrian DB. However new date are in database (dw - mysql).

Thank you.

[mauriciofh]

Hi.

You can use a jsp page for this. I hope I helped you.

<%@ page import="mondrian.olap.*" %>
<%
    String jdbc = request.getParameter("Jdbc");
    String jdbcUser = request.getParameter("JdbcUser");
    String jdbcPassword = request.getParameter("JdbcPassword");
    String jdbcDrivers = request.getParameter("JdbcDrivers");
    String catalog = request.getParameter("Catalog");

    String connectionString = String.format("Provider=mondrian;Jdbc=%s;JdbcUser=%s;JdbcPassword=%s;JdbcDrivers=%s;Catalog=%s;",
            jdbc, jdbcUser, jdbcPassword, jdbcDrivers, catalog
    );

    Connection connection = DriverManager.getConnection (connectionString, null);
    connection.getCacheControl(null).flushSchemaCache();
    connection.close();

%>
<p>Flushed successfully!</p>
<p><%=connectionString%></p>

[grzesiekb]

Thank you tomorrow I will check it.