Skip to Content
Former Member
Apr 15, 2015 at 12:56 PM

Calculated Fields and General Strategy



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?