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?
Hello,We plan to provide more detailed control over this functionality in some of future service releases.If you have control over items source build procedure, as workaround I suggest you to expose this data as properties with type of string if it is possible.Best regards.Plamen.
Hi
We have the "opposite" request, want to hide meassure properties from the dimensions list. Our flatdatasource has 100+ numeric properties as meassures. Problem is they also appears as dimensions which is not desireable (they are useless as such).
Any workaround to hide them from dimensions?
Any estimate on when more detailed control over meassures/dimensions will be implemented?
Kind regards, Mikael
Also, the 100+ meassure properties are actually groups of releated information. Would it be possible to define meassure groups in the flatdatasource, i.e. insert an extra level of branches under the Meassures entry to group related meassures?
Hi,
You can expect dimensions and measures separation feature with the 11.1 release planned for this spring.
Also we will discuss the possibility with 11.1 release to provide a way to define measure groups for flat data.
Best regards.
Plamen
Excellent! I'm really looking forward to the 11.1 release now :-)
Has it been achieved in 11.1...? If yes, How..?
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);
This code will produce next picture
RegardsTodor
cubeMetadata.DimensionSettings.Add(new DimensionMetadata()
{
SourcePropertyName =
"NumberOfUnits",
DisplayName =
"Number Of Units",
DimensionType =
DimensionType.Measure
});
cubeMetadata.DimensionSettings.Add(
new DimensionMetadata()
"City",
"City"