Cycles shader that renders its objects transparent when they are 'inside' of a sphere?
I found that using the Transparent Depth output of the Light path node was the key for me. 

I used a Math node to control its value which gave control over how much transparency was applied to the portion of the cylinder within the sphere.