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
Its still broke but I've spent far to much time futzing with it. I'll just wait till we can upgrade. Thanks for your help.
Hello,
I am just checking, if you require any further assistance on the matter.
My suggestion is to try:
<igFlatData:DimensionMetadata SourcePropertyName="Collateral" DisplayFormat="{}{0:#,#.###%;(#,#.###%)}"/>
since the level you're going to format is part of Collateral hierarchy. I expect that this format will take into account just where it's applicable so non-numeric levels will stay unformatted.
Hi Plamen at this time we cannot change builds. Are you referring to this xaml in my original post? It does not work:
Have you upgraded to the latest 11.2 SR? I can see this property is available in build 11.2.20112.2207. If you're limited to use a specific build you can try to apply the display format to Collateral dimension metadata.
Plamen.