Creating Aggregate Tables

This post demonstrates an example how to create aggregation tables in Kettle. Let's assume the original transformation loading delta is the following: It reads data from source database, makes some transformations and loads data into data warehouse. The source table JobEntry has two grouping fields project_id and employee_id and one additive measure registered_hrs. The task […]

Activity Tracker

Do you have to fill timesheet weekly? I have to..┬áThis small tool can help you to remember what you were doing last week :) You start the tool and minimize it to tray. It tracks activity on your computer and logs it to a file, so you can later see what you were doing. The […]

Use of Index and Characterset

This post demonstrates influence of characterset on use of indexes. See also Language and Use of Indexes in Oracle /* DROP TABLE t; ALTER SESSION SET NLS_LANGUAGE='AMERICAN'; */ SELECT PARAMETER, VALUE FROM V$NLS_PARAMETERS; CREATE TABLE t (x VARCHAR2(255)); INSERT INTO t VALUES ('a'); INSERT INTO t VALUES ('b'); INSERT INTO t VALUES ('c'); INSERT INTO […]

Language and Use of Indexes in Oracle

Symptoms It takes a very long time to load a data warehouse on Oracle database with Kettle when the language in the Windows Region and Language settings is different from English (United States). Cause Oracle JDBC driver used by Kettle issues command ALTER SESSION SET NLS_LANGUAGE and changes default database language. Changing NLS_LANGUAGE also changes […]

How to Find Running Queries – SQL Server

SELECT CN.session_id AS SPID, ST.text AS SqlStatementText FROM sys.dm_exec_connections AS CN CROSS APPLY sys.dm_exec_sql_text(CN.most_recent_sql_handle) AS ST ORDER BY CN.session_id If a BusinessObjects document is refreshing for a long time, you might be interested in what query is currently running (to optimize it). The above code can help to figure out this.

Io exception: Socket read timed out

If you get the following message, check the firewall settings. ERROR 30-09 09:13:36,485 – YOUR_LOG_CONNECTION – Error disconnecting from database: Error comitting connection Io exception: Socket read timed out When the transformation/job is started, Kettle opens a connection for logging. The transformation could run for hours, the connection for logging will stay idle all this […]

Influence of Nr of rows in rowset on Merge Join

Let's consider a transformation that merges two flows: Here are some experiments with different Nr of rows in rowset: So the speed of the Merge join depends on the parameter Nr of rows in rowset. It should be┬áreasonably high (3000K). Note that if the parameter is too high, the transformation might fail with exception: java.lang.OutOfMemoryError: […]

Where universes and documents are stored

BusinessObjects documents and universes are not stored in the CMS database. The CMS database contains only metadata – miscellaneous information about the objects. The files corresponding to the objects are stored in the BO File Repository. For example, there is a webi document Balance Sheet in the BO. For the document, you can find its […]

Internet Explorer 9 support in BusinessObjects Enterprise

If you get error message "HTTP Status 400 – Invalid Path /Analytical Reporting/WebiView was requested. The request sent by the client was syntactically incorrect.", it is very likely that you are using IE 9. IE 9 is not supported yet by BO. It is planned to be supported in BO BI 4.1 and BOE XI […]