protected void MeasureFieldAdd_Click(object sende, EventArgs e)
{
Olap.MeasureFieldInfoCollection selectedItems = new Olap.MeasureFieldInfoCollection(lbSelectedMetricFields.Items);
ListEditItem item = lbMetricFields.SelectedItem;
if (item != null &&
selectedItems.Find(item.Value.ToString()) == null)
{
selectedItems.Add(new Olap.MeasureFieldInfo(item));
Helpers.SetDataSource(lbSelectedMetricFields, selectedItems, "UniqueName", "Caption");
}
}
private void LoadFields()
{
String connectionString = System.Configuration.ConfigurationManager.ConnectionStrings["OLAPConnection"].ConnectionString;
using (AdomdConnection conn = new AdomdConnection(connectionString))
{
conn.Open();
CubeDef cubeDef = null;
foreach (CubeDef cube in conn.Cubes)
{
if (cube.Type == CubeType.Cube)
{
cubeDef = cube;
break;
}
}
if (cubeDef == null)
{
m_DimFieldCollection.Clear();
m_MeasureFieldCollection.Clear();
return;
}
DimensionCollection dimCollection = cubeDef.Dimensions;
foreach (Dimension dim in dimCollection)
{
if (dim.DimensionType == DimensionTypeEnum.Measure)
{
continue;
}
HierarchyCollection hierarchyColl = dim.Hierarchies;
foreach (Hierarchy hier in hierarchyColl)
{
m_DimFieldCollection.Add(new Olap.DimensionFieldInfo(hier));
}
}
MeasureCollection measureCollection = cubeDef.Measures;
foreach (Measure m in measureCollection)
{
m_MeasureFieldCollection.Add(new Olap.MeasureFieldInfo(m));
}
}
}
public override void Load_InitData()
{
if (Mode != ControlMode.New)
{
return;
}
ASPxComboBox cbbKeyField;
try
{
cbbKeyField = (ASPxComboBox)this.FindControl("cbbKeyField");
if (cbbKeyField == null) { return; }
}
#if DEBUG
catch (Exception ex)
{
throw ex;
}
#else
catch ()
{
return;
}
#endif
// Load fields
String connectionString = System.Configuration.ConfigurationManager.ConnectionStrings["OLAPConnection"].ConnectionString;
using (AdomdConnection conn = new AdomdConnection(connectionString))
{
conn.Open();
// Find a cube
CubeDef cubeDef = null;
CubeCollection cubeCollection = conn.Cubes;
int numOfCube = cubeCollection.Count - 1;
for (; numOfCube > 0; numOfCube--)
{
cubeDef = cubeCollection[numOfCube];
if (cubeDef.Type == CubeType.Cube) { break; }
}
if (this is wcNormalFilter
|| this is wcTimeFilter)
{
Olap.DimensionFieldInfoCollection fields = new Olap.DimensionFieldInfoCollection();
// Load dimension field
DimensionCollection dimCollection = cubeDef.Dimensions;
int numOfDim = dimCollection.Count;
for (int dimIndex = 0; dimIndex < numOfDim; dimIndex++)
{
Dimension dim = dimCollection[dimIndex];
if (this is wcNormalFilter)
{
if (dim.UniqueName == "[ARDimTime]"
|| dim.DimensionType == DimensionTypeEnum.Measure)
{
continue;
}
}
else if (this is wcNumFilter)
{
if (dim.DimensionType != DimensionTypeEnum.Measure)
{
continue;
}
}
else // Date
{
if (dim.UniqueName != "[ARDimTime]")
{
continue;
}
}
foreach (Hierarchy hier in dim.Hierarchies)
{
fields.Add(new Olap.DimensionFieldInfo(hier));
}
}
Helpers.SetDataSource(cbbKeyField, fields, "UniqueName", "Caption");
}
else // wcNumFilter
{
Olap.MeasureFieldInfoCollection fields = new Olap.MeasureFieldInfoCollection();
MeasureCollection measureCollection = cubeDef.Measures;
int numOfMeasure = measureCollection.Count;
for (int mIndex = 0; mIndex < numOfMeasure; mIndex++)
{
Measure m = measureCollection[mIndex];
fields.Add(new Olap.MeasureFieldInfo(m));
}
Helpers.SetDataSource(cbbKeyField, fields, "UniqueName", "Caption");
}
}
}
protected void MeasureFieldAdd_Click(object sende, EventArgs e)
{
Olap.MeasureFieldInfoCollection selectedItems = new Olap.MeasureFieldInfoCollection(lbSelectedMetricFields.Items);
ListEditItem item = lbMetricFields.SelectedItem;
if (item != null
&& selectedItems.Find(item.Value.ToString()) == null)
{
selectedItems.Add(new Olap.MeasureFieldInfo(item));
Helpers.SetDataSource(lbSelectedMetricFields, selectedItems, "UniqueName", "Caption");
}
}