Search code examples
etliccube

icCube ETL - cached table - beyond 100 rows

I am using the cached table functionality as described in the online documentation to setup an array to support financial consolidation (to be more precise: intercompany elimination).

Prototyped on a small data set, the ETL code works seemingless, but when I start using a source table that has more than 100 rows (approx. 1400 to be precise), I only get the maximum 100 rows.

What do I need to do to cache the complete table?

My Initialization Code looks as follows:

var df = table("costcenter structure");
var n = df.count();
debug ("************************** count: " + n);

BTW: I use the same table "costcenter structure" to create the parent-child hiearchy and that is working fine.

Solution

  • The 'browse' data is getting the first 100 rows from all tables, included the ones cached.

    You've to simulate a full load by using for example the 'Read View' or 'Export' button.