Config for enable log files for Mondrian and Reporting Log

pentaho-logfiles.md

Allowing reporting log

tomcat/webapps/pentaho/WEB-INF/classes/log4.xml -> add to the end

<!-- ========================================================= -->
<!-- Special Log File specifically for Reporting log           -->
<!-- ========================================================= -->

<category name="org.pentaho.metadata">
    <priority value="TRACE"/>
</category>

<appender name="METADATA" class="org.apache.log4j.RollingFileAppender">
    <param name="File" value="/opt/pentaho/601ee/server/biserver-ee/tomcat/logs/metadata.log"/>
    <param name="Append" value="true"/>
    <layout class="org.apache.log4j.PatternLayout">
        <param name="ConversionPattern" value="%d %-5p [%c] %m%n"/>
    </layout>
</appender>
<category name="org.pentaho.metadata">
    <priority value="TRACE"/>
    <appender-ref ref="METADATA"/>
</category>
<category name="com.pentaho.iadhoc.model">
    <priority value="DEBUG"/>
    <appender-ref ref="METADATA"/>
</category>
<category name="com.pentaho.iadhoc.service">
    <priority value="DEBUG"/>
    <appender-ref ref="METADATA"/>
</category>

Allowing OLAP log (Mondrian)

tomcat/webapps/pentaho/WEB-INF/classes/log4.xml -> uncomment

<!--  optional logging info for the Mondrian OLAP Engine       -->


<!-- ========================================================= -->
<!-- Special Log File specifically for Mondrian                -->
<!-- ========================================================= -->

<appender name="MONDRIAN" class="org.apache.log4j.RollingFileAppender">
    <param name="File" value="/opt/pentaho/601ee/server/biserver-ee/tomcat/logs/mondrian.log"/>
    <param name="Append" value="false"/>
    <param name="MaxFileSize" value="500KB"/>
    <param name="MaxBackupIndex" value="1"/>

    <layout class="org.apache.log4j.PatternLayout">
    <param name="ConversionPattern" value="%d %-5p [%c] %m%n"/>
    </layout>
</appender>

<category name="mondrian">
    <priority value="DEBUG"/>
    <appender-ref ref="MONDRIAN"/>
</category>


<!-- ========================================================= -->
<!-- Special Log File specifically for Mondrian MDX Statements -->
<!-- ========================================================= -->

<appender name="MDXLOG" class="org.apache.log4j.RollingFileAppender">
    <param name="File" value="/opt/pentaho/601ee/server/biserver-ee/tomcat/logs/mondrian_mdx.log"/>
    <param name="Append" value="false"/>
    <param name="MaxFileSize" value="500KB"/>
    <param name="MaxBackupIndex" value="1"/>
    <layout class="org.apache.log4j.PatternLayout">
    <param name="ConversionPattern" value="%d %-5p [%c] %m%n"/>
    </layout>
</appender>

<category name="mondrian.mdx">
    <priority value="DEBUG"/>
    <appender-ref ref="MDXLOG"/>
</category>

<!-- ========================================================= -->
<!-- Special Log File specifically for Mondrian SQL Statements -->
<!-- ========================================================= -->

<appender name="SQLLOG" class="org.apache.log4j.RollingFileAppender">
    <param name="File" value="/opt/pentaho/601ee/server/biserver-ee/tomcat/logs/mondrian_sql.log"/>
    <param name="Append" value="false"/>
    <param name="MaxFileSize" value="500KB"/>
    <param name="MaxBackupIndex" value="1"/>
    <layout class="org.apache.log4j.PatternLayout">
    <param name="ConversionPattern" value="%d %-5p [%c] %m%n"/>
    </layout>
</appender>

<category name="mondrian.sql">
    <priority value="DEBUG"/>
    <appender-ref ref="SQLLOG"/>
</category>