dbTalk Databases Forums  

OLAP Pivot Table in ASP.NET

microsoft.public.sqlserver.olap microsoft.public.sqlserver.olap


Discuss OLAP Pivot Table in ASP.NET in the microsoft.public.sqlserver.olap forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Prasanna Prabhu
 
Posts: n/a

Default OLAP Pivot Table in ASP.NET - 12-02-2003 , 08:41 PM






Hi All

Sorry, I know this is not the right discussion group for
my question, but trying my luck :-)

Does anybody have a sample code on how to display OLAP
Pivot Cube data within an ASP.NET page.
I have code working for ASP, but I was more interested in
knowing how to display the data in ASP.NET

In ASP I used the object

<OBJECT id=PivotTable1 style="LEFT: 0px; WIDTH: 1397px;
TOP:
0px; HEIGHT: 180px" height=180 width=1397
classid="clsid:0002E552-0000- 0000-C000-000000000046"
VIEWASTEXT>
<PARAM NAME="XMLData" VALUE=

'<xml xmlns:x="urn:schemas-microsoft-
comffice:excel"> <x:PivotTable>
<x:OWCVersion>10.0.0.4109 </x:OWCVersion>
<xisplayScreenTips/>
<x:CubeProvider>msolap.2</x:CubeProvider>
<x:CacheDetails/>
<x:ConnectionString><%=OlapConnStr%
Quote:
/x:ConnectionString>
.......................
</xml>'>
</OBJECT>



Reply With Quote
  #2  
Old   
Sanka
 
Posts: n/a

Default OLAP Pivot Table in ASP.NET - 12-02-2003 , 11:59 PM






Your code with <OBJECT> Tag will still hold good.
This is not specific to ASP / ASP.NET.
Any HTML page with that code will also work fine.

Regards,
Sanka



Quote:
-----Original Message-----
Hi All

Sorry, I know this is not the right discussion group for
my question, but trying my luck :-)

Does anybody have a sample code on how to display OLAP
Pivot Cube data within an ASP.NET page.
I have code working for ASP, but I was more interested in
knowing how to display the data in ASP.NET

In ASP I used the object

OBJECT id=PivotTable1 style="LEFT: 0px; WIDTH: 1397px;
TOP:
0px; HEIGHT: 180px" height=180 width=1397
classid="clsid:0002E552-0000- 0000-C000-000000000046"
VIEWASTEXT
<PARAM NAME="XMLData" VALUE=

'<xml xmlns:x="urn:schemas-microsoft-
comffice:excel"
x:PivotTable

Quote:
x:OWCVersion>10.0.0.4109 </x:OWCVersion

xisplayScreenTips/

x:CubeProvider>msolap.2</x:CubeProvider

x:CacheDetails/

x:ConnectionString><%=OlapConnStr%
/x:ConnectionString

.......................
</xml>'
</OBJECT

.


Reply With Quote
  #3  
Old   
Michael Shao [MSFT]
 
Posts: n/a

Default RE: OLAP Pivot Table in ASP.NET - 12-03-2003 , 04:13 AM



Hi Prasanna,

Thanks for your post. I aggree with Sanka. You can move the sample codes
with the <OBJECT> Tags into the ASP.NET enviroment. They also work fine.

Thanks for using MSDN newsgroup.

Regards,

Michael Shao
Microsoft Online Partner Support
Get Secure! - www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.


Reply With Quote
  #4  
Old   
sanith
 
Posts: n/a

Default OLAP Pivot Table in ASP.NET - 12-03-2003 , 12:01 PM



Hi
I think this link will help u to display the pivot table
from asp.net.

http://msdn.microsoft.com/msdnmag/is...10/OLAP/defaul
t.aspx

regards
sanith
Quote:
-----Original Message-----
Hi All

Sorry, I know this is not the right discussion group for
my question, but trying my luck :-)

Does anybody have a sample code on how to display OLAP
Pivot Cube data within an ASP.NET page.
I have code working for ASP, but I was more interested
in
knowing how to display the data in ASP.NET

In ASP I used the object

OBJECT id=PivotTable1 style="LEFT: 0px; WIDTH: 1397px;
TOP:
0px; HEIGHT: 180px" height=180 width=1397
classid="clsid:0002E552-0000- 0000-C000-000000000046"
VIEWASTEXT
<PARAM NAME="XMLData" VALUE=

'<xml xmlns:x="urn:schemas-microsoft-
comffice:excel"
x:PivotTable

Quote:
x:OWCVersion>10.0.0.4109 </x:OWCVersion

xisplayScreenTips/

x:CubeProvider>msolap.2</x:CubeProvider

x:CacheDetails/

x:ConnectionString><%=OlapConnStr%
/x:ConnectionString

.......................
</xml>'
</OBJECT

.


Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.