Great video for cam position sensor replacement.
In addition to the cam position sensor, you'll need the sealing O-ring for it (doesn't come with the sensor), the O-ring for the vanos solenoid, and an oil filter with filter housing O-ring. You'll want to remove the oil filter housing cover to make more room and you might as well drop a fresh filter in.
The car in the video has an after market filter without a heat barrier. You'll need to pull the air box if you have a stock air filter or the heat barrier if you have a CAI.
2006 Z4 3.0si Sport Package (But I'll still hang with my "homies" in the E36 forum)