How do sacral dimple in adults occur?

They don't. A sacral dimple is present at birth. Other openings are usually secondary to pilonidal sinuses, which are aquired.