I am fairly new in HANA and have a deployment strategy question. Basically, as per the requirements, i want users to be able to connect to a semantic layer via Microsoft Excel and use it as OLAP cube. Secondly, we also want users to use Web intelligence reports and capabilities like SAP Lumira.
I know that we can connect to HANA using Excel fairly easily and is documented here so I am assuming that we need to have a semantic layer in HANA with all the calculated fields that users would like to see. However, if i then want to expose the same data to Web I, do I need to recreate the semantic layer in universe for Webi to access?
Is that a good practice?