i have this problem: I have a fact table for sales analysis and i have a dimension for article of sale. The problem is that in the fact table i can find multiple records that not is present in the table of articles. This condition not is an error because
the software for the sales permit to do a sale without an article codified.
How can i solve this problem?
Can i force this error? If i set custom error on dimension with ignore key error enabled, the cube process however go in error
View Complete Post