Workflow and Data Integration

Hi , I added a row from a different table to the Drill back table, but it's also showing up on page 2. Does anyone have any idea why? Thanks,    

I have some BIBlend tables I have created during testing of a Workflow. that I want to delete/Truncate Resetting the Scenario doesn't do it. Do I need to do it programatically or via a Data Management job? When I try this it tells me that the SQL is not safe (I have tried with TRUNCATE TABLE and DELETE) Thanks Steve

Hi team, I was trying to run a reset scenario for a particular time period and encountered the following error:   Has anyone else experienced this issue or have any insights on how to resolve it? Any thoughts or suggestions would be greatly appreciated. Thanks!

Anyone aware if the Smart Connector solution supports a way to access a SMB fileshare on the clients network? Use case is that client uses a file-share for flat-file exchange

Hi Everyone. I have some entities that have text at the end, for example “_Test”, and what I want to do is that in the data management I can remove the text at the end to use the original entities.Example: 12001_12000_Test to 12001_12000 I want to remove that in the section that is in the image, so I wanted to know if it is possible or if there is a solution so that the api.Data.calculate and api.Data.SetDataCell use that entity without the “_Test”.  

Hi all,I have a data management step which is of "execute business rule" type, and make use of parameters so that when I run it, it prompts me to select the parameters. The parameters are "member dialog" parameters.Now, since I want users to be able to run the step without giving them access to the Application tab, I am creating a dashboard that has a button in it to run the data management step.I have built some combo boxes that use "member list" parameters, created a data mng sequence that contains the data mng step, and a standard button which runs the data mng sequence. How do I pass the combo boxes selection to the data mng sequence?Thank you

We have created a book that when run outputs an Excel file that is 67 tabs.  It can take 20+ minutes to run on our desktop Clients and many times will time out if we are at home vs. in the office.  Anybody ever created something that would allow this book to run on the server and save the output to the Application Folder.  That would allow it to run using the Server resources and only impact our laptops when downloading the file, which should be manageable. 

we have 2 import steps on our workflow, the main Budget Import and the Fixed Cost Reallocation import. The main TB is loaded via the budget import and the fixed costs for this TB are loaded to 1 default department. Later, the entities will reallocate the fixed costs to the correct department via the Fixed Cost reallocation import, the reallocations use the same accounts but a different UD6 to distinguish between the 2 imports. But the original fixed costs amounts loaded via the main Budget import are being overwritten. Any suggestions to prevent the original fixed cost amounts be overwritten? we are using separate workflow channels, and we have tried flipping between using True and False on load overlapping sibblings but nothing is working. thanks    

Hi, We are facing a new challenge, as we want to rebuild the entire hierarchy, which has about 6000 members and about 150 parents. In this case we need to rebuild whole workflow hierarchy, is there any way to dynamically create a workflow hierarchy based on entity dimension? Regards, Michal

I'm trying to write a BR to export metadata to csv so that I can export them via a schedule. 1) Is there an easier way to repeatedly export dimensions to csv? 2) How do I look up the property name for a Member  PropertyId or a Relationship PropertyId? I am querying the members and member_properties table and I'd like to get the property name? Thank you, Scott

Hi, I added 5 more years in my forecast process, I am able to load csv data for first 4 years but having issue loading the similar data load to the last year. I can see only 3 month of data in my import M10, M11, M12. no Data load for M1 TO M09.   Nothing change in our regular process, we are using the same data source and Transformation Rules.  This is the error message i am getting.  Description: Object reference not set to an instance of an object.Error Time: 7/15/2024 2:25:36 PMError Level: ErrorTier: AppServerUser: Naseer MubashirApplication: OneStream_DevelopmentApp Server: vmDEV1Web1App Server XF Version: 7.2.4.14731Session ID: 1aa5d0b5-007e-4d47-8410-28ccc6f91aabError Log ID: eab552e3-972b-46bd-a972-d1736afb7a3b

How would I bypass import records where the time is not equal to the WF Time POV?

Hi, Can someone share sample code for sending an email notification once a workflow is processed? The email should include the following information: Workflow name Import status Validation status Cube status  

Is there an ETA on the Power BI connector ?

I have a BR that runs a load process using ExecuteParseAndTransform.  When the data source is empty for that profile it throws the "No valid DataKeys" error and stops the job.  I don't even get the opportunity to check the status code of the import.  Is there a way to catch that error when using the ExecuteParseAndTransform method?  Thanks, Scott

Hi, Data quality is unfortunately not there in all fields. I would like to be able to remap an existing code to the defined EntityDefault member when the code is not included in the constraints. Without having to define each exception on by one - (this I can do). For instance, an entity must have only American customers (my constraint), unfortunately, in the source file I have records with customers from other part of the world. When this is the case, I just want to get them replaced by the EntityDefault member (that I know is part of my constraint). Any clever idea before jumping into writing a BR? PS. I hate writing code in tools that are meant to be no or low code.

Hi! has anyone tried to download dimension data?  For example the entity dimension i want to extract in a relatively decent format ? and ideas on how?

Hello everyone, Is there a way to import data in such a way that we have more than 2 decimal places in the import step?  Our .csv files have 4 decimal places and OS is rounding those amounts to 2 decimal places. We would like to keep that level of detail Thanks in advance

Hi, Recently we upgraded our onestream to 8.2.2 and after upgrade we were not able to create files on SIC server thru this function ExecRemoteGatewayJob. please help me with this issue.   Thanks, Manju K

The goal is to get underlying dashboard data, I'm developing business rule using VB to call respective data adapter. The issue is, the data adapter has 1 parameter, not sure if it's possible to pass parameter value to it in BR. Below is my BR code and sample sql scripts for the data adapter, Dim isSystemLevel As Boolean = False Dim workspaceID As Guid = BRApi.Dashboards.Workspaces.GetWorkspaceIDFromName(si, isSystemLevel, "Default") Dim adapterName As String = "da01_entity_hierarchy_filtered" Dim rsTableName As String = "OutputTable" Dim dctVars As New Dictionary(Of String, String) Using ds As DataSet = brapi.Dashboards.Process.GetAdoDataSetForAdapter(si, isSystemLevel, workspaceID, adapterName, rsTableName, dctVars) If ds.Tables.Count > 0 Then 'If there are >0 tables in the results Using dt As DataTable = ds.Tables(0).Copy() op_table = dt.Copy() ' Clone the DataTable End Using End If End Using     SELECT C.NAME FROM Member C WHERE C.Name = '|!Sel

I know there is the cell detail upload excel template, however we are trying to load multiple periods just like a matrix load but will be loading cell detail? We basically want to load the classification etc that the cell detail option has on our forms. Thanks!

Hi all,  I have developed a process to rollover a form from one period to the next. Specifically prepayments, where the monthly movement is explained for 4 GL accounts using 20ish flows. The user enters a value in the value cell and the commentary cell.  I have created a button to run a CustomCalc DM job to copy the values entered from the prior month form and past it to the current month form. I managed to get it working for both the Values and Annotations, so that it shows the rolled forward amount on the new month form. However, when I step through Input Form > Process > Confirm, it then wipes the value at the Process stage. The rolled forward annotation does remain. I notice that when I roll forward, the value is stored as "Calculation" and in blue font. When I type a value in manually, it is in black font and it remains when processed. The main thing that I am finding weird though, is that I developed this in v7.2 and it worked. However, we have upgraded to v8.2 an

I need to create a composite mapping : For UD2, If Account is in range of 6099* and 6999* and UD2 is  [123 or 124], then UD2 is 100. In UD2 composite, If I put rule expression in composite like:   A#6099*~6999*     Target 100,  it works. But, I put expression in composite like:   A#6099*~6999* : UD2#123;124   Target 100. It does not work. It is ok, if I can even make  A#6099*~6999* : UD2#123 work. I can split above in 2 lines for list. But, I need condition for range and another dimension member. Any suggestions?  

We would like to enabled SIC in on-premises hosted environment. I see Azure relay setup is needed, is there any documentation or steps to perform those? Please advise. Thanks, Vasanth

    Post deleted by the user