Hi! I am trying to load my table from sqlServer with a custom sql query to eliminate duplicates before the table is already in the cube. The query is working in an additional custom table, but not when loading the table.
FROM (SELECT fe.*,rankasc(fe.ncod_vehicle_id,fe.ncod_driver_id,fe.ncod_driver_cid,fe.ncod_vehicle_cid,fe.date_start,fe.date_end) AS rank_1
FROM [dbo.DSE_Fact_Event_Summary] fe) su
WHERE su.rank_1 = 1
Please sign in to leave a comment.