My friend and colleague Maciej Kocon has come up with the following trick. Rather than use a user defined function to implement an analytic function such as MAX() OVER or SUM() OVER as suggested by note 807527.1 there is another way to work around the getGrpBy bug. We will take advantage of the ODI multi pass parser and hide the ...
Setting up integrated security with the SQL Server JDBC driver can be tricky. You often end up with the message “This driver is not configured for integrated authentication”. Below are the steps that you need to perform to get this to work. Note: This will only work where the ODI agent has been installed on a Windows OS. 1. Download ...
As part of a data mart refresh I am using nqcmd to clear the cache for the corresponding subject area in OBIEE. Thanks to John Minkjan for his post on properly documenting how the OBIEE cache can be cleared. Basically I am executing nqcmd -d AnalyticsWeb -u Hans -p Zipfel -s d:obieescriptsPurge_XXX_Cache.txt in an ODI procedure with technology set to ...
I am not getting around doing too much blogging on ODI these days. I have recently started a new project on OBIEE and ODI and it must be two years or so since I have last used OBIEE. I can tell you that there is a lot of catching up to do. Anyway, today's post is about why I love ...
The following query can be used to retrieve the source columns/tables and target columns/tables for interfaces in a specified project NOTE: BELOW QUERY IS VALID FOR ODI 10g ONLY!!! ODI 11g has introduced the concept of data sets, which invalidates below query.
c.table_name AS source_table,
e.col_name AS source_col,
f.table_name AS target_table,
a.col_name AS target_col
LEFT OUTER JOIN snp_src_set b ON (a.I_SRC_SET = b.I_SRC_SET)
LEFT OUTER JOIN snp_source_tab c ON (b.i_src_set = c.i_src_set)
LEFT OUTER JOIN snp_txt_crossr d ON (a.i_txt_map = d.i_txt)
LEFT OUTER JOIN snp_col e ON (d.i_col = e.i_col)
JOIN snp_pop f ON (a.i_pop = f.i_pop)
a.i_pop IN (
WHERE i_folder IN (
i_project = project_id
In order to master scripting in ODI I recommend the following books. Java BeanShell Scripting in Java: ...