OneStream Platform Forums

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

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 

I need to delete a single record in the Error Log but my Data Adapter won't let me, complaining about "unsafe SQL statements".In a rather bone-headed move, while developing a BR, I accidentally wrote an insanely large block of text to the Error Log -- like somewhere between 1.3 and 1.5 million characters -- in a single record via BRApi.ErrorLog.LogMessage.It's made the Error Log workspace page pretty much unusable because it's trying to read that record to display it. It takes 5 or 6 minutes to display the Error Log.After finding the UniqueID for the offending record in the ErrorLog table, I tried the following SQL in a Data Adapter to remove the record:DELETE TOP (1) from myOneStream_Framework.dbo.ErrorLog where UniqueID = 'bb5158a6-aae9-471c-b883-edddc8640a5e'Apparently, OneStream thinks I am a cyber-criminal and blocked my code execution with the following message: Database query error. The specified SQL statement is not safe.I also tried:UPDATE myOneStream_Framework.dbo.E

Hi Everyone. I am creating a CSV file with the information from a datatable. The problem is that it generates the file with the columns but without the datatable information. I wanted to know if there is another way to create a CSV file correctly. Dim strFilePathFull_AllocationDetails As String = strFilePath & "/" & strModelName & "_" & strScenarioName & "_" & strTimeName & "_" & dtAllocationDetails.TableName & ".csv" Dim xfeFile_AllocationDetails As XFFileEx = dtbSH.DataTableToFile(si, dtAllocationDetails, strFilePathFull_AllocationDetails, Nothing) And my function: Public Function DataTableToFile(ByVal si As SessionInfo, ByVal dt As DataTable, ByVal strFilePath As String, ByVal listColToSkip As List(Of String), ByVal Optional strSeparator As String = ",") As XFFileEx Dim strDt As String = Me.PrintDataTable(si, dt, strSeparator, 0, False, listColToSkip, """") Dim bytes() As Byte = System.Text.Encoding.UTF8.GetBytes(strDt) Dim fileinfo As New

Hi All,I am trying to run a business rule through Data Management step but getting attached error. Can anybody help me how to run the business rule from Data Management?I am also disclosing the error message belowError processing Data Management Step 'Data_Buffer_Practice'. User 'Muhammad Zubair' is not a member of the 'Actual' scenario's Manage Data Group. 

Hi,I have a Custom Calc rule called by a data management step and I am experiencing a weird behaviour. I know there is data in Actual 2023M6, and I can get that data when running the data management step from either Actual 2023M12 or MF7 (name of another scenario) 2023M6, changing the GetDataBufferUsingFormula appropriately, but not from MF7 2023M12. I'll post the details below. 

Dear community. I have a use case where I need to sul up data from 2 different entities and apply a ratio on it. For this, I would like to use a data buffer. However, the data buffer typically only run on a data unit hence 1 entity at a time. So I created a data management job dat would run on these 2 entites, and I wanted to use a Globals object along with this data buffer so that I could store data from these 2 entities into a single data buffer. However, I'm not sure if it's the right way to do it ? Is there a way for a data buffer to take data from 2 entities ? Or, if I use a globals object with a data management sequence, is the Globals object persisting when running on 2 different entities ? Many thanks for your anticipated feedbacks ! Regards,

I need to add a Form Channel (Workspace) to our WF's for informational purposes.  Is there a way to exclude this from from the Dependent Status check of the WF for certification purposes.  The channel is defined as a workspace so we can embed a SQL grid report.  I already have similar channels where I have added buttons that control certification/decertification, this just requires the user to select the channel and then click the button.  Trying to get around forcing them to have to select when they might not need to view the provided data.   Understand I could move to a Dashboard but want to keep it in the WF and visible to users. 

When i tried copying the data from one cube to another cube using Eval function with Buffer [Calculate(formula, onEvalDataBuffer, userState)], the data got copied at the base level but as soon as i consolidated it, the data got cleared from the same destination intersections.On checking the cell status of the destination cell (intersection), i found that the storage type is Calculation Whereas, if we use api.Data.Calculate(formula, isDurableCalculatedData), the storage type is DurableCalculation, and consolidation works fine after using this Calculate function.We do we have a boolean parameter to set the DurableCalc as True or False in the api.Data.Calculate(formula, isDurableCalculatedData) function, but i didn't see any such parameter or setting for Buffers [Calculate(formula, onEvalDataBuffer, userState)].How can i make the StorageType as Calculation to DurableCalculation for Buffers, so that the values doesn't disappear after consolidation ?   

Hello,Is it possible on the same quickview to cross both Time and Scenario Filter?For example I need the cross of  :Time "2022" with scenario "ESTIMATE"Time "2023" with scenario "Planning_2023M10"But I have some datas on 2023 cross ESTIMATE I don't want to see.Attached what I have and what I need.Thank you! 

Hi All,I am trying to extract data from cube view using FdxExecuteCubeView function and load the result back to cube through a connector. However, when I execute the workflow dataload, a "No valid DataKeys (Scenario / Time)" error occurred. I checked the log, it pointed out to be "Non-Numeric Amount ..................... 4" error On the log, I am able to see the data I extracted as this :4: Cube1, 568123, , Local, Budget, 2023, Periodic, 702151, None, BeforeAdj, None, 500100, None, None, None, None, None, None, None, 959.799999996It seems that the data was pulled right, but just the amount cannot be recognized as numeric dataOn Data Source, I did map "Amount" to the "Amount" column. I am not sure why 959.799999996 is not considered as an amount? Here is the mapping.   Here is the Rule itself. Case Is = ConnectorActionTypes.GetFieldList'Return Field Name ListDim timeMemfilter As String = "T#2023"Dim isTimePivot As Boolean = FalseDim useGenericTimeColNames A

Has anyone switched External Authentication from AzureSSO to OktaSSO?  How did that process go?  Was it seamless or were there user login issues? I'm trying to get ahead of this as my company is looking to convert all logins to OktaSSO.

Hi All,I  want to get Last month ending balance in my MTD column of cash flow and last year ending balance in my YTD column of cash flow as you can see in above picture.Can anybody share with me the business rule? I have tried following business rule but it is capturing only at the end of the year balance.Dim currView As ViewMember = ViewMember.GetItem(api.Pov.View.MemberPk.MemberId) 'Current view member IDDim priorQtr As Integer = api.Time.GetLastPeriodInPriorQuarter(api.Pov.Time.MemberId) 'Prior QTR member IDDim priorQtrName As String = api.Time.GetNameFromId(priorQtr) 'Prior QTR name #End Region ' Bring in Beginning Cash and Ending Cash to the Cashflow hierarchy in FlowIf currView.Name = "YTD" Thenapi.data.calculate("F#CF_BegCash" & Target & " = RemoveZeros(F#EndBal:T#PovPriorYearM12" & Source &")","A#CashTot.Base")Else If currView.Name = "Periodic" Thenapi.data.calculate("F#CF_BegCash" & Target & " = RemoveZeros(F#EndBal:T#PovPrior1" & Sou