offline cube

i am trying to connect offline cube which i have in local disk D. i added below code in pageload

protected void Page_Load(object sender, EventArgs e)

{

string connectionstring="Provide=MSOLAP;DataSource=D:\\2010projects\\Adventure_Works_Ext.cub";

OlapDataManager olapDataManager = new OlapDataManager(connectionstring);

this.OlapClient1.OlapDataManager = olapDataManager;

this.OlapClient1.DataBind();

}

while trying to run i am getting runtime error unable to connect. iam new to this olap, please suggest me as soon as possible

1 Reply

PS Prabu S Syncfusion Team August 6, 2013 11:59 AM UTC

Hi Mohan,

We have reviewed your query and we have created simple sample in OlapClient ASP.NET for your convenience.

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.

Please let us know if you want any other assistance.

Regards,

Prabu S.