From what I have read its normal. Something with oil needed to get circulating. The sound goes away after few seconds because the oil is starting to do its thing.
Mine doesn't make that noise on start up but makes the Vanos diesel type noise.
YouTube - BMW X5 4