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 ...
In response to my article on the ODI variable debug procedure Craig Stewart has pointed out an undocumented parameter of the getSession method that does the same with one big limitation. The parameter SESS_PARAMS will print out any variables that have been passed into a scenario generated from a package. Unfortunately this is the limitation of this method. Variables that ...
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: ...
One of the annoying things in ODI is that you can't print out the value of an ODI variable to the Operator module without a workaround. In this workaround you throw an exception in Jython or the Java BeanShell and pass the ODI variable as an argument to the exception method,e.g. in Jython you can use raise('#name_of_project.name_odi_var') to achieve this. ...