Recent Discussions
Confirmation Rule detail
I created a new entity and workflow in OneStream. The metadata, workflow properties, and configuration are identical to existing workflows and entities. However, I noticed a difference in behavior: For the existing workflows, the confirmation rule displays results at the company level, even for entities with multiple child BUs. For the new workflow and entity, the same rule displays results at the BU level, showing multiple rows for each child BU. I have verified that the rule, meta data configuration, and workflow properties are the same.10Views0likes1CommentTransformation 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, PM14Views0likes0CommentsMoving a workflow profile
Hello, Is there a way to move a workflow profile up or down in the hierarchy tree? I created a new workflow profile, but would to move it up next to similar workflow profiles. The move up or down buttons only work for children and siblings.tbianchi5 days agoNew Contributor32Views0likes1CommentExport data using a Method Query
Hi I have a method query that returns a data table of roughly 300k of records. Is there anyway to export the result of the method query to a csv file? I'm not keen on using a spreadsheet business rule or a grid view on a dashboard given the volume of records that is being returned. Thanks, MarkSolvedMarkBird6 days agoContributor III1.7KViews1like5CommentsFDXExecuteCubeView with Consol filter
Hi All, How would I go about passing a Consol member as part of the POV to a FDXExecuteCubeView call? I want to pull one extract that is in Local currency and another that is in USD. Can I do that with this call, or do I need to set up 2 cube views, one set to Local and another set to YTD? Thanks, Scottssmith-nova9 days agoContributor41Views0likes3CommentsFdxExecuteCubeView parameters
If I build a cubeview that contains the desired POV and functions on its own, using FdxExecuteCubeView seems to work great. However, there is no documentation available on actually using the FDX functions and I can find no functional examples of how to pass the various filters/members from the FdxExecuteCubeView function to the cubeview it's actually calling. For example, I can enter T#2022M10 as part of the POV for the cube view and then FdxExecuteCubeView will create the table. However, if I pass the timeMemFilter a value of T#2022M10, I get no data. It seems obvious that I need to put something in the cube view POV to tell it to use this value but there's no indication of what that might be. Am I missing something obvious here? Is there some missing documentation or fundamental functionality that I'm unfamiliar with?Solvedparticle9 days agoNew Contributor II6.8KViews1like12CommentsCube Root Workflow Profile - Display Description
Hi Folks, I was wondering if there was a way to display a description for the Cube Root Workflow Profile in the dropdown menu. For example in my screenshot there is Corporate_MON and Corporate_WOR. I would like them to display: Corporate_MON - Monthly Forecast Workflows Corproate_WOR - Planning Workflows Note: I did try adding descriptions, they only seem to display for children of the main Cube Root Workflow Profilesmarshall29 days agoNew Contributor II14Views0likes0CommentsEncryptText And DecryptText Replacement
Does anyone know what replaces the 2 utility commands below? I get a warning message that those commands are obsolete but it does not give any indication or hints of what the new commands are or what's currently available? BrApi.Utilities.EncryptText andBrApi.Utilities.DecryptText Any help is highly appreciated. Thanks, JunSolvedJunBinghay13 days agoNew Contributor II153Views0likes3CommentsHow to export from and import to custom OS tables
Hi, For the v8 to v9 upgrade, it seems like we need to remove our custom tables and add them back after the upgrade. We have scripts to add the tables back but what is the process you follow to export and import the data back. Table Data Manager or write a script to save csv file to OS folder and load it back? Thank you in advance, PraveenMikki16 days agoNew Contributor III53Views0likes3CommentsEurope SWIFT File
Hello, I have a SWIFT Bank file from a client based in Europe that I need to import. I thought this would be similar to a BAI file and could use the OS BAI Parser solution to grab the necessary information, but the format isn't as similar as I thought. Is there any other tool for parsing out a SWIFT file or will this require some custom logic?MorganBiscoe20 days agoNew Contributor II9Views0likes0Comments