agrohe21

/* This allows you to have first column with the display value and second for parameter query substitution. */
WITH MEMBER [Measures].[Unique Name] AS [Order Status].[Type].CurrentMember.Properties("MEMBER_UNIQUE_NAME")
select
{Measures.[Unique Name]} on columns,
[Order Status].members on rows
from [SteelWheelsSales]

agrohe21

<category name="org.pentaho.metadata.query.impl.sql.SqlGenerator">
		<priority value="TRACE"/>
		<appender-ref ref="METADATA"/>
</category>

agrohe21

pg_dump -h localhost -d hibernate -U postgres -f ~/pom.dmp -Z 8 -b -n pentaho_operations_mart

agrohe21

CHANNEL LOG
SELECT id_batch, channel_id, log_date, logging_object_type, object_name, object_copy, repository_directory, filename, object_id, object_revision, parent_channel_id, root_channel_id FROM pentaho_dilogs.channel_logs;
JOB LOG
SELECT id_job, channel_id, jobname, status, lines_read, lines_written, lines_updated, lines_input, lines_output, lines_rejected, errors, startdate, enddate, logdate FROM pentaho_dilogs.job_logs
JOBENTRY
SELECT id_batch, channel_id, log_date, transname, stepname, lines_read, lines_written, lines_updated, lines_input, lines_output, lines_rejected, errors, result, nr_result_rows, nr_result_files FROM pentaho_dilogs.jobentry_logs;
TRANS LOG
SELECT id_batch, channel_id, transname, status, lines_read, lines_written, lines_updated, lines_input, lines_output, lines_rejected, errors, startdate, enddate, logdate, depdate, replaydate FROM pentaho_dilogs.trans_logs;
STEP LOG
SELECT id_batch, channel_id, log_date, transname, stepname, step_copy, lines_read, lines_written, lines_updated, line

agrohe21

<category name="org.springframework.security.event.authentication">
 <priority value="WARN"/>
</category>

agrohe21

alias psj='ps -ef|grep java|cut -c 80-330|grep Xmx'

agrohe21

EGIN INIT INFO
# Provides: pentaho-mon-jvm
# Required-Start: $pentaho-dis
# Required-Stop:
# Default-Start: 2 3 4 5
# Default-Stop: 0 1 6
# Description: Pentaho Monitor DIS JVM
### END INIT INFO

case "$1" in

agrohe21

#!/bin/sh
### BEGIN INIT INFO
# Provides: pentaho-mon-sys
# Required-Start:
# Required-Stop:
# Default-Start: 2 3 4 5
# Default-Stop: 0 1 6
# Description: Pentaho Monitor System
### END INIT INFO

agrohe21

<rollingPolicy class="org.apache.log4j.rolling.TimeBasedRollingPolicy">
      <param name="FileNamePattern" value="/home/pentaho/pentaho/server/biserver-ee/pentaho.log_%d{yyyy-MM}.gz"/>
</rollingPolicy>

agrohe21

PROJECT_DIR=/home/pentaho/projects

KETTLE_REDIRECT_STDERR=Y
KETTLE_REDIRECT_STDOUT=Y
KETTLE_MAX_LOGGING_REGISTRY_SIZE=10000
KETTLE_LOG_MARK_MAPPINGS=Y

KETTLE_JOB_LOG_SCHEMA=pentaho_dilogs
KETTLE_JOB_LOG_DB=live_logging_info
KETTLE_JOB_LOG_TABLE=job_logs