Search This Blog

Saturday, May 19, 2012

Fact kickout report doesn't seem to tie to summary and detail

In this scenario, there are unknown items that appear in the fact kick-out reports that cause the reports not to tie out.

The is due to a data type truncation issue in the p_ETL_KICK_v2.x routine.  Any dimension names that exceed 8 characters will be truncated.

For example:
"DEPARTMENT" will show as "DEPARTME".

Download and apply p_ETL_KICK_V2.2.sql to solve this issue.

This is solved in 304 pack

No comments:

Post a Comment