I went from reporting off an ERP system, to working on a DW team which built a base warehouse and cube off this system. Most people don't truly understand how different a pure transactional db differs from a good base warehouse. Very enlightening when someone sees 'clean data' generating errors.
Planning and mapping out are critical, and also need to take into account more of users and their expectations.
We did see slowing down some, and letting some of the thoughts and questions settle for just a bit, then a fresh review before finalizing what we were going to do, worked very well for us.
I remember 10 years ago, being in SQL events, and the question would come up 'who uses a cube?', and I was usually one of the only ones raising my hand. Seems like once someone is exposed to the power of SSAS, they get pretty excited. Whole new set of possibilities.
Some of the tools have come a long ways in the last few years for the users to access / view data stored in a cube. As you could see, MDX natively, isn't exactly real user friendly and intuitive.
Your relief might be short lived, although in a good way. Once users get a handle on things, usually it will spark a bunch of can we add this requests. If you haven't done much with drill to detail yet, you might want to get familiar with it.