I am working for a FMCG client and there are no specific reporting requirements. Currently they are using MSOLAP for queries so they have no specific query requirements. As the client does not have specific reporting requirements, we are trying to identify a possible solution to deliver all reports using a data model.
In this process,is it advisable to build all queries as Adhoc using Web Application Designer?What are the advantages and more importantly the disadvatages of giving only Adhoc queries to meet Reporting Requirements?
The client has purchased the licences for BI 7.0. So these queries will be on BI 7.0.
Thanks n Regards,