Saturday, May 24, 2008

OLAP related articles that may interest you

I wrote these articles during the reign of SQL Server 2000 and may be of some relevance to some at least.

Have you ever wanted to take a closer look at OLAP cubes? If so, you have come to the right article. A subset of the fine details of the highly structured OLAP cube is probed in this tutorial using Visual Basic.

http://www.aspfree.com/c/a/Database/Exploring-OLAP-Cube-with-Visual-Basic/

Have you ever wondered how to access data for an SQL 2000 Analysis server from Microsoft's Excel program? This article will show you a step-by-step procedure.The main objective of this article is to show a step-by-step procedure for accessing data for an SQL 2000 Analysis server from Microsoft Excel. Data access can also be accomplished by VB, Visual Studio .NET 2003 IDE, and by running Multidimensional Expressions (MDX) queries against an Analysis server. Before getting into the nuts and bolts of this a few clarifications are in order as to the location and origin of the data.

http://www.aspfree.com/c/a/MS-SQL-Server/On-Accessing-Data-From-An-OLAP-Server-Using-MS-Excel/

Most of the time the interest is in generating reports in the form of hard copies, or interactive reports that can be generated on the fly on client platforms, or reports that can be seen on a web page. There are many options for generating reports such as MS Access, Crystal Reports, Designer objects in VB, SQL Reporting Services, Actuate, and so forth. This tutorial is a step-by-step guide to generating reports from an OLAP server such as Microsoft's Analysis Server using Crystal Reports (ver. 8.5)

http://www.aspfree.com/c/a/Database/Crystal-Report-from-OLAP-Data-Introduction/

No comments: