Click here to Skip to main content
15,885,027 members
Articles / Web Development / IIS

Microsoft Analysis Services 2005: Displaying a grid using ADOMD.NET and MDX

Rate me:
Please Sign up or sign in to vote.
4.76/5 (21 votes)
19 Aug 2008CPOL9 min read 129.8K   3.4K   61  
The article explains how to fetch data from Microsoft Analysis Services 2005 (OLAP) Cube using ADOMD.NET and MDX, and display it in the form of a grid.
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" >
<head>
    <title>Disclaimer</title>
</head>
<body style="background-color:#d4d0c8;margin:10px">
<p style="font-family: Arial; font-size:12px;font-weight:bold; text-align:center">Disclaimer</p>
<p style="font-family: Arial; font-size:12px;">
A NONEXCLUSIVE COPYRIGHT LICENSE IS GRANTED TO USE ALL PROGRAMMING CODE EXAMPLES IN THIS SAMPLE FROM 
WHICH YOU CAN GENERATE SIMILAR FUNCTION TAILORED TO YOUR OWN SPECIFIC NEEDS. THE SAMPLE CODE PROVIDED 
IS FOR ILLUSTRATIVE PURPOSES ONLY. THESE EXAMPLES HAVE NOT BEEN THOROUGHLY TESTED UNDER ALL CONDITIONS. 
I, THEREFORE, CANNOT GUARANTEE OR IMPLY RELIABILITY, SERVICEABILITY, OR FUNCTION OF THESE PROGRAMS.
ALL PROGRAMS AND INFORMATION CONTAINED HEREIN ARE PROVIDED TO YOU "AS IS" WITHOUT ANY EXPRESS OR IMPLIED 
WARRANTIES OF ANY KIND. THE IMPLIED WARRANTIES OF NON-INFRINGEMENT, MERCHANTABILITY AND FITNESS FOR A PARTICULAR 
PURPOSE ARE EXPRESSLY DISCLAIMED. I SHALL NOT BE LIABLE FOR ANY COST OR DAMAGE ARISING EITHER DIRECTLY 
OR INDIRECTLY FROM THE INFORMATION IN THE ARTICLE OR USE OF THE SAMPLE CODE. IT IS SOLELY YOUR RESPONSIBILITY TO EVALUATE THE ACCURACY, 
COMPLETENESS AND USEFULNESS OF ALL OPINIONS, ADVICE, SAMPLE CODE AND OTHER INFORMATION PROVIDED HERE. 
I DO NOT WARRANT THAT ANY INFORMATION OR SAMPLE CODE IS ERROR-FREE</p>
    <p style=" text-align:center"><input type="button" value="    Ok    " onclick="javascript:window.close()" /></p>
</body>
</html>

By viewing downloads associated with this article you agree to the Terms of Service and the article's licence.

If a file you wish to view isn't highlighted, and is a text file (not binary), please let us know and we'll add colourisation support for it.

License

This article, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)


Written By
Architect Nexvisionix Inc.
India India
Click here to email Hitesh

Hitesh lives in Mumbai, INDIA and works with Nexvisioinix, one of the leaders in providing solutions based on Microsoft BI technologies. (For more information on Nexvisionix visit www.nexvisionix.com)

Since year 2003, he has been working on Microsft .NET and BI technologies such as Microsoft Analysis Services 2005. He is also proficient in MDX.

Comments and Discussions