.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Register
 
Win Surprise Gifts!!!
Congratulations!!!


Top 5 Contributors of the Month
david stephan
Post New Web Links

OLAP: Build an OLAP Reporting App in ASP.NET Using SQL Server 2000 Analysis Services and Office XP

Posted By:      Posted Date: August 21, 2010    Points: 0   Category :ASP.Net
 

Many organizations analyze their business-critical data using Online Analytical Processing (OLAP) technology. OLAP-based data mining provides a way to query multidimensional data sets and drill down into the data to find patterns. ASP.NET and the Microsoft Office Web Components (OWC) enable Web-based OLAP reporting. The OWC controls include PivotTable and Chart components that can be embedded in a Web page and scripted by programmers. In this article, the authors build a Web-based OLAP reporting app using ASP.NET, OWC, and SQL Server 2000 Analysis Services to illustrate the process.

Jeffrey Hasan and Kenneth Tu

MSDN Magazine October 2003




View Complete Post


More Related Resource Links

SQLXML 3.0: Build Data-Driven Web Services with Updated XML Support for SQL Server 2000

  

XML is becoming the ubiquitous data format on the Web, and XML support in SQL Server is evolving to meet the additional demand. Using XML, SOAP, HTTP, and SQL Server, you can now build powerful Web Services easily. To show just how simple it is with SQLXML 3.0, this article walks the reader through the process step by step, from setting up a virtual directory enabling data access via HTTP to executing queries and building Web Services. Finally, the author illustrates the creation of two Web Services clients-one with C# that works with the Microsoft .NET Framework and one with the SOAP Toolkit 2.0 for anyone still using earlier development tools.

Christian Thilmany

MSDN Magazine May 2002


Microsoft Office 2000: Create Dynamic Digital Dashboards Using Office, OLAP, and DHTML

  

Digital Dashboards provide users with one single interface through which they can view information from a variety of sources that have been chosen specifically for that user. In addition, dashboards allow a user to view the information offline, adding portability to the mix. This article discusses options for building a dashboard based on the Microsoft Outlook folder home pages feature. It covers culling the data from disparate sources and storing it using the MSDE. It then discusses the creation of nugget definitions for structuring the data, and providing a synchronization mechanism to update to the data stores.

Todd Abel

MSDN Magazine July 2000


Analysis Services 2000 server crach

  

Hi

We have a SQL Server 2000 with SSAS 2000 on it. The SSAS data was stored in a shared disk (SAN disk), so i have the Data folder but the Bin folder was stored in the C: drive that was loosed.

How can i attach the databases to the SSAS 2000 server that i just installed

Regards

 


Jens Nilsson MCTS - SQL Server 2008 Imp. and Main.

0x80040154 error processing a cube from SQL Server 2008 R2 x64 database engine to OLAP Server 2000 x

  

I recently upgrade from SQL Server 2000 x32 to SQLServer 2008 R2 x64 but only the database engine not the Analysis Server, I used to use this code to proces the cubes.

http://weblogs.sqlteam.com/jeffs/archive/2008/10/27.aspx

but now it do not  work more with the error:
Error at create server:
Error      Source                    Description          HelpFile HelpID
---------- ------------------------- -------------------- -------- -----------
0x80040154 ODSOLE Extended Procedure  Clase no registrada NULL     0

(1 row(s) affected)

I found this article:
http://support.microsoft.com/kb/932872

It means that I can not process the cube using the same method any more ?


SQL Server 2000 Analysis Services & Excel 2003 Add-in

  
I've been working with SQL Server 2000 AS cubes and presenting them in pivot-tables in Excel 2003 with no problems.

I was recently looking at other BI tools I could use and stumbled across the Excel Add-In for Analysis Services, which adds a Cube Analysis menu to Excel and seems to have lots of functionality I could use.

But! It's no longer supported by Microsoft.

I managed to get a download of it from www.download.com and searched for help and I have some good documents to help me understand how to use it, but my problem is that it just doesn't work! I've uninstalled and reinstalled and rebooted, but to no avail.

I can connect to my data source and cube and I can view the dimensions and measures, but when I click apply on them and select the area of the report to put them into, they just don't appear. I can briefly see an EMBED command appear in the formula bar and then disappear, but nothing happens!

I've been through all the trouble-shooting and checked the settings of Excel as requested, but nothing works. 

Has anyone else had this problem or have any suggestions as to how to fix it?

Error Upgrading from SQL Server 2000 - > 2008 R2 Reporting Services

  

Hello, I am having some trouble upgrading an existing SQL Server 2000 Reporting Services installation from an old server to a new one commissioned for this purpose, which is running SQL Server 2008 Reporting Services.  I have been following the instructions here:

http://technet.microsoft.com/en-us/library/ms143724.aspx

but after trying to connect with reporting services 2008, i get this error:

The version of the report server database is either in a format that is not valid, or it cannot be read. The found version is 'C.0.6.54'. The expected version is '147'. (rsInvalidReportServerDatabase)

before starting the process, I ran upgrade advisor and got back the following results:

-----------------------------------

Description
Setup can upgrade a SQL Server 2000 Reporting Services instance that uses a SQL Server 2000 Database Engine in the same instance. However, upgrade is blocked if the report server database is in a different instance, on a remote instance, or runs on a remote SQL Server 2005 instance in SQL Server 2000 compatibility mode.

*****
*note, our reporting services IS in the same instance as the SQL Server 2000 database engine.  However, upgrade advisor still reported that this instance can not be au

Login Dialog box appears repeatedly -sql server 2000 reporting services

  

  We are running sql server 2000 with reporting services version 8.00.743.00.  Yes, I know it's old, but it works.  Anyway it worked up until a week ago.  Now when you try to render a report on IE 7 or 8 or Firefox,  the windows authentication appears multiple times. The report continues to render fine in IE 6.    
There are several posts on about this issue happening when deploying reports, but nothing about just running them.  There is also a service pack that I can apply that may address the issue.  I am leary about applying the service pack as it does not specifically address this issue. 
Any ideas ?
regards

Cannot refresh OLAP-based data in Excel Services workbook in browser (SP 2010 / Project Server 2010)

  

Hello,

In SharePoint 2010, Project Server 2010, Business Intelligence Center, upon attempting to refresh OLAP data in an Excel chart in the browser, the following error appears:

Excel
-----
An error occurred during an attempt to establish a connection to the external data source.  The following connections failed to refresh:

My ODC Connection Name
-----
OK

We have loaded and configured Project Server 2010 according to spec (http://technet.microsoft.com/en-us/library/ee662109.aspx).  Excel Services is configured according to spec (global settings, trusted file locations, trusted data providers and trusted data connection libraries).  The Secure Store Service is configured with the ProjectServerApplication target application. 

Non-OLAP data refreshes of spreadsheet data work fine in the browser.  OLAP data refreshes in the Excel client itself work fine.  Only the OLAP refreshes in the browser fail.  The problem occurs whether using a Microsoft ODC or one that we created (saved in a trusted location).

The ULS log has only one error, which is:

06/21/2010 13:47:17.86  w3wp.exe (0x1238)               &

Office Services: Merging Word Documents on the Server Side with SharePoint 2010

  

Office 2010 and SharePoint 2010 include a new set of components called Application Services. These put a rich set of tools in a developer's bag for Office automation. We'll show you how to use Office OpenXML, Word Automation Services and SharePoint to build a simple application that merges separate status reports into a single document.

Manvir Singh, Ankush Bhatia

MSDN Magazine July 2010


SQL Server 2005: Jazz Up Your Data Using Custom Report Items In SQL Server Reporting Services

  

Custom report items in SQL Server 2005 Reporting Services address your needs for custom reports without the pain of doing it from scratch.

Teo Lachev

MSDN Magazine October 2006


Data Points: Report Controls in SQL Server 2005 Reporting Services

  

Reporting has always been one of the dark arts of development. The tools typically seem to do just enough to get you to a certain point, then leave you to find workarounds to solve more complex issues.

John Papa

MSDN Magazine July 2006


Data Points: Designing Reports with SQL Server Reporting Services 2005

  

Many applications require some degree of integration with a reporting tool. A good solution, SQL ServerT Reporting Services 2005, provides Web-based reports and can be integrated into both Windows® Forms and Web-based applications.

John Papa

MSDN Magazine June 2006


Reporting Services: Deliver SQL Server Reports To SharePoint To Enhance Team Collaboration

  

The solution covered here includes a custom SharePoint Web service that accepts SQL Server-generated report files and, through the WSS object model, stores the file in the appropriate library for enhanced collaboration possibilities.

Ed Hild

MSDN Magazine March 2006


What is BPEL4WS?: Build Better Business Processes with Web Services in BizTalk Server 2004

  

In this article the author focuses on one critically important Web services specification that has been largely overlooked: the Business Process Execution Language for Web Services (BPEL4WS, or BPEL). He describes why BPEL is important and what it offers you if you are implementing Web services today or planning to in the future. Concrete examples using BizTalk Server 2004 are presented in the article.

Jon Fancey

MSDN Magazine March 2005


SQL Server: Display Your Data Your Way with Custom Renderers for Reporting Services

  

SQL Server 2005 Reporting Servicesis a great tool that offers a centralized approach to storing and rendering reports. It also lets users view and download reports without installing additional software. Plus, reports can be saved in any number of different formats using custom report renderers. In this article, the author will develop one such report renderer that outputs HTML reports, but the skills you'll learn can easily be used to create a renderer for Microsoft Word documents or any other format of your choosing.

James Yip

MSDN Magazine February 2005


Intrusion Prevention: Build Security Into Your Web Services with WSE 2.0 and ISA Server 2004

  

Once you've addressed security in your code, it's time to look at the environment it runs in. Firewalls stop unauthorized traffic from getting into your network, and smart Web service-specific firewalls, like the one that comes with Internet Security and Acceleration (ISA) Server 2004, bring XML intrusion prevention to your system for that added layer of safety.

Dino Esposito

MSDN Magazine November 2004


SQL Server 2005: Unearth the New Data Mining Features of Analysis Services 2005

  

In SQL Server 2005 Analysis Services you'll find new algorithms, enhancements to existing algorithms, and more than a dozen added visualizations to help you get a handle on your data relationships. Plus, enhancements to the Data Mining Extensions to SQL along with OLAP, DTS, and Reporting Services integration make it possible to create a new breed of intelligent apps with embedded data mining technology. Here the author explains it all.

Jamie MacLennan

MSDN Magazine September 2004


Categories: 
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend