The OneStream Community is temporarily frozen until June 29th due to the ongoing maintenance. Please read the blog post here to learn more.
Forum Discussion
PrithviK
3 years agoNew Contributor III
Auto Translation Property having junk values
We are having typical issue with Metadata, it's a single currency application. The Auto Translation for Currencies property is Blank and doesn't have any value. But when I check System diagnostics I ...
- 3 years ago
Do you have any idea, how you got there?
AutoTranslationCurrencies can be set by scenariotype and manually only allows you to select application currencies. Had your application other currencies in the past? Is it possible, that your metadata have a spaces in the quotes? This can happen, if you generated the metadata with an excel template.
<property name="AutoTranslationCurrencies" scenarioType="" value=" " /> instead of <property name="AutoTranslationCurrencies" scenarioType="" value="" />If you have a space, it might be responsible for your problem, another load with "" should solve the problem.
If this is not working, you can use a business rule to clear the auto translate setting.
But please test it extensively before running the business rule on a productive application.
Dim dimPkOfDimension As DimPk = BRApi.Finance.Dim.GetDimPk(si, "YourEntityDim") Dim parentMemberId As Integer = BRApi.Finance.Members.GetMemberId(si, dimtypeid.Entity, "YourTopEntity") Dim listOfEntityMembers As List(Of Member) = BRApi.Finance.Members.GetDescendants(si, dimPkOfDimension, parentMemberId) For Each entityMember As Member In listOfEntityMembers Dim entityMemberInfo As MemberInfo = BRApi.Finance.Metadata.GetMember(si, DimTypeId.Entity, entityMember.MemberId, True) entityMemberInfo.GetEntityProperties.AutoTranslationCurrencies.RemoveAllStoredPropertyItems NextIt worked on my demo application.
- 3 years ago
Yes, an extender BR is perfect. If you place it under unknown, you can run it directly from the BR.
ChristianW
OneStream Employee
3 years agoDo you have any idea, how you got there?
AutoTranslationCurrencies can be set by scenariotype and manually only allows you to select application currencies. Had your application other currencies in the past? Is it possible, that your metadata have a spaces in the quotes? This can happen, if you generated the metadata with an excel template.
<property name="AutoTranslationCurrencies" scenarioType="" value=" " />
instead of
<property name="AutoTranslationCurrencies" scenarioType="" value="" />
If you have a space, it might be responsible for your problem, another load with "" should solve the problem.
If this is not working, you can use a business rule to clear the auto translate setting.
But please test it extensively before running the business rule on a productive application.
Dim dimPkOfDimension As DimPk = BRApi.Finance.Dim.GetDimPk(si, "YourEntityDim")
Dim parentMemberId As Integer = BRApi.Finance.Members.GetMemberId(si, dimtypeid.Entity, "YourTopEntity")
Dim listOfEntityMembers As List(Of Member) = BRApi.Finance.Members.GetDescendants(si, dimPkOfDimension, parentMemberId)
For Each entityMember As Member In listOfEntityMembers
Dim entityMemberInfo As MemberInfo = BRApi.Finance.Metadata.GetMember(si, DimTypeId.Entity, entityMember.MemberId, True)
entityMemberInfo.GetEntityProperties.AutoTranslationCurrencies.RemoveAllStoredPropertyItems
Next
It worked on my demo application.
Related Content
- 2 years ago
- 2 years ago
- 4 years ago