Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Kirun
Yak Posting Veteran
60 Posts |
 Posted - 2002-05-11 : 08:31:22
|
| i have build cubes ,dimension and all stuff. No i have to put all this cube results on the web.. i have used Pivot tables and a graph utility to put then on graphical vision .. all this is working fine. but this pivot tabel is not a feasiable soloution for web. as it took whole lot time to downlaod on the client machine. is there n e other way to show these cubes result on web. or is there any light weight component available or not.regards and thanks for the time |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2002-05-11 : 08:52:29
|
| We have some articles on cross-tabs/pivot tables that use pure SQL:http://www.sqlteam.com/SearchResults.asp?SearchTerms=cross+tabBut they don't use cube data, just regular tables/views, and they're not interactive. MS Office 2000 and higher have the Office Web Components (OWC) that create relatively lightweight controls you can use on web pages, but it sounds like you're using something like that already. If not, search MSDN for "OWC", and take a look at the following ASP sites:www.4guysfromrolla.comwww.15seconds.comwww.asp101.comwww.aspalliance.comwww.learnasp.comwww.asptoday.comThe last site is a subscription site, but they definitely have articles pertaining to pivot tables and OWC on web pages. You can buy articles for $5 or subscribe for a little more, it might be worth it. Also, if you're using or thinking about using ASP.Net, the .Net framework has a boatload of advanced functions that will make pivot tables easier to use (won't need to download the entire pivot table to the client, for example) |
 |
|
|
Kirun
Yak Posting Veteran
60 Posts |
Posted - 2002-05-11 : 14:39:29
|
| yes i have seen this article but its pure sql based but here i have cubes and dimensions and all.. so this croos tab thing wont work .. i will chek for thse OWC in msdn .. and will tell you that what happned.. thanks for your time |
|
|
|
|
|
|
Is there any way other then pivot tabels