Click here to Skip to main content
15,896,557 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 130.4K   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.

body 
{
	font-family: Arial,  Trebuchet MS,Century Gothic,  Arial;
	font-size: 11px;
	letter-spacing: 1px;
	margin-top:0;
	margin-left:10;
}


td
{
	font-family: Arial,  Trebuchet MS,Century Gothic,  Arial;
	font-size: 11px;
	text-align:left;
	vertical-align:top;
}

.gridPanel
{
	width:800px;
	height:375px;
	overflow:auto;
	border:solid 1px #c0c0c0;
}


.titleLeftLockedCell
{
	font-family: Arial,  Trebuchet MS,Century Gothic,  Arial;
	font-size: 11px;
	font-weight:bold;
	background-color:#d4d0c8;
	color: #000000;
	border-bottom:solid 1px #808080;
	border-right:solid 1px #808080;
	padding: 2px;
	left: expression(parentNode.parentNode.parentNode.parentNode.scrollLeft); 
	position:relative;
	z-index: 10;
}

.titleTopLockedCell
{
	font-family: Arial,  Trebuchet MS,Century Gothic,  Arial;
	font-size: 11px;
	font-weight:bold;
	background-color:#d4d0c8;
	color: #000000;
	border-bottom:solid 1px #808080;
	border-right:solid 1px #808080;
	padding: 2px;
	width: 100px;
	top: expression(parentNode.parentNode.parentNode.parentNode.scrollTop); 
	position:relative;
	z-index: 10;
}

.titleAllLockedCell
{
	font-family: Arial,  Trebuchet MS,Century Gothic,  Arial;
	font-size: 11px;
	font-weight:bold;
	background-color:#d4d0c8;
	color: #000000;
	border-bottom:solid 1px #808080;
	border-right:solid 1px #808080;
	padding: 2px;
	top: expression(parentNode.parentNode.parentNode.parentNode.scrollTop); 
	left: expression(parentNode.parentNode.parentNode.parentNode.scrollLeft); 
	position:relative;
	z-index: 20;
}

.valueCell
{
	font-family: Arial,  Trebuchet MS,Century Gothic,  Arial;
	font-size: 11px;
	background-color:#ffffff;
	color:#000000;
	border-bottom:solid 1px #c0c0c0;
	border-right:solid 1px #c0c0c0;
	padding:2px;
	text-align:right;
	position: relative;
	width: 100px;
}


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