It seems that the dimensions are counted as cubes, when you are connected as an administrator.
Quote from book Page 448, MDX Solutions (Second Edition, Wiley)
In Microsoft Analysis Services 2005, each dimension is also presented as a Cube. These Cubes are named by prefixing a $ to the dimension name. These special cubes are restricted to users with database administrator rights.]
Example Code from MSDN
http://msdn.microsoft.com/en-us/library/ms123461(SQL.90).aspx
- Code: Select all
private string RetrieveCubesAndDimensions()
{
System.Text.StringBuilder result = new System.Text.StringBuilder();
//Connect to the local server
using (AdomdConnection conn = new AdomdConnection("Data Source=localhost;"))
{
conn.Open();
//Loop through every cube
foreach (CubeDef cube in conn.Cubes)
{
//Skip hidden cubes.
if (cube.Name.StartsWith("$"))
continue;
//Write the cube name
result.AppendLine(cube.Name);
//Write out all dimensions, indented by a tab.
foreach (Dimension dim in cube.Dimensions)
{
result.Append("\t");
result.AppendLine(dim.Name);
}
}
//Close the connection
conn.Close();
}
//Return the results
return result.ToString();
}