.
.
.
Interesting situation we run into.
We loaded the Product dimension using a Non-Indexed Focus file as source. No problem
Than we tried to load the Transaction source data file using the Measure load. We received a FUCUS error complaining that the JOIN could not execute because the Product Dimension file is NON-Indexed.
Why would the Measure load worry about the Dimension source file? The dimension is loaded into the PMF database already. The error message was clearly showing the synonym name for the dimension source file.

if you tell me that PMF measure load does not care about the dimension source file, and above should not happen, we recreate the problem, and go through it in great detail to see where we might have a confusion among synonyms, but at this point we think that the measure load was checking the dimension load file structure.

thnx
Endre

Endre,

The short (and somewhat technical) answer is that when the measure load runs, PMF joins the Measure source data file to the Dimension source data files. The measure loader then compares this against the PMF database. This way, if you forgot the run a Dimension load or if some Dimension data in PMF were altered or deleted, it would show up as a discrepancy in the load Preview.

In other words, we assume that the source data is always right.

EricH

.
.
Eric,
WOW... We didn't know that the dimensional source files are actually looked at by PMF when loading measures. That explains a lot. Thank you! Endre\..
.