Database Reference
In-Depth Information
to an unknown value. The unknown option allows end users to see the data when
analyzing the data, as you will see an unknown member in the dimensions and you
can see the data under this member.
If you have bad data quality in the form of orphaned records, it is often a good idea
to ignore errors when processing. Instead add a new dimension for troubleshooting
purposes. The dimension should be created using the fact table as the source. To
create such a dimension, you need to ensure that you have a column or a set of
columns that can uniquely identify the row in the fact table. If such a column does
not exist, you can add a column to the table containing a unique number, like and
identity or using the
ROW_NUMBER
T-SQL function. When you have created this new
dimension,youcancreateaqueryagainstthecubethatfiltersontheunknownmem-
ber from your original dimension and shows the newly created dimension key on the
rows. This will allow you to quickly identify the rows and examine them in order to
correct the data in the source systems.
Search WWH ::
Custom Search