It’s expensive, I think it was 70 euros for a seat at the bar, then upwards for better seats (we walked by and checked it out). I would assume you need a reservation, or at least a few days in advance booking if it’s busy. Like a broadway musical. You might get lucky and buy a ticket at the door, but if you want a guarantee…!

It’s in the middle of the Red Light district. Seems like a tourist trap to me – every time I walk by all there are is busloads of elderly folks who got tickets as part of a package deal. I hear you do get dinner though.

One problem I’ve read about is that it finishes after the metro has stopped running. So, you could consider getting a cab, but that can be very difficult, and you have to be sure to get an authorized cab rather than a ripoff artist. You could look up the night bus schedule.
 
For me, the total price seemed excessive, plus there’s the pain of getting back at that time of night, so I’ve never done it.