The only approaches I'm aware of are ILS 18 and VOR DME-A 36. I've landed in OYSN over a hundred times and 90% of the time 36 is in use. I would study the VORDME-A.
In June, visibility is very poor and thunderstorms develop after 1 p.m. Windshear on short final is common and the wind direction can vary 180 degrees between the threshold and midway down the runway.
If you follow the full approach procedure and adhere to all of the stepdowns before transitioning to visual, you'll be very high. It's difficult to get stabilized and you'll have to circle, which is very challenging with the terrain. If you can get visual contact, descend as early as possible as the thermals can make the final 3-4 miles difficult.
Good luck! Sana'a isn't for the weak hearted during the summer months.