Meaures and Data Selector | Infragistics Forums

Meaures and Data Selector

George posted over 13 years ago

Hello,

I currently am building a cube that will be used in a FlatDataSource. I have everything working correctly but I have one question.

The data I am pulling comes from a web service and comes back in one giant joined table (its type is a List). The problem I am having is that some of the columns are being added as measures, such as CustNum. I know how to hide these from cube using the DimensionMetaData.AutoGenerateField property but that property also hides them from the regular columns. How can I control which columns become measures and which ones are columns/rows?

7922

[Infragistics] Todor Karkelanov posted over 13 years ago in reply to Sajjad

Yes

There is a new property in DimensionMetadata class called GroupName. You can use it in follow way:

CubeMetadata cubeMetadata = new CubeMetadata { DataTypeFullName = "IG.Model.CarsSales", DisplayName = "My excel cube" };
 
DimensionMetadata calcMeasureMetadata = new DimensionMetadata
{
    GroupName = "group",
    SourcePropertyName = "Agr",
    DimensionType = DimensionType.Measure,
    DisplayName = "Final Price",
    Aggregator = new CustomMeasureAggregator(this._flatSource)
};
 
cubeMetadata.DimensionSettings.Add(calcMeasureMetadata);