Forum Discussion

wm2's avatar
wm2
New Contributor
5 months ago

Translation Rules

Using this prompt, what 6 transformation rules need to be built? Currently I have: 1. View YTD to YTD on a one-to-one 2. Account * mask 3. Entities * mask 4. UD 3 * mask Huron Energy Servic...
Application Properties
MarcusH's avatar
MarcusH
Contributor III
5 months ago

In the cases where you can describe how you want the maps to work by referring to another dimension's target values, that is when you should think about mapping based on the target values. You will need a conditional rule for this and GolfStream has an example:

Imports System
Imports System.Data
Imports System.Data.Common
Imports System.IO
Imports System.Collections.Generic
Imports System.Globalization
Imports System.Linq
Imports Microsoft.VisualBasic
Imports System.Windows.Forms
Imports OneStream.Shared.Common
Imports OneStream.Shared.Wcf
Imports OneStream.Shared.Engine
Imports OneStream.Shared.Database
Imports OneStream.Stage.Engine
Imports OneStream.Stage.Database
Imports OneStream.Finance.Engine
Imports OneStream.Finance.Database

Namespace OneStream.BusinessRule.ConditionalRule.XFR_Conditional_Target
	Public Class MainClass
		'------------------------------------------------------------------------------------------------------------
		'Reference Code: 	XFR_Conditional_Target
		'Description:		Demonstrates how to map a flow dimenion based on the target account.
		'Usage:				Used for conditional flow member mapping based on target account.
		'Created By:		John Von Allmen
		'Date Created:		5-24-2013
		'------------------------------------------------------------------------------------------------------------		
		Public Function Main(ByVal si As SessionInfo, ByVal globals As BRGlobals, ByVal api As Transformer, ByVal args As ConditionalRuleArgs) As Object
			Try
					
				'Grab the target account value				
				Dim account As String = args.GetTarget("A#")   
				
				'Assign the flow member based on the first character of the target account
				Select Case Left(account,1)
					Case "1","2","3"
						Return "End_Inp"
					Case Else
						Return "None"
				End Select
				
			Catch ex As Exception
				Throw ErrorHandler.LogWrite(si, New XFException(si, ex))
			End Try
		End Function
	End Class
End Namespace

In your case you will want to look up the Target value (ie already mapped) of the FCT member and then get the first character of the account. It looks like the account naming is similar between the source and the target. I would add this as a Mask map that processes near the beginning of the Mask maps. And then you need to check the Transformation Sequence of the dimensions to make sure the FCT dimension is processed before the Account dimension. Cubes | Integration tab | Transformation Sequence