Transformation Event Handler Guidance
Hi, I have created a transformation event handler where it throws an error when an user tries to "Clear" file/s. in Import step. Now, the error comes when user tries to delete his/her file or "All" files. I only wanted it to throw error when user (mistakenly) selects "All" imported files and click on "Clear" Is there a way to achieve this by some conditions or checks? Thanks in advance, PM
Multiple source columns to a single target dim based on hierarchical relationships - Mapping
Hello Experts, Here's the scenario: We have a flat file coming from the client's source with multiple source columns. We need "Region", "Cost Center", and "Business Unit" in this case from the file to build the solution. We have developed an unique UD2 dimension in the app which will act as a target dimension for these 3 source columns(Region, CC, & BU). Creating a one to one mapping for all the possible combinations for (Region, CC, & BU) would be tedious. Currently, we are thinking of writing a Complex Expression in the UD2(target) transformational rule, that would first lookup the parent values of all the base members from the 3 columns combination and return the respective value of it's target. Something like the below snippet. Any sample code or alternative solution would be really helpful. Thanks! Dim U1 As String = args.GetTarget("U1#") Dim U3 As String = args.GetTarget("U3#") Dim U4 As String = args.GetTarget("U4#") Dim objDimPk As DimPk = BRApi.Finance.Dim.GetDimPk(si, CostCenter) Dim sValue As Integer = BRApi.Finance.Members.GetMemberId(si, dimTypeId, memberName) Dim eValue As Integer = BRApi.Finance.Members.GetMemberId(si, dimTypeId, memberName) Dim bValue As Boolean = BRApi.Finance.Members.IsDescendant(si, objDimPk, sValue, eValue, dimDisplayOptions) If (U1 = "ABC" And IsDescendant(U4, "CostCenter", "XYZ")) Then Return "TARGETUD2" Else Return "" End If
Transformation Error of Composite Mapping Type when using "?"
I need some assistance. The following error is displayed during the Load and Transform WF step (v9.0.1.17608): The use of "?" and "*" is discussed in the Design and Reference guide as per below: Requirement: There is an entity with 5 characters with suffix _ICI30 that needs to map to C4500 if the IC has 5 characters, and another with 9 characters with suffix _ICI30 that needs to map to C3000 if the IC has 5 characters. How do I define the rule expression if E#[?????_ICI30]:I#[?????] and E#[?????????_ICI30]:I#[?????] are incorrect?
Time dependent mappings
Hi I'm look for a solution to perform time dependent mappings. For example: Source Target Prior to Dec 25 x y Dec 25 onwards x z Has anyone come across the need for the before? And if so, what solution did you implement for this? Did you notice any issues with performance etc? Thanks, Mark
Automated Extraction of Transformation rules
We have a recurring requirement to share the transformation rules/logic on a regular basis with downstream teams or auditors. Currently, this is being done manually, which is time-consuming. Is there a way to automate the extraction/export of transformation rules? Some options I’m thinking of: - Can this be done via Business Rules (BR) / Decision Model (DM) modules? - Is it possible to extract or view all applied transformation rules directly through Cube Views? - Has anyone built an automated solution (e.g., a dashboard, cube view, report, or extender rule) to export/list all transformation rules in a readable format? Would really appreciate your thoughts or examples if you’ve implemented something similar. Thanks!Complex expression to remove currency symbols?
Hi all, we have a process to format data in the csv before it's imported into OneStream. This seems like extra work and I want to create a complex expression in the Data Source to remove this step. My excel formula is =VALUE(SUBSTITUTE(SUBSTITUTE(H9,"¥",""),",","")).... all the way down for column H or the Amt field import. I've tried putting this in the complex expression but I do not have the dimensions defined properly.... does anyone have an example or suggestions they can point me towards? thank you!!!
Cubeview Drill Down issue: Load Results for Importe Cells is empty
Hello there, We are having an issue when using the Drill Down option from a Cubeview, and it's that after getting to a base data cell within the Drill Down window, and then trying to navigate to stage using the "Load Results for Imported Cell", the results window is displayed empty: The workflow that is being used it's a simple Import, Validate and Load, that retrieves the imported data from a Connector and there is no further data processing once it's in the Cube. From the Workflow Page we can use Drill Down and Drill Back just fine. Any ideas of why is this happening? Thank you. Oriol
How to treat blank values for Source field and wanted to assign it to 'None' Target member
Hi Team, My validation step failed because the source mapping is missing for blank records. I attempted to add a mapping with (blank) for the source value and None for the target value, but it didn’t work. How should blank source values be handled in the mapping? Can you please help me with this if anyone face similar issue ? Thank you
