I beleive the proper expression is "go piss up a rope" (rather than "in a cup").

I never fully understoood the exact meaning, but always found it wonderfully vulgar and use it whenever I can