ASP.NET and OLAP offline cube

Hi,

I would like to know the provider for OLAP offline cube, I mean to say that how I would able to connect to offline cube from asp.net, Please help me on this.

Jag

Use OLEDB. There are many examples on the Internet so search for: asp.net oledb. Here is an overview of the architecture: http://msdn2.microsoft.com/en-us/library/ms174518(SQL.90).aspx

You will also need a local cube engine (msmdlocal.dll) on the client machine. It is described in detail in the article I mentioned above.

|||

Thank you Greg,

but I did not found any sample solution about provider how i could able to connect, please let me know if you have any sample

Jagan

|||

I am not an ASP developer but I found some sample code here: http://www.w3schools.com/aspnet/aspnet_dbconnection.asp (sample for SQL) and http://www.businessintelligence.com/ex/asp/code.52/xe/article.htm (AS 2000 but it still applies to 2005)

I searched for: asp.net olap open connection

Basically, you need to open an OLEDB connection where the connection string specifies the provider as MSOLAP and data source as a local cube. Something like this: "Provider=MSOLAP.3; Data Source=C:\full_path_to_your_local_cube.cub"

I hope this helps at least a little.

|||

Hi

I tried with that, but it does not work.. thrown Provider error.

Thank you,

rgds

Jag

|||Did you add a reference to the right COM components in your project? It is described in the second article I mentioned (search for "reference" in the content of that webpage). If your project references the ADODB/ADOMD components and you are still getting an error, please, give more details on the error message and attach a piece of code where you are trying to open the connection.|||

Thank you Greg, its working fine.

but i had another question like I am using local cube with owc10, I am trying to display data in pivot table,

the code below I am using

Dim strOLAPConn As String = ConfigurationSettings.AppSettings("OLAPConnectionString")

Try

Dim objPT As PivotTableClass = New PivotTableClass
Dim objPTView As PivotView
Dim fldDeptElmt As PivotFieldSet

objPT.ConnectionString = strOLAPConn
objPT.DataMember = strDataMember
objPTView = objPT.ActiveView
objPTView.TitleBar.Caption = ""
fldDeptElmt = objPTView.FieldSets("Dept to Element")
objPTView.RowAxis.InsertFieldSet(fldDeptElmt)
objPTView.FilterAxis.InsertFieldSet(objPTView.FieldSets("Payperiod"))
objPTView.DataAxis.InsertTotal(objPTView.Totals("Dollars"))
objPTView.DataAxis.Totals("Dollars").NumberFormat = "$#,##0"

m_XML = objPT.XMLData

objPT = Nothing

The bolded line code is giving me a error Invalid class string when i use offline cube, but if I connect to online cube I shoudn't have any issue.

please advice me .

Jag