Skip to Content
0
Oct 04, 2005 at 10:15 PM

How to correct Inconsistent Cube Data

278 Views

We have following unique condition of the info Cube data which is causing duplicate records in reporting.

The Fact table of the Cube has data for one dimension ID 8042 in the Data Packet dimension.

This dimension Id does not appear in the Data Packet Dimension Table. But still the data is available in the fact table which is supposed to be a deleted data.

How can we delete this wrong dimension ID data from the fact table without deleting the whole Cube contents? We can not use selective deletion because we can not select the DIM ID in it and the 0REQUID for that dimension does not exist.