OneStream Platform Forums

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!  

Hi, has anyone figured out how to add files to Narrative Reporting. In the Admin area I have blanks in the Source File Name column for my documents. I cannot seem to figure out how to add word docs and cube views into the fields. Ideally, I would want the package to populate out a cover page which would be summary of MTD and YTD results followed by a page for both results in Income Statement format with a variance explanation page last. Thanks for any help in advance

Hi I have a form and there is a balance sheet account, total input and validation columns. The condition is to check if the balance sheet account value has a value and total input has no value, if balance sheet account is 0 and total input has a value and total input is greater than balance sheet then validation should be 0. If balance sheet is greater  then total input then validation is 1. This validation is stored in a member formula and I was wondering how can I get the validation column to show 1 or 0 based on the conditionI have tried the SetDataCell() first but found out that on a member formula that does not work, which other function can be used. Your assistance will be greatly appreciatedRegards 

We have created a set of confirmation rules for our forms. However, there is a company that is failing the rule because of an adjustment that must be made by recommendation of the auditors but would not otherwise be accepted. Is there a way to exclude just this company from the rule?

Hey All,We got a recent requirement of implementing a conditional statement inside the cube view columns. The user wants to calculate a certain column on the basis of the value of another column. The design is explained below:If B <> 0 thenD= B+Celse if B = 0 thenD= A+CABCD1010020120 (100+20)200130150 (20+130)0203050 (20+30)I'm currently facing difficulty to implement this solution inside the cube view. My first shot was trying something in the XFBR string but that I couldn't get around the logic to implement the same.Any leads will be appreciated. Thanks!Pragyanshu BansalJackLacava OSAdmin 

Hello OneStream community,  Since we've updated to PV710-SV202, the export of inventory list only has GroupID, which is less user friendly compare to GroupName. Has any one get any luck with getting GroupName included in the export?  Thanks! 

Is there a way to drill through the entity hierarchy in a Quickview that shows the total of Top in the Consolidation dimension? I have users asking me if this is possible.   In the example above 87M is the total amount of the child entities including eliminations showing in the second Quickview but no total. The first Quickview is at local before eliminations therefore doesn't addup to the total of 87M. I've tried to use CAD but get the same numbers as local.    

Hi I have two source accounts bringing in same amounts for multiple Entities. Some of the entities are local and some overseas. The only unique identifier is Text7 field in the entities. How can I map the source accounts to OS accounts using Entity Text Field 7. Below is the example Acc 1000 - $7000 E#AUS Acc 2000 - $7000 E#AUS Acc 1000 - $9000 E#NZ Acc 2000 - $9000 E#NZ In the above example Amount $7000 belongs to local Entity so should be mapped to A#Local_Tax and Amount $9000 belongs to overseas Entity so should be mapped to A#Overseas_Tax. The problem is in the import file the amounts 7k and 9K sit in both local accounts Acc 1000 and Acc 2000. The only unique identifier is the Text 7 value in the Entity. Please advise if I can use this text value in Composite Transformation rule or if I need a complex business rule. Any suggestions are welcome,  Thanks Sam

Looking into a way to turn off translation for specific entities, yet only for the budget scenario and select gain/loss accounts. Having translation on for Other Expense and Net Income as it relates to budgeting is skewing the EBIT bottom line. Is turning translation on a budget scenario and specific Entities possible? Thanks in advance, 

All,  We currently have a combo box (with entities) in a dashboard but we would like to make this list a bit smaller and based on the security rights a users has. I want to solve this with a XFBR which i afterwards attach to a parameter and that parameter in a combo box. Does somebody has an example of this XFBR code which i can look into? Or is there a better way to do this.   Thanks

Hello - I have a cube view that's linked to another to show detail. I have bound parameters set on the time, view and account dimensions. These parameters are all working properly except for the calculated column I have in the main/parent CV - its a column that has a GetDataCell expression. When I right click and select "Navigate to Entity Drill" on a cell in this column, the account and view members are still correct, however the time period its passing through to the linked CV is incorrect. The time member it passes through to the linked CV is the period of the first column in the main CV. So for example, the time period of the first column is 2024M4 while the period for the GetDataCell column is 2024M8 - the linked CV will show 2024M4 even though the Cell POV shows 2024M8. How can I send the correct time period to the linked CV on this GetDataCell column?

Hi, All, I am planning to generate the report for users who are active/inactive, last login date? I am reviewing the Framework audit tables however I couldn't find exact fields. Can you please let me know ? thank you

If a POV has more than one dynamic calc member (for example Account and UD8) does anyone know the sequance they are calculated in?  I assume, and it appears from a little testing I have done, that it is similar to how it works in DUCS and it goes Account, Flow, UD1, etc but looking to confirm.  Thanks.

Hello, I am creating a dashboard with a grid view and gridview is binded to a Data Adapter which calls a business rule to get data thru an external web-api call. Now I have to show data in Gridview and the record count on the dashboard on a button click. I have used following settings on the button. The Selection changed server task is happening first and then the data load is happening, so I am able to update the literal parameters with counts after data load but they are not reflecting on the dash board. Any help appreciated.

Hello Team  I am currently using the "FDXExportDataUnit" function to load data into a DataTable using the following code: Dim dt As DataTable = BRApi.Import.Data.FdxExecuteDataUnit(si,"FPA_CM","E#Entity_top.base","USD",scenarioTID,Scenario,timefilter,"MTD",True,"Amount <> 0 And Flow='EB'",16,False)   he resulting DataTable contains 678,123 records. I plan to insert these records into a Snowflake database. To speed up the inserts, I am dividing the DataTable into multiple DataTables of 150,000 records each. However, the inserts are currently happening sequentially, and I want to run them in parallel. I am considering the following options: Pass the split DataTable as a parameter to a Data Management sequence:This would allow me to call the sequence using "QueueDataManagementSequence" so the process runs on different servers. I need assistance on how to pass the DataTable as a parameter to the sequence. Run bulk insert SQL statements in parallel using threading tasks:

I have a csv file that has two columns one for Debits and the other for Credits columns E and F (5 and 6).  I'm using the code to take the Debit column if there is a number in Col E use it, if zero, take number from Col F instead. In the Data Sources settings in order for the script to work properly I need zero suppression to be False or it won't pick up the credit column. Note in the script that integer = 5 is referring to column 6. Is there a way to suppress zero after the script runs or write zero suppress into the script?  Thanks Scott