|
ASP.NET as a Client for Business Intelligence
|
Enterprise reporting lets IT take five steps to overcome major barriers that develop when organizations are limited to spreadsheets and siloed reporting tools.
|
|
Introduction
“We are drowning in information and starving for knowledge”
- Rutherford D. Rogers, The New York Times, 25th February 1988.
In recent times Business Intelligence (BI) has gathered a significant momentum across organizations and industries. Organizations around the world need access to timely and accurate data to discover and distribute a useful business insight that in turn offers
competitive advantage of better, faster and reliable business decisions to organizations.
Using BI applications now it is possible to access and analyze information in almost
every dimension of business. With recent improvements in information technology have
made it faster to access large volumes of data and made it quite economical to distribute
useful business insights from BI solution to more number of users who need it.
Organizations use different BI tools and technology to develop different types of business intelligence applications. Some of the features that BI tools support are typically data analysis (both real time and historical data), web based interactive reporting, OLAP and alert messaging or notification services. Along with these set of features the tool should be easy to implement and manage and at the same time flexible enough to accommodate future changes and complexities of business.
In this article I will be using Microsoft SQL Server 2000 as database server, Microsoft SQL Server 2000 Analysis Services to build the BI implementation and ASP.NET as a web client to access this implementation and for presentation.
This article assumes you are comfortable using SQL Server 2000 Analysis Services,
using and have a good understanding of programming ASP.NET with C# code behind.
Requirements:
1. SQL Server 2000
2. SQL Server 2000 Analysis Services and MDX Sample Application.
3. Visual Studio .NET (.NET Framework 1.1)
4. IIS 5.0 or above.
Procedure Summary:
1. Build cube(s) from the warehouse and process it
2. Create MDX queries required for producing the required reports
3. Build ASP.NET page to provide interface for the report
4. Write code behind the ASP page to perform the following:
i. Connect to the database
ii. Execute the MDX query
iii. Show the results (as a table or using Pivot Table)
|
|
|
Oracle #1 in Business Analytics According to IDC Research
|
The Business Intelligence Search Engine has all the answers.
|
Find all you need on The Business Intelligence Search Engine.
|
|
|
|
|
|
|
|
|
|
