I have a problem in moving data from an ODS to a CUBE. Here is an example of the problem:
Completion date: blank (the line is not completed yet)
I move the data into a cube (here 0calday is the allocation date and not the completion date which I defined as a characteristic)
Completion date: blank
when the order line is completed and the completion date in the ods is replaced by a date...copying the data into the cube means to have 2 records in the cube....
one (the one above) with all the key-figures put to 0.... the other one...is the correct one...with the correct completion date and the correct key-figures..
how to not display the wrong record?
I tried by putting in the cube the 0recordmode and linking it to the same field of the ods i got in the comm_structure (from the update rules)...But it doesn't work... because in the end I have 3 records:
1. X - order 1; item 100; completion date blank; kf not ok
2. # - order 1; item 100; completion date blank; kf not ok
3. # - order 1; item 100; completion date 10.10.2006; kf ok
and I cannot filter by X or #....
is there anybody who can help me?
many many thanks