What is the difference between essbase and essbase server in layman,s term? I am not able to understand the difference, neither can i find it on internet. Help
The main difference you are encountering likely has to do with the context in which someone refers to Essbase. To try and answer your question, though: Essbase Server tends to refers the physical computer that contains one or more Essbase databases. When one says they are "using Essbase" this might mean that they are performing an operation on their computer that is specifically communicating with the Essbase Server. This would commonly be the Essbase Excel Add-In, Smart View, or some other software.
A person using Essbase will typically do so from an Excel spreadsheet. In this case, they might be populating data in various cells by performing retrieves, pivots, and other operations until they get the desired data on their spreadsheet, and where the data is being transmitted in real time from the Essbase server.