Q 2. What is the difference between online and offline mode in SSAS ?
Online mode means that you are directly connected to a
particular SSAS database instance. Any changes you make are implemented on
save. Offline mode means that means that you are creating metadata files that
can be deployed to the SSAS server when you want. An important consideration
for offline mode is that BIDS includes no granular conflict resolution.
