A sensation is something that produces excitement. A new song or a new play might be termed a "sensation" or producing "sensation". A thrilling ride on a roller coaster might be described as "sensational".