If data does not get loaded into a cube measure:
Check install-root/errors for any errors involving the row source that loads data into the measure.
Errors types:
A row source value does not match any member name.
Implies that there is data for some members that is not in a dimension. You can ignore these errors.
A row source has duplicate values.
Implies that the key for row source is not properly defined. Look at the key and the mapping between the row source and the cube.
If there are no errors, look for the statement in the log that does the row source staging. Statements appear similar to: stage replace using stagemap stagemap-name or stage update using stagemap stagemap-name.
If there is no stage statement, the staging was never done. This usually happens if the script misses the stage command, or if the group name in the stagemap does not match the group name in the macro stage command.
If the stage statement exists, look for how many records were accepted or rejected. If there are no rejected records, then there is no problem with staging.
Check if the load command is in the log. It has the pattern “load update” or “load replace” into the row source that is mapped to the measure.
If there is no load statement, fix the scripts to add the statement.
If the load statement exists, observe how many records were accepted or rejected. Rejected records appear in the error file described previously.