Recent Discussions
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?
How to write Smart Integration Function in Assembly
Hi, I have created one one Smart integration function in to transfer file from sftp server to share point server. can we use smart integration function as a file or use existing smart integration function as dependency , not sure just need suggestions.
SaveCustomDataTable behaviour in different Versions of OS
I have used SaveCustomDataTable in OS v9.01 where you need to clear the data before loading the table and it works fine. Recently i was building similar logic in OS v8.2 and noticed that it was truncating my table , is this expected or is there something i am missing it is the standard call: BRApi.Database.SaveCustomDataTable(si, "Application",Table,dt,True)
Async processing in a Connector Business Rule
Hi All, I am writing an Connector BR to connect to a system via their API. I first build the rule as a Extender rule so that I can test the logic. So far it works great. It uses Asynchronous processing on all of the web calls. When I try to move that code into a Connector BR, I am having an issue on the GetFieldList part of it. When I try to use it in a data source, I get the following error: Unable to cast object of type 'System.Threading.Tasks.Task`1[System.Object]' to type 'System.Collections.Generic.List`1[System.String]'. I am guessing this is because the Main module in the BR is public async Task<obect> Main so whatever is returned is going to be a Task<object>. Has anyone done Asynchronous processing in the connector rule and had the GetFieldList part working. My only thought to get around this is the write the data to a table/file with the Extender BR then the Connector reads that. Any thoughts are greatly appreciated. Scott
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!Automate Data extract after consolidation
Hello, I have an extract I am looking to automate with the task scheduler. However, I am looking to also automate a run once a consolidation completes and also have the ability to cancel a scheduled export with a button if it is set at a time when a consolidation is taking place. Is it possible to accomplish this?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!!!
