OneStream Platform Forums

Has anyone had success getting Journal audit data for changes to journals (not templates but journal entries)?  I suspect they can simply be pulled from the AuditJournalHeader and AuditJournalLineItem tables but having issues.  I only get one record in the Header table no matter how often I change a particular journal and nothing populates for the LineItem table.  I feel like they are not completly working correctly or I don't understand fully how and what they are logging.  I have tried to find a report in RPTA or other solution to see if I can figure out how its done but can't find anyting from OneStream for journal changes like there is for metadata changes.  If anyone has tried to tackle this I would appreciate anything you can provide.  Thanks in advance.

Hi everyone. I have this error when trying to insert data into my SQL table 'System.OutOfMemoryException'. This occurs when I use .base to retrieve all my departments. The following is how I enter the values of a table into SQL using a loop, so I would like to know what I can do to avoid that error when I want to add many values to that table. For Each isRow As DataRow In dt.Rows Dim sqlInsert As String = $"INSERT INTO AllocationResults (Step, Amount, Annotation, SourceRule, DriverRule, Type, StepDesc, TargetRule, AllocRule, Generation, Cube, Entity, Consolidation, Scenario, Time, [View], Account, Flow, Origin, Ic, UD1, UD2, UD3, UD4, UD5, UD6, UD7, UD8) VALUES " & $"(1, {Amount}, '{Annotation}', '{SourceRule}', '{DriverRule}', '{Type}', '{StepDesc}', '{TargetRule}', '{AllocRule}', {Generation}, '{Cube}', '{Entity}', '{Consolidation}', '{Scenario}', '{Time}', '{View}', '{Account}', '{Flow}', '{Origin}', '{Ic}', '{UD1}', '{UD2}', '{UD3}', '{UD4}', '{UD5}',

Hello again, I am creating a pivot grid through a data adapter that works with SQL. The issue I have is that my column of months is not organized in the pivot. Values example: Values in the pivot grid: How can I solve this so that it adapts to how it is organized in the data adapter?

Hi, I have an Application table containing a number of attribute columns, a currency column (EUR,USD,TRY...) and an Amount column. The client wants a twin table that has all rows from the table 1, but with all values converted to euros. I already have a dashboard that shows table 1 with a button to refresh its content (pulling data from other Application tables). What is the best way of refresh table 2? I was thinking of creating an extensible rule to update table 2 on demand, but I have noticed I cannot use the api.fxrates in there... Thank you

Dear OneStreamers! Building and maintaining an OneStream application can be done in many ways, but I would like to hear how you have approached the challenge of managing the build process, hereby testing, deployment etc. I would like to hear input around:Build Process:What tools/methods make your build process a breeze?Any automation gems? Version Control:Git, SVN, or something else? How?Share your repo structuring magic and any branching/merging tips.Visual Studio / Visual Code?Testing/Quality Assurance:Testing? Automation, frameworksCI/CD Integration:How do you deploy between applications/environments?Challenges and Wins:What hurdles have you faced in this realm?Any game-changing solutions?Thanks for any input. Maybe we can gather some wise words

Currently, we have a manual process that involves a user running a Load and Transform that uses a data source with a DM Sequence as its source. That sequence uses the |WFScenario| parameter. This all works great until we try to schedule it. I pass the scenario and the time in with a parameter at the Sequence level. The first step takes this parameter (e.g., Scenario=BudgetFinal) and creates a trigger file in the Batch folder and runs ExecuteFileHarvestBatch. The correct workflow executes but appears to be pulling its data (via that first DM Sequence/Data Source using WFScenario) from my current, user WF/POV. I've tested this by navigating to correct WF/Scenario, then running the DM job I want to schedule and the data successfully imports. If I then navigate to a different scenario and run the same DM job again, the import fails with the error that there is no data. I would expect the WFScenario parameter to use the scenario of the WF that is specifically calling the parameter but that

Hello, Is there a way to pull the account type in Excel add-in for OneStream? I tried using XFGetCell and XFGetMemberProperty and it didn't work.  Thanks, Will

May I ask how to use Case IS = ExtenderFunctionType.ExecuteExternalDimensionSource? It will be great if we have use cases and examples. Thank you

 I have a source file that will be updated/changed with the entities being loaded every time when it is loaded via a WF.In Order to preserve the balances of the Entities previously loaded I am thinking to have Source ID same as my Entity Name as I don't see any "Merge" Mode Load Option in WF. Is there any other way or better option to load files in Merge Mode.

Hi - I am having issues with using the PriorPeriod12() in a row override. The following filter is supposed to use the PriorPeriod12() function to return the same month last year (e.g. input of 2023M10 should return 2022M10).  GetDataCell(T#|!Param_Select_Time!|:U2#Alt_AandG:V#Trailing12MonthTotal/A#EndingACV:V#MTD:U2#Alt_AandG:T#PeriodPrior12(|!Param_Select_Time!|))) However, when I replace the T#PeriodPrior12(|!Param_Select_Time!|) with say 2022M10, then the override works. Any ideas of a work-around? Thanks,  

Hi community, With a button in a dashboard, I want to open an Excel file: FileSourceType=Dashboard, UrlOrFullFileName=[Input_Sales.xlsx], OpenInXFPageIfPossible=False, PinNavPane=False, PinPOVPane=False If Input_Sales.xlsx is in the default workspace, this works fine. If it is not I can't get it to work. Which syntax can I use to open a file from a specific workspace? With kind regards, Tim

I'm trying to create a Dashboard parameter that has the OS Version number of the application. I would have thought that something likeDim osVersion As String = OneStream.Shared.Common.GeneralStrings.OSVersionwould return the value, but this simply returns the string "OS Version". Can someone please point me to the correct function or member to get the application version number?

I ran an import which was stuck on parsing data, I clicked on Cancel Task, but it has been stuck on 'Cancelling By User' task status for over an hour.Any solutions to cancel the task? I am unable to rerun the task as it is still "running"

I want to update the parameter of my dictonary . How can i achieve it? .add adds the value in the dictonary. Is there any update function to update the value of that key in dictonary Dim params2 As New Dictionary(Of String, String) params2.Add("Entity_param_db","E001" ) For Each MemberOfList As MemberInfo In Nonstreamproduct             params2.Add("Entity_param_db",MemberOfList.Member.Name)             BRApi.Utilities.StartDataMgmtSequence(si,dataMgmtSeq2, params2)Next

Dear community,   I am trying to calculate 2 values directly in my XF Document. There is a part in the online documentation that is saying : Include Member Scripts in XFCells in order to retrieve data for specific Dimension Members.  Culture User is based on the computer’s Windows settings and the User settings.XFCell(Memberscript, Culture=User, NumberFormat=N3,DisplayNoDataAsZero=True, Scale=3, FlipSign=True, ShowPercentageSign=False)  Unfortunalety it does not give much details as to what the "memberscript" should be ... So far, I have 2 parameters build up with XFCell, that are giving me the right values. But Now that I simply need to calculate the ratio between those value, and get this ratio back in the word document, I'm a little bit stuck ...   Regards,

I am creating a dashboard that has several sections. The middle section is a cube view and I need to add horizontal and vertical scroll bars. I looked at existing dashboards and can't find where the setting is. Could someone please advise where to change the settings. Thanks.

Hi everyone,I'm struggling with a feature of cube views, hope anyone can helpWhen i insert on the same row two dimensions, selecting for the second one more than one element, as shown belowas soon as i launch the cube view, the U2 dimensions are shown grouped:and i need to click + to show them.Is there a way to prevent the elements to be automatically grouped when I launch the CV?

Dear community, I'm creating a very simple balanced journal template, with the exception that this journal will have to use "alternative input currency" flows. For that, I have set 2 flows like below : Input_USD : Input_CNY (chinese yuan):   My journal is of "balanced" type. However, I have input done in both USD and Chinese Yuan and the Journal doesn't seem to care ? In the exemple below, I have 20 USD booked, and 20 CNY booked, and OneStream considers the journal posting as "balanced" : Am I missing something ? Regards,      

We have our main hierarchy that has intercompany eliminations working as they should. We also have 2 alternate hierarchies where one is eliminating as it should, and the other is not eliminating.  Consol -   Primary Hierarchy - Percent Consolidation 100Consol - Alternate hierarchy - Percent Consolidation 0  - Elimins not working at first common parent,Second Alt Hierarchy - Percent consol 100 - Eliminations working as they should.  

In the extensibility rule, there is a case choice of ExtenderFunctionType.Unknown. I am wondering in which situation we should use this? It would be great if we could have a few use cases with examples. Thank you

Hello,For purpose of grouping we have some accounts listed as member filter in a single row:A#VOL_O_StockWIP:Name(Opening Stock Volume), A#VAL_O_StockWIP:Name(Opening Stock Value) etceteraSome of these would need a different format to make it easer to recognize them, if I make a separate row the grouping on the primary filter will be gone.Is there a code that can be used after a member filter to apply formatting?A solution in either the cubeview, or Excel AddIn would be helpful.Thanks in advanceBen

I am wondering where are the files in the Application Database Folder and System Database Folder physically stored? I am able to find the files under FileShare in the directory where OneStream is installed, but I cannot find the physical folder structure of the Application Database Folder and System Database Folder. Please advise. Thank you

Hi,We have a workflow as below - contains multiple 'Import' workflow profiles.  We want to be able to lock 'IFRS16' without locking 'ImportAX', 'RevenueImport'.  Lock after Certify is activated.  When selecting IFRS16, Lock, all 'import' profiles are getting locked.  Do we need Workflow Channels or split the Workflow and keep IFRS16 separate ?  Thanks for your advice. HildeWhen selecting Lock with IFRS16 highlighted :   

Hi,Is there any way to manipulate a workflow profile or create a new one using a business rule? If not, any way to extract / load xml in a BR? Can't find anything that would help me while browsing the api.

Hi everyone. I'm trying to add values to a SQL table, I have checked with several functions of the BRApi.Database, but none of them work for me. My code example:#The variablesDim sqlTest As String = $"INSERT INTO AllocationResults (Step, Amount, Annotation, SourceRule, DriverRule, Type, StepDesc, TargetRule, AllocRule, Generation, Cube, Entity, Consolidation, Scenario, Time, View, Account, Flow, Origin, Ic) VALUES (1, {Amount}, {Annotation}, {SourceRule}, {DriverRule}, {Type}, {StepDesc}, {TargetRule}, {AllocRule}, {Generation}, {Cube}, {Entity}, {Consolidation}, {Scenario}, {Time}, {View}, {Account}, {Flow}, {Origin}, {Ic})" Using dbConnApp As DBConnInfo = BRAPi.Database.CreateApplicationDbConnInfo(si)     BRApi.Database.ExecuteActionQuery(dbConnApp, sqlTest, False,True)End Using