Recent Discussions
Allow 'Enter' on keyboard to search for dimensions in Cube views and Guided reporting
There was a similar request related to POV, deployed in Release 7.2, where when people search for Dimensions in POV, they can push 'Enter' and it returns search values. This does not work under Cube views and Guided reporting. It would save time if it was available in there as well. Generally using 'Enter' on the keyboard should work for all type of searches across the system.
Include Site Certificate when using HTTPClient
I'm trying to write a BR that returns data using HTTPClient. I've tested out the api.open-meteo.com example and can successfully pull data from this site. The site that I am trying to query requires a site certificate for authentication and I'm not sure how to tell my BR to use the site certificate that is already installed on the SIC server. On the SIC server, I can manually run the query to the source site via a web browser which prompts me to select the appropriate certificate. Has anyone been able to include a site certificate to a HTTPClient request? Thanks, Cosimo
DISM Email Preview Sends, But Email Not Sent During Task Execution
I’m experiencing an issue where the email template preview sends without any problem, but when I execute an import with DISM itself (actual), the email is not delivered. There are no visible errors or warnings with the data import itself. Has anyone encountered this issue before? What configurations, permissions, sender settings, or campaign requirements should be checked when preview works but live sending fails?Unable to Post Journals to Locked Entity Despite Central Journal Input Step
Hello Everyone, I’m encountering an issue in OneStream when trying to post a journal via central workflow to an entity whose workflow is locked. Normally, central journal input steps are designed to allow journal postings even when the entity’s workflow is locked. In my case, I have configured a central journal input step within the workflow profile of the entity, so I would expect journal entries to still be accepted despite the lock. However, when attempting to post the journal, I receive an error indicating that the entity is locked. Has anyone experienced a similar issue where central journal input steps do not bypass the workflow lock as expected? Are there specific configuration points or workflow setup details that could explain this behavior?
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 IfSaveCustomDataTable 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. ScottShow the Workflow Multi-Period Processing page from a dashboard button
Hi all, is there a way to open the "Workflow Multi-Period Processing" page from a dashboard button? we were able to open the pages for specific time (YYYYMM) and the different steps Import, forms, Adj. But what about the Multi-Period processing which is exeucted at the year level (e.g. 2025)? Which is the Workflow name to use in the Change POV and Workflow button POV Action? here is how we set the button Can anyone help? Thanks and regards Massimo
