Skip to Content
0
Former Member
Jun 14, 2006 at 04:15 PM

Not display records in a cube

16 Views

Hi everybody,

I have a problem in moving data from an ODS to a CUBE. Here is an example of the problem:

ODS

Order: 1

Item: 100

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)

CUBE:

Order: 1

Item: 100

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

Marco