OneStream Platform Forums

Hi,We are currently attempting to load data into the OneStream Workflow Profile using a CSV file. However, we are encountering the following error during the process:We checked many videos and the training courses but couldn't identify where the issues is, Could you please assist us in identifying and resolving the issue?Regards

I have the code below in an Extender BR.  It runs fine if I run it manually in the BR or manually through a DM job.  But when it runs in the Task Scheduler it fails, and I get the "Object reference not set to an instance of an object." error.  Any thoughts?  Dim wfUnitClusterPk As WorkflowUnitClusterPk = BRApi.Workflow.General.GetWorkflowUnitClusterPk(si, wfProfileName, wfScenarioName, wfTimeName) Dim ImportInfo As New LoadTransformProcessInfo Try ImportInfo = BRApi.Import.Process.ExecuteParseAndTransform(si, wfUnitClusterPk, "", Nothing, TransformLoadMethodTypes.Replace, SourceDataOriginTypes.FromDirectConnection, False) Catch ex As Exception log.AppendLine("Import Done - Status: " & ImportInfo.Status & " - RowCount: " & FormatNumber(ImportInfo.RowCount, 0,,,-1)) log.AppendLine(ImportInfo.ErrorMessage) log.AppendLine("------------------------------") log.AppendLine(ex.GetBaseException.Message.ToString.Trim) End Try  

Hi,Out of Curiosity, Is it possible to update Task Activity.

We are looking to have a cube view that uses a parameter or CV Extender to possibly control the primary dimension selection. This is used in a dashboard to show metadata selections with the dimension in the rows and ud8 dynamic formulas across the columns. Looking to see if anyone has any ideas on doing the dimension selection dynamically to use one CV only for display

Hello, I am trying to update a business rule that is currently set to WFYear to the Global Time. We use the SAP Selector Solution, but I am new to it. Currently the WFYear of the user who schedules a trial balance import impacts what data is being loaded. For example, if the user's WF POV is 2024, then data is pulling from the source for 2024. I appreciate any suggestions.  Original Rule This is one idea I had, I am not sure T#|Global| will work since it is not a local variable. I also don't know if I need to change the "Dim wfYear As String = timeStr.Substring(0,4)" script. Thanks, Ronnie

Hi All, For the folks that upgraded to v8 (preferably 8.4 or 8.5), I have few quick questions. How long it took for the whole process? Did you see the performance improvement? Did you require an extensive end-user testing? How was your overall experience with upgrade. Any lessons learned that you can pass on? Thank you in advance for your time. Cheers PM

hello everyone, do you have any idea if its possible to create a home page button that will link to Application Cube> FX Rates? Thank you

Hi all,it is pretty straight forward in an dashboard extender rule to return a message box to be displayed to the user in the dashboard (like the picture below).The question I have is: is it possible to prompt the user with what I would call an interactive prompt, a prompt having a Yes and No buttons for example, and for the dashboard extender rule code to store the result of the selection for use in the rule code itself? This would be useful when displaying a warning for example. We could prompt the user with the warning and then ask if they still want to proceed or not. Thank you

Hello, I am trying to get my dynamically created buttons to execute a server task. I can create all the buttons I need in my dynamic dashboard, but as soon as I try to get them to execute a dashboard business rule, I get an error message : I have checked my services, and Everything gets validated. My WsDynamiccomponentCollection is as follow : Dim currentcomps As WsDynamiccomponentCollection = api.GetDynamicComponentsForDynamicDashboard(si, workspace, dynamicDashboardEx, string.empty, Nothing, tristatebool.TrueValue, wsdynamicitemstatetype.EntireObject) I am also using the functions SaveDynamicDashboardState and SaveDynamicComponentState : api.SaveDynamicDashboardState(si,dyncomp2,dynamicDashboardEx,wsdynamicitemstatetype.EntireObject)                            api.SaveDynamicComponentState(si,dynamicDashboardEx.DynamicDashboard,dyncompex2,wsdynamicitemstatetype.EntireObject) (dyncomp2 and dyncomp2ex being the butt

Hi all, I would like to set up a short description of a member so that I can apply different conditional formatting in the cube views. But I don't see such configuration in the metadata, may I know where I can setup this configuration? Thank you.  

Hi All,I am trying to create simple Extender rule to export only the AverateRate FX rates.  I saw this post: What is the most efficient method for exporting FX rates to a CSV file in OneStream? | OneStream Community  But this does them all.  Short of exporting to this file and creating another file from that one.  Does anyone know how I can filter the export to just get the Average Rates?I see the variable xmlOptions.ExtractAllItems = True.  But if I set it to False, I don't see what options I have to filter to specific metadata. I'm open to exploring other options as well.Thanks,Scott 

Hi,I am trying to load data from BiBlend to cube using a import validate load steps on my workflow and using also a connector, but i truggle a bit onthe connector Businessrule, i would like to know how the BR can connect to my biblend table.I have already done a br connector cube to cube, but never a biblend to cube.if you have any example of the script that i can add to my BR in order to connect the BiBlend Data table it would help a lot.Thanks, 

Hello OS Community - We are running into below error while trying to load 1 + million records from SAP via connector business rule. Tried with all the options on Cache Page Size limit, at present it is set as below. We did not have any luck so far. Any recommendations or guidance is much appreciated. Summary: The remote server returned an error: (502) Bad Gateway   Thanks.

We are using an extender business rule to run FdxExecuteDataUnit and write the data (with dimensionality) to a file.  The file generated seems to be a standard format with a column for each dimension.  Does anyone have any ideas on how to include the Member IDs in the file export? Thank you,  Denise

Hi all,I have connector rule set up to an external source table that is working fine to pull data into stage, but I would like to automate the execution of the workflow as well so that the data in the cube is refreshed nightly.  I found the below api but it looks to me like it's meant to load a flat file into stage via an extensibility rule, not from an external table. I'm not sure how to connect it to the connector/import step I want to automate. Any thoughts? Dim WFTime As String = TimeDimHelper.GetNameFromId(api.WorkflowUnitPk.TimeKey)Dim results As WorkflowBatchFileCollection = BRApi.Utilities.ExecuteFileHarvestBatch(si, "Actual", WFTime, True, True, True, True, False, False, False)

Hi all,While getting into OS, I'm trying to figure out how to leverage on its framework... And I have a question related to secrets management.Let's say that - at application (workspace?) level - I need to access to a remote service that requires an OAuth token (or user/pass tuple, or whatever I need to keep away from user's eyes - and fingers).The above mentioned secrets should be (visually?) managed by an administrator. Does OS offer something out-of-the-box to accomplish this task ? And, in case, can we leverage on some API to retrieve secret data ?Thanks for Your answers.FabioG

Hello Community,I'm writing a rule to copy data from one scenario to another using api.data.calculate.However, I would like to exclude some accounts from being copied. Something like the following:api.Data.Calculate("V#YTD:S#ACTUAL=RemoveZeros(V#YTD:S#ACTUAL_TEST)","A#Root.Base.remove(A#CAPEX_ACCOUNTS.Base)") I understand that the Remove function will not accept a member expansion. Members to be removed must be listed in the function as specified in this post:"What is the best approach to “subtract” members in a hierarchy, the following member filter is not returning the expected results. E#Tot_Mgmt.Remove(Houston) | OneStream Community"But is there any alternative to do it without listing accounts to remove one by one ?Any help is appreciated!Thank you

Hi All, I'm looking for assistance to add a column title in my current BS report. Please refer to the screenshot. I have a requirement to add a Title 1 and Title 2(Highlighted in Red) in my report. TIA  

Dear all, We have 2 custom calculate functions (Finance BR) that are executed one after the other. The 1st one uses V#Period as POV and the 2nd uses V#YTD as View POV. These POV are set on the data management steps that use these functions.We'd like to merge both functions into one to simplify maintenance but the fact that they use different View POV creates an issue; if the data management steps uses V#Periodic or V#YTD, one function will work properly but not the other. Do you know how it can be set as a fixed View POV into the functions itself? Maybe there's a way updating the value of the "args" variable that is used as an input into the formula.Thank you for the help and guidance.Best regards,Carlos 

Hi Team,   I have a question around the orphan members. I know that when we remove the relationship, the member gets moved under the Orphan section. After moving to the Orphan section, can we load data into the member through the Workflows? Thanks in advance AK  

We have FX rates published in a table to/from virtually every currency in the world. However, this is something like 70k rates a month and the vast majority are for currencies we don't use in our OneStream application. The majority of the rest are for combinations that we don't use. Of these tens of thousands of rates, only about 25-30 are actually relevant. I'm trying to automate this filtering using the currency filter from the application properties, which returns a simple comma-separated list, like so: CAD,EUR,JPY,USD In this example, I want all rates to/from USD. So, I ditch the ",USD" and want to filter on the three remaining currencies: CAD,EUR,JPY Writing a query in SSMS, this is trivial. Writing the query with straight up string manipulation in the BR is also straightforward. However, I'm trying to be (perhaps needlessly strict/cautious) by passing this in as a parameter. This makes me want to use my laptop as a non-brand-specific flying disc and restart life as a hermit in a

I am trying to record an additional Depr Exp in December 2024.   Db Depr Exp (P&L) Cr AD Machine &Equip. (BS) However, when I roll into January 2025, the effect of the December entry has been calculated into the BOP Retained Earnings, but my balance sheet does not balance.  I can tell the AD Machine & Equip account does not reflect the additional amount recorded in the journal entry.  I need to enter this JE into January of the following year, am I supposed to enter this as an unbalanced journal entry, hitting only AD Machine & Equip?  

I encountered this Boolean today for the first time after writing (and reviewing) code for five years.  There is no mention of it that I can find in the documentation.  Based on the name itself, I can guess that this is a Boolean to make sure you're not on C#Elimination or any other of the "non-Currency" members of the Cons dimension.Have I guessed correctly?

 Hi,  I'm trying to display a time-variant text property of the UD1 dimension member in a report. The challenge is that the text value can exist in any period of the member, so I currently loop through the forecast periods (spanning two years) to retrieve the values. While the code works, its performance is not good.Is there a way to fetch or look up the text properties by time (possibly from a specific table) without iterating through all periods? Any command or optimized approach to achieve this efficiently would be highly appreciated.Dim Date As String = $"{year}M{month}"   Dim timeID As Integer = timedimhelper.getidfromname("Date")Dim myVaryByTimeId As Integer = BRApi.Finance.Members.GetMemberId(si,DimType.Time.Id, Date)Dim mbrText As String = BRApi.Finance.UD.Text(si, 9, mbrId, 1, -1, myVaryByTimeId)

Hi,Is there a way that I can see all the intersection errors for all lines rather than selecting one line at a time and seeing just that one constraint error?I've checked in Application Reports and can't find anything that helps.ThanksGuy