An exciting fantasy; a very appealing, ideal thing, person, or state of affairs.
"An erotic dream bringing the sleeper to orgasm" - this was what I was confused about.
Nah, the alternative that popped in my mind was "phantasizing", so I guess my wording aligns with my feelings. Whether these feelings are healthy is another discussion :D