|
|
|
|
|
|
Author Rank:
|
|
Total page views :
2413
|
|
Total downloads :
|
|
|
|
|
|
|
Similar ArticlesMost ReadTop RatedLatest
|
|
|
|
|
|
|
|
|
|
This article has been
excerpted from book "A Programmer's Guide to ADO.NET in C#".
The ActiveX Data Object Multi-Dimensional Library (ADOMD) provides access to
Online Analytical Processing (OLAP) Server data from applications. OLAP services
extract, summarize, organize, and store data warehouses in multidimensional
structure, also known as OLAP server cubes.
To test the OLAP sample, I'll use the FoodMart 2000 database that comes with the
Microsoft SQL Server Analysis Server. Before testing this sample, you must have
SQL Server 2000 Analysis Server running. If you don't have SQL Server 2000
Analysis Server running, you can install it from Microsoft SQL Server CD by
selecting SQL Server 2000 Components > Install Analysis Services. This option
will install SQL Server Analysis Service on your machine.
Note: Install Analysis Services may not install the FoodMart 2000
database. On my machine I needed to restore the database from the C:\Program
Files\Microsoft Analysis Service\Sample\ Foodmart 2000.cab file. You can restore
a database by using Analysis Manager > Meta Data > Restore option.
ADOMD functionality is defined in the msadomd.dll library. If this library is
not listed in your COM component list, you can use the Browser button in the Add
Reference dialog box to browser it. The default path for this library is
C:\Program Files\Common Files\System\ADO (see Figure 10-29).
Figure 10-29: Browsing the msadomd.dll library
After adding a reference to the msadomd.dll, the Add Reference dialog box looks
like figure 10-30.
Figure 10-30: Adding a reference to msadomd.dll library
Now click the OK button to add the reference. This action adds the ADOMD
namespace to the project (see Figure 10-31).
Figure 10-31: ADOMD namespace listed in the project namespace
Now you can use the using directive to include the ADOMD namespace in your
project and use ADOMD classes.
Note: I added a reference to the ADOMD and ADODB (described in the "Using
the ADO Recordset in ADO.NET" section) because I'll also use the Connection
object of ADO.
To test the source code, create a Windows application and add two list boxes,
two buttons, a text box, and a label and set their properties (see Figure
10-32).
Figure 10-32: Windows Form to test ADOMD
Now add references to ADOMD and ADODB in the application as follows:
using ADOMD;
using ADODB;
Also add the following variables in the beginning of the form class.
private
string strConn;
private
Connection dbConn; private Catalog
dtCatalog; private CubeDefs
cubes;
After that, create Connection and Catalog objects on the Form_Load event and use
CubeDefs of Catalog to get all the cubes. As you can see from listing 10-8, I
added all cubes to the list box and the number of cubes to the text box.
Listing 10-8: Getting all available cubes from the FoodMart 2000 database
private void
Form1_Paint(object sender,
PaintEventArgs e)
{ strConn = "Provider=msolap; Data Source
=MAIN-SERVER;" +
"Initial Catalog = FoodMart 2000;";
// Create and open a
connection
dbConn = new Connection(); dbConn.Open(strConn, "",
"", (int)ConnectModeEnum.adModeUnknown);
// Create a Catalog
object and set it's active connection // as connection dtCatalog = new Catalog(); dtCatalog.ActiveConnection = (object)dbConn;
// Get all cubes cubes = dtCatalog.CubeDefs;
// Set text box as
total number of cubes textBox1.Text = cubes.Count.ToString();
foreach (CubeDef cube
in cubes) { string str =
" "; listBox1.Items.Add(cube.Name.ToString()); str = "Cube Name :" +
cube.Name.ToString() + " , "; str += "Description :" +
cube.Description.ToString() + ", "; str += "Dimension :" +
cube.Dimensions.ToString(); } listBox1.SetSelected(0, true); }
Now if you run the application, the output looks like figure 10-33.
Figure 10-33: All available cubes in the FoodMart 2000 database
The Get Dimension button gets the dimensions of the selected cube in the left
list box in Figure 10-33. Listing 10-9 returns the dimensions of a cube and adds
it to the right list box of figure 10-33.
Listing 10-9. Getting all the dimensions of a cube
private void
button1_Click(object sender, System.EventArgs
e)
{ // Get the selected
cube CubeDef cube = cubes[listBox1.SelectedItem.ToString()];
// Get all the
dimensions of the selected cube for (int
i = 0; i < cube.Dimensions.Count; i++) { Dimension dim = cube.Dimensions[i]; listBox2.Items.Add(dim.Name.ToString()); } listBox2.SetSelected(0, true); }
The output of the Get Dimensions button fills the right list box with the
dimensions (see Figure 10-34).
Figure 10-34: Getting dimensions of a cube
The Get Dimension Members button returns the properties of a dimension such as
name, hierarchies, UniqueName, and Properties (see Listing 10-10).
Listing 10-10: Getting dimension members
private void
button2_Click(object sender, System.EventArgs
e)
{ // Get the selected
cube CubeDef cube = cubes[listBox1.SelectedItem.ToString()];
// Get the selected
Dimension Dimension dim = cube.Dimensions[listBox2.SelectedItem.ToString()]; MessageBox.Show("Dimension
Properties :: Name= " + dim.Name.ToString() + ", Description=" +
dim.Description.ToString() + ", Hierarchies="
+ dim.Hierarchies.ToString() +
", Unique Name=" + dim.UniqueName.ToString()); }
The output of Listing 10-10 looks like Figure 10-35.
Figure 10-35: Viewing dimension properties
Conclusion
Hope this article would have helped you in understanding accessing OLAP Server
Data with ADO .NET. See other articles on
the website also for further reference.
|
This essential guide
to Microsoft's ADO.NET overviews C#, then leads you toward deeper
understanding of ADO.NET. |
|
|
|
Login
to add your contents and source code to this article
|
|
|
|
|
|
|
|
|
|
|
|
C# Consulting is founded in 2002 by the founders of C# Corner. Unlike a traditional
consulting company, our consultants are well-known experts in .NET and many of them
are MVPs, authors, and trainers. We specialize in Microsoft .NET development and
utilize Agile Development and Extreme Programming practices to provide fast pace
quick turnaround results. Our software development model is a mix of Agile Development,
traditional SDLC, and Waterfall models.
|
|
Click here to learn more about C# Consulting. |
|
|
|
|
|
|
|
Introducing MaxV - one click. infinite control. Hyper-V Hosting from MaximumASP.
Finally – a virtual platform that delivers next-generation Windows Server 2008 Hyper-V virtualization technology from a managed hosting partner you can truly depend on. Visit www.maximumasp.com/max for a FREE 30 day trial. Hurry offer ends soon.
Climb aboard the MaxV platform and take advantage of High Availability, Intelligent Monitoring, Recurrent Backups, and Scalability – with no hassle or hidden fees.
As a managed hosting partner focused solely on Microsoft technologies since 2000, MaximumASP is uniquely qualified to provide the superior support that our business is built on. Unparalleled expertise with Microsoft technologies lead to working directly with Microsoft as first to offer IIS 7 and SQL 2008 betas in a hosted environment; partnering in the Go Live Program for Hyper-V; and product co-launches built on WS 2008 with Hyper-V technology.
|
Dynamic PDF
ceTE software specializes in components for dynamic PDF generation and manipulation. The DynamicPDF™ product line allows you to dynamically generate PDF documents, merge PDF documents and new content to existing PDF documents from within your applications.
|
Go.NET
Build custom interactive diagrams, network, workflow editors, flowcharts, or software design tools. Includes many predefined kinds of nodes, links, and basic shapes. Supports layers, scrolling, zooming, selection, drag-and-drop, clipboard, in-place editing, tooltips, grids, printing, overview window, palette. 100% implemented in C# as a managed .NET Control. Document/View/Tool architecture with many properties&events. Optional automatic layout.
|
Dundas Software
Dundas Chart for .NET is the most advanced .NET charting package available today. With an extremely complete feature set, elegant architecture and easy implementation, Dundas Chart can quickly add advanced Charting functionality to enhance and transform ASP.NET and Windows Forms applications. Whether you are implementing charting into internal projects, or building applications for clients, Dundas Chart offers advanced technology and advanced results to get the most out of data.
|
60 FREE UI Controls from DevExpress
Register for your FREE copy on over 60 free presentation controls from
DevExpress - Absolutely Free-of-Charge without any royalties or distribution
costs. Visit Devexpress.com/60 today. Free controls include advanced lists box, dropdown calendar, rich text edit, spin
edit, tab control and so much more!
DevExpress engineers feature rich presentation controls and reporting tools for WinForms, ASP.NET, WPF, and Silverlight. Our technologies help you build your best, see complex software with greater clarity and deliver compelling business solutions for Windows and the web in the shortest possible time.
|
Clickatell's SMS Gateway
Clickatell's Developer Solutions allow you to SMS enable any website or
application via a range of API's. Learn More about our API connections.
|
Microsoft Visual Studio 2010
Visualize your workspace with new multiple monitor support, powerful Web development, new SharePoint support with tons of templates and Web parts, and more accurate targeting of any version of the .NET Framework. Get set to unleash your creativity.
|
Nevron Chart for .NET 2010.1 Now Available
The leading .NET charting control now features PDF, Flash and Silverlight export, visualization of large datasets and more. Deliver true charting functionality to your BI, Scorecard, Presentation or Scientific apps. Download evaluation now.
|
Developer-Ready ASP.NET 2.0 Web Hosting with 3 MONTHS FREE
Now supporting .NET 3.0 Framework with Windows Workflow Foundation, Windows Communication Foundation (WCF), Windows Presentation Foundation (WPF), windows CardSpace (WCS)! Providing more flexibility for Developers with Web Services Support and a User/Permission Manger. Also supporting MS SQL 2005/2000 with Real-Time Backups, FREE Automated Attach .MDF Tool, FREE SQL Restore and Shrink SQL DB Tools, and SQL
|
|
|
|
|
|
|
|
|
|
|
|
|