Hi Resul,

I can suggest you two approaches.

The first one is to subscribe your flatdatasource to MetadataTreeItemAdding event. In the event handler you can hide the measure generated from a property.

Sample code in c#:

if (e.Item.ItemType == ItemTypes.Measure && (IMeasure)e.Item.DataObject != null && ((IMeasure)e.Item.DataObject).UniqueName == "<measure unique name>")

{ e.Cancel = true; }

Sample code in vb:

If e.Item.ItemType = ItemTypes.Measure AndAlso DirectCast(e.Item.DataObject, IMeasure) IsNot Nothing AndAlso DirectCast(e.Item.DataObject, IMeasure).UniqueName = "<measure unique name>"

Then  e.Cancel = True End If

The second approach is to set DimensionType property of a DimesionMetadata instance while creating flatdatasource in code behind.

Sample code c#:

DimensionMetadata unitsMetaData = new DimensionMetadata();            

unitsMetaData.SourcePropertyName = "<PropertyName>";

unitsMetaData.DimensionType = DimensionType.Dimension;

Sample code vb:

Dim unitsMetaData As New DimensionMetadata()

unitsMetaData.SourcePropertyName = "<PropertyName>"

unitsMetaData.DimensionType = DimensionType.Dimension