Issue 1 (DLU step not working) The dim_customer table (right now) has:
My first table input is:
which I pass to the DLU step with the default settings and the following:
SELECT 'ofcom' as instance_name, 'Ofcom' as salesforce_name
Connection : my datasource
target table: dim_customer
Dimension field: instance_name
Field in stream: instance_name
Technical key field: index_row
When I play it, I then get:
So I went back into the step and just deleted the 'version' from the Version Field area then when I play it I get:
Couldn't execute SQL: insert into dim_customer(index_row, version) values (0, 1)
ERROR: column "version" of relation "dim_customer" does not exist
Couldn't execute SQL: insert into dim_customer(index_row, null) values (0, 1)
ERROR: syntax error at or near "null"
So i tried unchecking the Update Dimension check box and I get:
So I delete those two value (Date range start field and Table daterange end) and I get:
ERROR: column "date_from" does not exist
(I am running Spoon 4.4 btw.)
at java.lang.Thread.run(Unknown Source)
At that point, I just thought I'd try the combination lookup step and that worked (even though I only passed it a non-combination lookup) so I ran with it.
I did look at the ktr file you sent (again, THANK YOU!) and was trying my best to model after it, but I didn't want to 'run back to the forum' again until I tried a few more things. I would love to get this DLU step working - as it clearly is useful!
Issue 2 (Regarding the 'what do I expect to see' in Saiku):
The Saiku application lets one work with the Schema like an excel pivot table. From the default 'new' option, I can select my cube and with nothing on rows/columns, I want to move my 'validity' dimension to the FILTER option of Saiku and it only display the (2) options; instead of what it is (well, was doing...more on that in the next paragraph!) doing and showing VALID (or INVALID) multiple times, in fact, 1:1 with how many external numbers are in the dimension.
In thinking this through, just a few moments ago, however, I noticed that I had put the isvalid column inside the 'External Number' hierarchy - which I think may have been the culprit. I just rebuild the Schema creating a separate hierarchy for 'Addtl Call Flags' and placed the isvalid column in there and now it's working. I can toss the 'validity' column on the filter tab and it only displays the two unique options.
So (I think!) at this point, Issue 2 is working and, thus, the original post concern is resolved! BUT...I'd really like to solve this DLU step issue if possible (?)...