OneStream Platform Forums

Hi Everyone,When trying to access the Spreadsheet section in our application, we were met with this error message that we did not recognize. We were unable to open the Spreadsheet section because of this unless we opened the application in a new window. Has anyone seen this error message before or know what the root cause for it was? 

Originally posted by Michael Malandra 1/23/2018 Security Question - can we block users from submitting data in excel? We want to prevent a user from submitting planning data on certain UD members

Hi - The below if condition is not working if the cube is multi cube, it works with Single cube? Any Idea why  If api.Entity.OwnershipType().ToString.XFEqualsIgnoreCase("Holding") Then

Hello everyone,I’m working with a flat entity hierarchy and need some help.I have entities like FRA1, FRA2, GBR1, and GBR2. In a cube view, dashboard and/or spreadsheet, I would like to aggregate the amounts by region, such as FRA (summing FRA1 & FRA2) and GBR (summing GBR1 & GBR2). However, I would like to achieve this without creating a new hierarchy.Below is a representation of my goal:Do you know of any ways to proceed with this?Thanks in advance for any help or suggestion!

Hi Everyone. I would like to know how I can perform a setdatacell on an entity that is not in my Data Management configuration. I obtain the value of the entity from Text 1 of my entity assigned to the POV, but it does not allow me to apply a setdatacell or a calculate to assign a new value to that entity. Therefore, I would like to know how I can achieve this. My Data management configuration: The example code I am using: Dim strEntity As String = api.Pov.Entity.Name Dim strScenario As String = api.Pov.Scenario.Name Dim strTime As String = api.Pov.Time.Name Dim povEntityId As Integer = api.Pov.Entity.MemberId Dim strEntTx1 As String = api.Entity.Text(povEntityId, 1) 'setdatacell api.Data.SetDataCell("S#[" & strScenario & "]:T#" & strTime & ":E#" & strEntTx1 & ":A#S_ConvFactorInner:O#BeforeAdj:U1#D0000:U2#P0000:U3#LOCAL_DATA:U4#PJ00000:U5#None:U6#None:U7#None:U8#None",totAll,False,True) 'Data.Calculate api.Data.Calculate("Cb#HLFPLN:S#[" & strScenario &am

I am trying to calculate months to date in a cube view column based on a date entered in a text field within Entity Dimension members. The text field would display in one of the columns on the cube view report, and the goal is to effectively subtract the current month from that date's month to derive a total months to date calculation in another column. Any thoughts on how I can do this? 

Hello, I have this strange situation where information was entered with form input and for 1 of the entities the data disappeared on several accounts. This is in a scenario type1 scenario.  When information is entered again the old values can be found with Audit history for Forms from the drilldown. Any idea how this can happen, I would expect it only after a reset scenario, but that would remove also data for other entities, could also be by removing the entries, but there are several different forms, so that seems unlikely. kind regards Ben 

Hey Guys,I was writing a rule to update a member description and text 1 field of the same member. I was able to update the member description, but can anyone help me with the text 1 field?Please find the code below which I am using to update the description..Dim SelectUD4 As String = args.NameValuePairs.XFGetValue("Param1")Dim NewDescriptionUD4 As String = args.NameValuePairs.XFGetValue("Param2")Dim UD4TextField As String = args.NameValuePairs.XFGetValue("Param3")  BRApi.ErrorLog.LogMessage(si,UD4TextField) Dim member As Member = BRApi.Finance.Members.GetMember(Si,dimtype.UD4.Id,SelectUD4)If member Is Nothing Then Throw New Exception("Selected UD4 member not found")End IfDim newmember As New WritableMember(member)newmember.Description= NewDescriptionUD4newmemberbrapi.Finance.MemberAdmin.SaveMemberInfo(si, True, newmember, False, Nothing, False, Nothing, False)Any help would be appreciated.

After upgrading to v8, we seem to have lost the comma formatting that was there on the standard IC Matching Partner Detail report.   Is this something that I can change, and if so will I need to do this anytime there's an upgrade?  I can't find where this setting resides.    

Today, a customer asked me:  Where do stored calculations store data?  api.Data.Calculate If Statements  In stored calculations, If Statements are helpful to specify that a formula is only required to execute on specific Data Units, as shown in the image below.   If ((Not api.Entity.HasChildren()) And (api.Cons.IsLocalCurrencyForEntity())) contains two logical operators (And and Not). Due to the AND operator, the statement api.Data.Calculate("S#Forecast = S#Actual") between Then and End If will only run if both of the following are true: The Entity is a Base-level Entity Member, i.e.: does NOT have Children (Not api.Entity.HasChildren()) The Consolidation Member is Local indicating the Entity Member's local currency (api.Cons.IsLocalCurrencyForEntity()) The statement api.Data.Calculate("S#Forecast = S#Actual") will copy the S#Actual data buffer to the S#Forecast data buffer. The If...End If

I am unsuccessfully trying to write an expression to utilize a Text Field as a filter in a business rule:api.Data.Calculate("U4#Target = U4#Source*-1","A#IncomeStatement.Base",,,,,,"U3#UserDefined.Base.Where(Text1 = 'Filter')") Is this syntax possible, or is there another way that I can write this to ensure that it is only being written when Text Field 1 for UD3 is equal to "Filter?"Additionally, is it possible to attach this to a transformation rule as a complex expression as opposed to needing to run it through Data Management after loading data?

I'm trying to produce a report schedule for Miscellaneous Receivables to show the make up of the Account.  I'm looking at trying to use Cell Details if that will work, but didn't know if anyone had a better idea.  The setup is I have one Miscellaneous Receivables account and I want the users to enter the detail make up of that account.  The lines will change over time to different descriptions that can show up in dynamic report rows.  Like I said similar to cell details, but they don't seem that easy to use in a cubeview.

We are trying to temporarily disable the Write access on a scenario to Everyone during a long DM sequence. We were able to find the ManageDataGroup under Scenario Properties, however, we could not find anything for ReadWriteDataGroup, which is a XMLConstants based on the API reference. Any help appreciated!

Maybe I'm missing something easy, but I'm trying to get some rows to group in the Excel import, and I can't get it to work properly. I think the problem may be that the rows are GetDataCells, but I'm not sure. So my question is, will the ExcelOutlineLevel work for GetDataCells, or is it restricted to member trees?To illustrate visually, I'm trying to get a bunch of rows like this: To export into Excel grouped like this:

Hi community, Does anyone have a good member formula for calculating income/equity attributable to minority interest on the P&L and balance sheet? My understanding is in our case we can report this in a simple manner with just two additional accounts, one on the P&L and one on the balance sheet. In my mind the P&L account would work something like the following, if ownership type equals Non-Controlling Interest then multiply net income by (1 - percent ownership). I'm currently trying the below formula for the P&L account, but not yielding any results. After running a consolidation there is no data in the new account. Any suggestions on how to solve this? Thanks, Dim dValue As Decimal = api.Entity.PercentOwnership() Dim objOwnershipType As OwnershipType = api.Entity.OwnershipType() If objOwnershipType = "Non-Controlling Interest" Then api.Data.Calculate("A#NCI_Income:I#None:F#PL_LOAD:O#Import:U1#None:U2#None:U3#None:U4#None:U5#None:U6#None:U7#Data_Load:U8#None = A#NetI

Hello, I have a dynamic calc UD8 member, where I put small value grater then 0 (0.00001) to be able to display certain rown even when the initial value is 0. This works with FormulaPass, but does not seem to work with dynamic calc. Does anyone know if there could be a problem that dynamic calc values get supressed when all CV supressions are set to "True"? Thank you!

Hi! we are facing Corporate Sustainability Reporting Directive in Europe, and we need to report in XBRL format since the 1st jan 2026. we are looking for solutions on how to report in this format from Onestream. Is there some tool / connector you may know that can be applied? Do you have any recommendations on the architecture to do that? Thank you!

What is the correct syntax for the filter expression in the DataUnit method command used in BRAPi.Database.ExecuteMethodCommand()?We are trying to filter on Flow member EndBal.  The following syntax does not work:MethodQuery: {FinRpt}{CorpEntity}{}{}{ACTUAL}{2024M1}{YTD}{True}{F#EndBal} results in the follwoing error:The expression contains invalid date constant '#End_Inp'.MethodQuery: {FinRpt}{CorpEntity}{}{}{ACTUAL}{2024M1}{YTD}{True}{WHERE Flow LIKE '%EndBal%'} results in the follwoing error:Syntax error: Missing operand after 'Flow' operator.{WHERE Flow = 'EndBal'}, {WHERE Flow IS 'EndBal'}, and other variations all result in the same syntax error. 

Is there a way to see the current OS license that is installed?  We have recently had the number of user licences increased and now want to check that this has been applied, I'd hoped this would be in an obvious place like the environment or security but can't see anything that shows the current license (just being able to see the number of enabled users that the license allows would be a good start).

Dears,We have a requirement, where we need to write only into C#Elimination of  [Share of Profit from] A#NetIncome and Same to be written to A#Investment in Equity Account as a other side of entry for the Equity Account type of consolidation in OneStream [We do not need line by line consolidation for all other items/accounts]To achieve this, I setup a entity as follows:PCON = 0POWN = 50%Ownership Type = Equitywhen i put PCON as zero[0] and execute the consolidation, the results are not writing up to Elimination member. What  can be the reason for same?  

Is there a way to set the task manager to automatically read the calendar for the upcoming months? And assign the Work Days so the client don't need to have to load them manually in the system?

I'm unable to import from SAP, i have an error message Summary: Unable to execute Business Rule 'SAP_TB_ALL'. Cannot call classic RFC API. See help for details.Please put a recent 64-bit version of librfc32.dll in your System32 folder (typically C:\Windows\System32).See SAP note 413708. Please make sure you have installed Visual C++ 2005 SP1 ATL Security Update (x64). Unable to load DLL 'librfc32.dll': The specified module could not be found. (Exception from HRESULT: 0x8007007E) how to fix this issue?  

Has anyone had issue with OneStream after switching to Windows 11?

Hi all, I'm trying to build a CV with Entities on rows and Scenarios on columns that will show the status of the cell with the help of a Dynamic Calc. Here's the aspect of the CV (Scenario and UD8 on columns): TEST is my dynamic calc (also crossed with V#Annotation so it can display text). As you can see, I can write on U8#None and yet the dynamic calc returns READ. Here's my code: Dim sEntName As String = api.Pov.Entity.Name Dim sScnName As String = api.Pov.Scenario.Name Dim sStatus As String = Api.Data.GetDataCell("Cb#CORP:E#" & sEntName & ":C#Local:S#" & sScnName & ":T#2018M1:V#YTD:A#ADDUG:F#None:O#Forms:I#None:U1#None:U2#None:U3#None:U4#None:U5#None:U6#None:U7#None:U8#None").CellStatus.ToString brapi.ErrorLog.LogMessage(si,"sStatus = " & sEntName & " - " & sScnName & " - " & sStatus) If sStatus.XFContainsIgnoreCase("WriteAccess: False") Then Return "READ" Else Return "WRITE" End If Here's the POV of the first cell (on E#3002:S#Actual): Cb#CO

Hello We are trying to build a CV where we need two parameter selections by the user. The first parameter selection needs to be passed into the second parameter. The second parameter is configured as a bound list using Method Type as Business Rule, and the first parameter selection needs to be passed as an argument in the Method Query - but the BR is not able to resolve the parameter value and is only able to read it literally. Following configuration is for the second parameter The BR is reading t1 as "|!TestingPrompt1!|" and not the actual parameter value that was selected by the user. Any ideas on how to solve this are appreciated. Thanks!