Database Version Control: Sooner than later! (NeXtep)

Working in business intelligence usually involves creating schemas for at least the data warehouse and data marts. Usually the DDL is written using a text editor or some kind of GUI, svn or git or similar is used as standard version control, but effective versioning of this ddl is quite often not happening. Why do I say “effective” versioning - well in the case of database development you will need a tool that can generate the DDL for the delta of...

Read More

Stylesheets with Pentaho Report Designer

Stylesheets with Pentaho Report DesignerStylesheets are the second big feature being integrated into PRD this year (the other one being crosstabs). I submitted a feature request for stylesheets some months ago (PRD-3823, PRD3834), simply because working on big projects requires stylesheets: You don’t want to waste hours changing every single report in case your client wants to have a style amended; you don’t want to recreate styles over and over...

Read More

Pentaho Report Designer: How to configure error logging

Configure loggingBy default PRD outputs the log to the console and to a file. The log output file can be found in (Linux):~/.pentaho/logs/prd.logTo configure the log settings amend the log4j.xml file in the PRD/resources folder. See here for more details.To get a more detailed logging, change this section  <root>    <priority value="INFO"/>    <appender-ref ref="CONSOLE"/>    <appender-ref ref="FILE"/>  </root>to  <root>    <priority...

Read More