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,