OneStream Platform Forums

Hello Experts, Is there a way to update 500+ member names in OneStream using XML file. Manually changing each member is time consuming there seems to be no functionality available with XML load?Thank You,Manoj   

hi all, I hope you are doing well. I've a cube view with 2 columns and need to add another dimension, is his a bug to have only 2 dimensions? Thanks in advance. Regards Mario Guerrero

Hi Team,I am wondering is that posible to export Error Logs or Task Activity with business rule? I know we can extract data from cubes or dimensions using BRApi methods, but is there a similar approach that allows us to export Error Logs or Task Activity? If so, what methods or steps are needed to achieve this?

Looking for some sample code to help me get started with adding in a new row through the SQL Table Editor, where a few of the columns are prepopulated on row addition through Dashboard Extender BR Code

Can we adjust the Workflow POV settings in the OneStream Excel Add-in? It would be great if the "OnePlace" tab could also be displayed. Many of our users are more familiar with the Excel add-in, so implementing this change in the next build would be beneficial. This way, they wouldn't need to access the application to modify these settings during the close process.

Is there a way to disable the "Force Consolidate" option from the forms? 

Hey all, So i'm trying to solve the display name of a view member in a cubeview column. I manage to change the display name by using Delimited List by changeing display name in parameter dropdown to "TTD" in this case. However the membername in the cubeview column is still the original membername in the dimension (Trailing4Months). I tried Member List as shown on prontscreen below. I did also try the condition rules in the cubeview but did not find any returning input of display name. I think I could solve this with XFBR but wanted to check here first to see if there are any "Built in" solution to handle this? Thanks in advance     

I'm curious about these four finance function types and whether anyone has worked on them: CalcDrillDownMemberFormula ConfirmationRule DynamicCalcAccount ReadSourceDataRecords If someone has worked on these, how do we call and use them? Any insights?

Hi Team,I need to parameterize my Cubeview where I need to sum two flow member data and show it in my Cubeview , For which i need to write a rule in that rule I have to create a temporary variable member (Total) which doesn't exist in our flow hierarchy which will contain sum of our flow member (RFX_Input + UFX_Input) data, and this Total variable member we have to parameterize and so that when Cubeview runs it'll show me the total value of (RFX_input + UFX_input) into my Cubeview. Please help me to guide how to write this rule logic. We have tried creating it as a parameter with getcelldata but the cubeview does not render and timesout.  

I'm having trouble getting my data files to import into the correct quarter of the workflow. Whenever I load the data into the Q2 import of the workflow, it removes the Q1 data and adds the Q2 data to the Q1 import of the workflow. (screenshot attached)  I am having a hard time finding the correct settings to allow me to load the quarterly data files into each quarter of the workflow. Any assistance would be greatly appreciated. Thanks!  

Hi, I have a requirement where I need to compare a member in list of members (listOfmem) and see if the member exists in list. How to best handle this as it seems like I can't use "Contains" function?  Dim listOfmem As list(Of memberinfo) = BRApi.Finance.Members.GetMembersUsingFilter(si, U2DimPk, U2DimMem, True)   Thank you in advance, Mikki

I want to create a yearly LTP scenario of type (scenario1) where input frequency is yearly and data can be input for like below I want to restrict this scenario for data input for particular years like, FY26-FY36. (with 1 entry a year) What setting can I do- to make this scenario available for input only for 10 years.  

Does anyone have experience leveraging GitHub or any other code version control tool to manage Business Rules with OneStream? Assuming we have a remote Git repository on GitHub that keep track of all of our business rules. How do we push the code from remote repository to OneStream? Or in other words how do we run git command to push/pull. In this context, we want to assume there is file system on cloud store all the business rules in file format.  If there is no file system on OneStream, how are the Business Rules managed on cloud? Any pointers will be appreciated. We found a way to update the Business Rule table: xml_data in Application Database. But we are seeking for better options.    

I feel like an idiot asking this question but I can't find anything on google. Where do all of the 'Helper' classes come from? TimeDimHelper, StringHelper, ApplicationZipFileHelper, ScenarioDimHelper  Are these all OneStream specific? Is there any documentation or good posts about their use? Thanks, Scott  

Is there a way to restrict Access to Business Rules for all Users including Administrators through Security Groups? I don't want to encrypt the Business rule.

Hello, First time posting question here. I'm a developer new to the OneStream.   I'm trying to run a remote business rule to pull a file that stored on Local Gateway Server. The idea is to have the content of the data file returned to OS in bytes[].  I have extender rule  and SIC Function rule. After I executed the Extender rule, I printed out a few things from the returned object and looks like there is an exception when executing the remote rule. Could anyone give any pointers? Any help is appreciated!    Error Returned BRApi.ErrorLog.LogMessage(si,objRemoteRequestResultDto.RemoteException.StackTrace) ' Returned -> ' at OneStream.Shared.Wcf.RelayHostInfo.InvokeRequest(IRemoteRequestBase xfRequest) ' at OneStream.Shared.Wcf.OneStreamRelayAgent.SendRelayRequest(IRemoteRequestBase xfRequest) BRApi.ErrorLog.LogMessage(si,objRemoteRequestResultDto.RemoteException.GetBaseException.Message) ' Returned -> ' DirectConnection BRApi.ErrorLog.LogMessage

Hello Everybody,Could you please help to get a solution how to complete all WF forms at once for all descendants. We already got the extensibility rule for this purpose but it's completing all WF steps except forms. The function for form exists (brapi.Forms.Process.ExecuteCompleteForm(si, formPk)), but we are having trouble retrieving the formPk...Would be highly grateful if someone can share an idea how to solve this.Best Regards,Svetlana  

Hello,Would you know how I can access all Business Rule functions/ syntax etc in a file or where they are stored in OneStream? Basically, I want to have a list of all functions/ syntax.Thanks,Sid

Anyway to display text value in Cubeview without creating UD8 member.I was able to filter using text in row but I want to display what does it mean to make it more presentable.    

I am trying to copy the data from the Adjustment data. api.Data.Calculate("F#EndBalJE:O#AdjInput = RemoveZeros(F#EndBal:O#AdjInput:T#PovPrior1)","A#BS.Base")As per My rule the data will be copied for C#members that does not require parent to be specified.Example : C#Local and C#Share Is there any way I can copy the data at C#OwnerPostAdj Data As well using api.data.CalculateWhat changes I need to make in above code . ?Regards,Nik

Hello, I currently have a dynamic formula that pulls the max value, but was asked to use that formula to get the absolute value that is also a negative the highest amount to pull that value as well instead of being 0.  Here is the current formula I'm using Dim dAmount_1 As Decimal = api.Data.GetDataCell("T#Pov:U8#None").CellAmount Dim dAmount_2 As Decimal = api.Data.GetDataCell("T#PovPrior1:U8#None").CellAmount Dim dAmount_3 As Decimal = api.Data.GetDataCell("T#PovPrior2:U8#None").CellAmount Dim dAmount_4 As Decimal = api.Data.GetDataCell("T#PovPrior3:U8#None").CellAmount Dim dAmount_5 As Decimal = api.Data.GetDataCell("T#PovPrior4:U8#None").CellAmount Dim dAmount_6 As Decimal = api.Data.GetDataCell("T#PovPrior5:U8#None").CellAmount Dim dAmount_7 As Decimal = api.Data.GetDataCell("T#PovPrior6:U8#None").CellAmount Dim dAmount_8 As Decimal = api.Data.GetDataCell("T#PovPrior7:U8#None").CellAmount Dim dAmount_9 As Decimal = api.Data.GetDataCell("T#PovPrior8:U8#None").CellAmount Dim dA

Hi,  I have been working on creating reports for some time and after trying different options I have some questions: Mainly: how are the reports created by default? How did you solve (usually) the problem of the comments?  I had originally planned to work with Books but they have (IMHO) limitations in the format or the comments are not displayed well, so I have ended up in Excel where the CVs are retrieved and commented. However, I have many reports that often only change in the query (MTD, YTD, segments) and I would have to create a CV for each report (I have also done this but it is getting confusing, therefore I would need to save some of them). How should I most efficiently create reports where I explain deviations in the products, deviations in the P&L at monthly and annual level (and this for several UNITS) and deviations in the balance sheet? BTW What is the best way to upload the comments in Onestream from Excel? Is there a good PDF manual with all of this informa

Hello OneStream community,I'm working on a data import process where our source file contains Entity codes with hyphens (e.g., "ENT-BER"), but in our OneStream application, these codes use underscores instead (e.g., "ENT_BER").I'm looking for an efficient way to automatically transform these Entity codes during the import process without having to create individual mappings for each entity.Where in the OneStream configuration should I add this transformation rule? In the Data Source settings, Transformation Rules, or somewhere else?Any guidance or examples would be greatly appreciated. Thank you in advance for your help! 

Hello,  I need to extract all the UD1 Default values and am stuck on statements 3 and 4 in the example below.   Example using cost center 1100: Dim strUD1Member As String = "1100" 1-Dim UD1Member As Member = BRApi.Finance.Members.GetMember(si, dimtypeId.UD1, strUD1Member)2-Dim UD1MemberInfo As MemberInfo = BRApi.Finance.Members.GetMemberInfo(si, DimTypeid.UD1, UD1Member.Name, True) 3-Dim UD1Properties As UDVMProperties = UD1MemberInfo.GetUDProperties()  ? 4- ? I appreciate any help you can give me. Thanks!    

My client has member property Text1 in UD1 as a second description or alias, he wants to display Text1 instead of name or description. I tried with CV Function "u1#top.descendants.where(Text1 <> '')", but It is not working because keep appearing name or description. Any recommendation with function CV or XFBR please? Thanks.