We are using version 11.2 unfortuanly we hadd to roll back the upgrade to 12.1 due to an unrelated issue.
In the FlatDataSource below I want to use the HierarchLevelDescriptor with LevelName "Coupon" that is currently commented out. I also want to delete the entire Coupon hierarchy that is currently defined. Unfortuanly when I implement the above two items I lose the formating of the Coupon property. The desired format is 5%, 6% etc., the format I get is .05, .06 etc. Also - When I use the Coupon level that is defined in the Collateral hierarchy I also change the Rows property of the FlatDataSource to [Collateral].[Coupon].
Thank you,
Sam
<
igFlatData:FlatDataSource x:Key="TKDQtyFlatData" x:Shared="False" PreserveMembersOrder
="False"
Rows
="[Collateral].[Collateral],[Coupon].[Coupon]"
Columns
="[TKDType].[TKDType]"
Measures="Qty" Cube
="Blah">
<igFlatData:FlatDataSource.CubesSettings
>
<igFlatData:CubeMetadata DataTypeFullName
="Poolman.Models.ExposureItem">
<igFlatData:DimensionMetadata SourcePropertyName="Qty" DisplayFormat
="{}{0:#,#;(#,#)}"/>
<igFlatData:DimensionMetadata SourcePropertyName="Coupon" DisplayFormat
="{}{0:#,#.###%;(#,#.###%)}"/>
</igFlatData:CubeMetadata
</igFlatData:FlatDataSource.CubesSettings
<igFlatData:FlatDataSource.HierarchyDescriptors
<igFlatData:HierarchyDescriptor SourcePropertyName="TKDType" HierarchyName
="TKDType">
<igFlatData:HierarchyDescriptor.LevelDescriptors
<igFlatData:HierarchyLevelDescriptor LevelName
="All"/>
<igFlatData:HierarchyLevelDescriptor LevelName="TKDType" LevelExpressionPath="TKDType"
/>
</igFlatData:HierarchyDescriptor.LevelDescriptors
</igFlatData:HierarchyDescriptor
<igFlatData:HierarchyDescriptor SourcePropertyName="Coupon" HierarchyName
="Coupon" >
<igFlatData:HierarchyLevelDescriptor LevelName="Coupon" LevelExpressionPath
="FmtCoupon" />
<igFlatData:HierarchyDescriptor SourcePropertyName="Collateral" HierarchyName
="Collateral" >
<igFlatData:HierarchyLevelDescriptor LevelName="Description" LevelExpressionPath="Collateral"
<!--<igFlatData:HierarchyLevelDescriptor LevelName="Coupon" LevelExpressionPath="FmtCoupon" />-->
<igFlatData:HierarchyDescriptor SourcePropertyName="DeliveryDate" HierarchyName
="DeliveryDate">
<igFlatData:HierarchyLevelDescriptor LevelName="DeliveryDate" LevelExpressionPath="DeliveryDate"
<igFlatData:HierarchyDescriptor SourcePropertyName="PM_Name" HierarchyName
="PM_Name">
<igFlatData:HierarchyLevelDescriptor LevelName="PM_Name" LevelExpressionPath="PM_Name"
<igFlatData:HierarchyDescriptor SourcePropertyName="ISFail" HierarchyName
="ISFail">
<igFlatData:HierarchyLevelDescriptor LevelName="ISFail" LevelExpressionPath="ISFail"
</igFlatData:FlatDataSource.HierarchyDescriptors
<igFlatData:FlatDataSource.ConnectionSettings
<igFlatData:FlatDataConnectionSettings ItemsSource="{Binding Items
}"/>
</igFlatData:FlatDataSource.ConnectionSettings
<igFlatData:FlatDataSource.LevelDefaultSortDirections
<igFlatData:LevelSortDirection LevelUniqueName="Collateral" SortDirection
="Ascending" />
<igFlatData:LevelSortDirection LevelUniqueName="Coupon" SortDirection
="Ascending"/>
</igFlatData:FlatDataSource.LevelDefaultSortDirections
</igFlatData:FlatDataSource
Hi Sam,
The display fomat you have applied is about a dimension based on Coupon property. Since you have a Coupon level to appear under dimension based on Collateral property you can apply such display format to dimension metadata item which is about to provide information for Collateral dimension. However, because you may have a multiple levels each with different need about its display format it's better to apply the dispaly format directly to the hierarchy level descriptor.
<igFlatData:HierarchyLevelDescriptor LevelName="Coupon" LevelExpressionPath="Coupon" DisplayFormat="{}{0:#,#.###%;(#,#.###%)}"/>
In this way you can override the display format applied to specific level.
Regards.Plamen.
Hi Plamen, sorry but that property is not available in the version we are using.