Hello from Berlin!
I try to descripe my problem:
I have an already loaded cube. I try to load only the newest data into the cube ( about 6600 rows). This load runs very long (about 2h). When I look at CUBE_BUILD_LOG, I see
that the mapping not only tries to load the 6500 rows from the source table, OWB also genereated sql for data that are not in the source data, and already loaded in the cube.
The source Table hast got only exact the dates I want to fill into cube.
There are a lot of sql generated ,that contains no data and there is no nee to genereate them, or try to load them.
In the CUBE_BUILD_LOG is see loading <CubeLoad LOADED="6632" REJECTED="0"/> need only 1 Minute, but "loading" data that is already loaded and not in the source table need about 2h.
What do I want ?
- Only the new data should be loaded, OWB should only genereated sql for the new data not for every date ( or data set in cube) in the cube.
Maybe wrong settings for loading cube ?
Thank for help!