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
