How to view Cube in WEB Browser(IE) like Pivot tables of Excel

hi,Please! Help me.How to view Cube in WEB Browser(IE) like Pivot tables of Excel.
Your help is highly appreciated.

You can use the Save As Web page functionality from Excel and publish the web page on your web server.

You can also embed OWC Pivot table within your html page, setup appropriate connections to your cube to get the functionality.

--Siva

This posting is provided "AS IS" with no warranties, and confers no rights.

|||Thanks, Siva.But How to write code to call cube which i designed with sql server 2005 Analysis Services.Thanks in advanceSatyananda|||

Enclosed is the reply I got from the OWC team. Let me know if this is what you are looking for.

OWC can connect to AS 2005 using the connection string property and either the data member or command text properties.

PivotTable.ConnectionString = “PROVIDER=MSOLAP;Data Source=[Valid Server Name];INITIAL CATALOG=[Valid AS Database Name];”

PivotTable.DataMember = “[Valid Cube Name]”

‘’ Or

‘’ PivotTable.CommandText = “[Valid MDX Statement that OWC can process]”

Notes:

1. There are some limitations to the MDX that can be executed by the OWC PivotTable object. OWC tries to parse the MDX to determine what belongs on what axis. If OWC can not determine what belongs on what axis, it will fail processing the MDX. However OWC has a pretty extensive object model that can be used to build the desired PivotTable.

2. OWC Controls are not “Web Controls” as defined by ASP.NET. OWC controls exist in only one location so things like server side “Code Behind” are not relevant.

3. On a web page, client side VBScript or Jscript/JavaScript can be used to run the object model.

4. Via the object model and event handling OWC provides the ability to add custom context menus and menu actions.

Regards

Siva

This posting is provided "AS IS" with no warranties, and confers no rights.