Database
  Home arrow Database arrow Exploring OLAP Cube with Visual Basic
ASP Free Forums 
.NET  
ASP  
ASP Code  
ASP.NET  
ASP.NET Code  
BrainDump  
C#  
Code Examples  
Database  
Database Code  
IIS  
Microsoft Access  
MS SQL Server  
Visual Basic.NET  
Windows Scripting  
Windows Security  
XML  
ASP Web Hosting  
ASP.NET Web Hosting 
Dedicated Servers 
Actuate Whitepapers 
VeriSign Whitepapers 
Windows Web Hosting
 
IBM® developerWorks 
Sun Developer Network 
Weekly Newsletter
 
Developer Updates  
Free Website Content 
 RSS  Articles
 RSS  Forums
 RSS  All Feeds
Write For Us Get Paid 
Request Media Kit
Contact Us 
Site Map 
Privacy Policy 
Support 
 USERNAME
 
 PASSWORD
 
 
  >>> SIGN UP!  
  Lost Password? 
DATABASE

Exploring OLAP Cube with Visual Basic
By: Jayaram Krishnaswamy
  • Search For More Articles!
  • Disclaimer
  • Author Terms
  • Rating: 5 stars5 stars5 stars5 stars5 stars / 21
    2005-08-18

    Table of Contents:
  • Exploring OLAP Cube with Visual Basic
  • Measures and Dimensions: Cube details under investigation
  • Using VB to Explore the OLAP Cube: Creating a VB Project
  • Properties of the Cube: Properties of Dimensions
  • Properties of Hierarchies
  • Properties of Levels

  • Rate this Article: Poor Best 
      ADD THIS ARTICLE TO:
      Del.ici.ous Digg
      Blink Simpy
      Google Spurl
      Y! MyWeb Furl
    Email Me Similar Content When Posted
    Add Developer Shed Article Feed To Your Site
    Email Article To Friend
    Print Version Of Article
    PDF Version Of Article
     
     
    ADVERTISEMENT

    Stay one step ahead of the competition. Evaluate and give feedback on some of the hottest web development tools on the market today. Make your opinion heard! Click Here

    Exploring OLAP Cube with Visual Basic


    (Page 1 of 6 )

    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.

    Introduction

    In an earlier tutorial the mechanics involved in accessing OLAP data from MS Excel were described. Pivot table service provided by the Analytical Services was used to access the data. In this tutorial, we will look at programmatically exploring the various structural details of the Cube, a basic unit of storage of data used in analyzing business related data. In a future article, creating the cube from scratch will be described, but you should also review the online tutorial that is bundled with Microsoft Analytical Services; it takes you through a tour that helps with understanding Analytical Services. This tutorial is divided into the following sections:

    • Cube Basics
    • Measures and Dimensions
      • Cube details under investigation
    • Using VB to explore the OLAP Cube
      • Creating a VB project
      • Add library references
      • Storing global variables in the module
    • Properties of the Cube
      • Properties of Dimensions
      • Properties of Hierarchies
      • Properties of Members
      • Properties of Levels
    Cube Basics

    In Analytical Services, measures and dimensions describe a cube. The dimensions and measures are derived from the cube's data source. The set of tables with their relationships used to derive the dimensions and measures is called the cube's schema. The cube consists of a single fact table and one or more dimension tables. Measures are obtained from columns in the fact table, and dimensions are obtained from the columns of the dimension table.

    More Database Articles
    More By Jayaram Krishnaswamy


       · You are welcome to comment. Hierearchy is a big deal in OLAP. There are two aspects...
       · You article about Olap (cubes) with VB (6.0) was very interesting. I'm thinking if...
       · Right now I do not have one, but I have been planning on writing a sequel. However,...
       · Is there a way in .NET to programmatically create a new dimension for an existing...
     

    DATABASE ARTICLES

    - Database Programming in C# with MySQL : Usin...
    - Formatting Techniques for Data Access from E...
    - Data Access from Excel VBA
    - Generating a Multiple Table Crystal Report u...
    - ADO and the Command Object
    - On Wiring Up an ADO Data Control
    - Reading and Writing to Files on the Intranet
    - Using ADO Record to Create and Navigate Intr...
    - Using Data Access Pages to Access Data on a ...
    - Using ADO with the SQL Native Client
    - ADO`s Stream Object
    - Opening a Record Object Referencing an Open ...
    - Introducing Jasper (SQL Anywhere 10 Beta)
    - Creating a Database Project in VS 2005
    - Manipulating ADO Recordsets





    © 2003-2008 by Developer Shed. All rights reserved. DS Cluster 1 hosted by Hostway