Hi Mohan,
We have reviewed your query and we have created simple
sample in OlapClient ASP.NET for your convenience.
http://www.syncfusion.com/uploads/user/directTrac/General/OlapClient_Sample-1050166638.zip
Example connection string for offline cube:
OlapDataManager
olapDataManager = new OlapDataManager(@"Data Source = C:\
Common\Data\OfflineCube\Adventure_Works_Ext.cub; Provider = MSOLAP;");
NOTE: An office cube is also available within the
Essential Studio installed location. Please see the location below.
C:\Users\<User_Name>LAPT\AppData\Local\Syncfusion\EssentialStudio\
11.2.0.25\Common\Data\OfflineCube\MVC\Adventure_Works_Ext.cub
Please find the our online documentation to establishing the
connection through Data provider in different way.
http://help.syncfusion.com/ug/asp.net/olap%20common/documents/42olapdatamanager.htm
Please let us know if you want any other assistance.
Regards,
Prabu S.