DS9 was heavily promoted by Paramount during its first season and the ratings were stellar. The problem came in season two, when all the focus was on TNG's run ending and the last episode. Then after TNG ended, the focus shifted to "Generations." And then Voyager and UPN premiered right afterwards. DS9 got lost in all that.