OneStream Platform Forums

Hi Folks,I am trying to make sense of an intercompany plug account balance that is consolidating itself to the top of the entity hierarchy. Technically using the default (out of box) consolidation that OneStream offers ; this shouldn’t be happening and the plug account should be zero. can someone point me to why there is a plug account balance at the first common parent level ? Shouldn’t this completely eliminate itself and plug account should be zero: Intercompany transactions between company X and Y, both I/C entities and Account 3200/3100 are also i/c True accounts with the same plug account present in metadata balance sitting in the plug account when viewed by company Y and then at the common parent level for both entities.my conundrum is why PLUG account is carrying this balance ,when it should have been completely eliminated at the 1st common parent. Does anyone know why this could be happening?

Hello - I have an account member formula that is compiling successfully and OS is also consolidating without errors, but is not calculating any data. I’m looking to calculate the sum of net income for a specific entity for all years starting with 2023 (the first year we have data in this application), plus a specific dollar amount. Its basically is supposed to be retained earnings for this OneStream specific entity - there’s no data from our ERP for it. Below is the member formula I have now - any help is very much appreciated! 1. Explicitly filter for Entity MyEntity, Scenario Actual and UD1 IFRSIf api.Pov.Entity.Name.XFEqualsIgnoreCase("MyEntity") And   api.Pov.Scenario.Name.XFEqualsIgnoreCase("Actual") And   api.Pov.UD1.Name.XFEqualsIgnoreCase("IFRS") Then' 3. Determine the prior year boundaries based on the current POV    Dim currentYear As Integer = api.Time.GetYearFromId(api.Pov.Time.MemberId)    Dim priorYear As Integer = currentYear - 1    Dim startYear As Integer = 2023       

Dear Community, When I export cube view in Excel, I get two additional rows on the top, is it possible to remove them? 

Hi All,We are using a spreadsheet component to capture some drivers from end users in our application, how do we customize the ribbon of the spreadsheet component to show only OneStream option in the ribbon?If I do right click, "Customize ribbon", it lets me display only OneStream in the ribbon , but the customization is lost on refreshing the page. Any guidance on how to retain this customization would be helpful.   

Hi All, I'm having a hard time running a book that creates a pdf by entity in an automated fashion.  I've created a book with a loop calling a file which is a book of cube views.  Running that book individually works well.  When running the book that contains the loop, it works fine when saved as a .pdfbook but the problem I run into is that it times out due to processing time when I try to run it for multiple entities.  The book is about 80 pages or cube views.  So I created a .zipbook version of the same book with said loop to run it from Data Management in the background.  The problem I'm now running into is running the .zipbook version creates 80 pages of blank reports rather than the data I saw in the .pdfbook.  If anyone has any suggestions, I'll take them.  Thanks!  

Hi OneStream Community,We are evaluating integration architecture patterns for a OneStream implementation involving a mix of SAP and non-SAP source systems. I would appreciate insights from others who have implemented similar architectures.At a high level, we are considering the following patterns: Direct Integration SAP and non-SAP source systems integrate directly with OneStream using the appropriate supported integration mechanisms. SAP BDC-Centric SAP Business Data Cloud serves as the primary governed data layer, with SAP and potentially non-SAP data prepared and exposed to OneStream. Data Lake / Databricks-Centric SAP and non-SAP data are consolidated and governed through an enterprise data platform such as Databricks, with OneStream consuming the curated datasets. Hybrid: SAP BDC + Data Lake / Databricks SAP data is managed through SAP BDC, while non-SAP data is managed through the enterprise data platform, with both supplying the required data to OneStream. One of the key

Hello EveryoneWe are noticing an issue where users are unable to drilldown on OneStream. It is inconsistent and only impacts certain users. When they use the drilldown function - It shows the wrong account. 

We recently upgraded from V7.4 to V9.1 and we’re seeing an issue with the Excel Add-In. A small group of users (about five) are unable to use the Drilldown feature (the option is completely greyed out), while the rest of our users can access it without any issues. All users have been upgraded to the 9.1 Excel Add-In and every other function appears to be working correctly. Has anyone else run into this? Any ideas on how to fix it?

Hi,Does “ods connect” has non interactive login option?  Thanks.

Hi OneStream Community,I’m relatively new to fixed-width data sources and have a couple of questions.The client has three fixed-width files that will be used as Transaction Matching data sources. Is there a way to bypass all headers, footers, blank rows, and other non-transaction rows using a single bypass rule or expression, instead of creating multiple individual bypass rules? What is the recommended way to import credit amounts as negative values? This is a one-sided match. The Amount field is displaying correctly as an absolute value of either the debit or credit amount, and the Debit field is also displaying correctly. However, the Credit field in the data set is always showing 0.Any guidance on the fixed-width field configuration or where the credit sign logic should be applied would be greatly appreciated.Thank you!

Dear all I have written some formulas to accounts which vary by scenario and time however want to be able to copy these formulas to different time periods on mass - without having to go into each formula constricted by time period and copying across to a different OS application (dev to prod e.g.) - using the copy paste format.Is there an optimum recommendations that I can get around this? 

Currently, users must upload supporting documentation one by one as R docs within account reconciliations. Because our typical reconciliations require multiple supporting files that must be updated regularly, this single-file constraint adds a significant manual burden and extends our month-end close timeline. Is it possible to upload multiple items somehow?

Hello Fellow OneStreamers, Please bear with the long post. I have the following workflow profile structure that contains Level 2 data unit overlap I am trying to change based on a financial planning requirement. The requirement comes in when an analyst reconfigures an hourly labor position in one of the assumption forms. A clear, retransform, load, and seed process should occur to align loaded data with the new configuration that will be used throughout the planning process for a particular position. The current workflow structure is a hinderance here because kicking off this process for a particular position retransforms and loads all entities which is much more data than needed. It also contains Level 2 data unit overlap because the same data unit is currently being loaded for the specified accounts within the current workflow profile structure. Our Current Production State: Base Input Workflow Structure Current State: Import Labor Data (Base Input Workflow Profile Step) Import Act

The Data Cell is read-only because the Parent Workflow Profile 'FR Food HR' has no active Input Profiles for the Workflow Channels that are assigned to the Data Cell's Account and/or UD member. Entity=entityname, Account=Accountname, Origin=Forms.  

Hi Everyone.I want to delete the existing data using a BR before loading the new values through Export to Cube. I tried this approach, but the newly loaded data gets deleted.I also modified my DataQualityEventHandler BR to run before the event, but the newly loaded data still gets deleted.Public Function Main(ByVal si As SessionInfo, ByVal globals As BRGlobals, ByVal api As Object, ByVal args As DataQualityEventHandlerArgs) As Object Try 'Define a switch to control event processing, since many of these are reference examples we do not want them to run all the time Dim processEvents As Boolean = True 'Set the default return values Dim returnValue As Object = args.DefaultReturnValue args.UseReturnValueFromBusinessRule = False args.Cancel = False 'Evaluate the operation type in order to determine which subroutine to process Select Case args.OperationName Case Is = BREventOperationType.DataQuality.ProcessCube.NoCalculate 'Execute a Data Management job aft

Hi OneStream We are aiming to assign responsibility for salary updates at the cost center level. To support this, we have built a base workflow with a separate step for each cost center, this step will have a workspace (contains workforce planning), import to load processes, enabling users to work on and sign off on one cost center at a time. This works well when a user has access to only a single cost center.  When the finance user ( who has access to all cost centers accesses one of the cost center workflows, the data for All cost centers is brought in and attempted to be processed within that cost center workflow.  The filtering for the register and processing of data is not controlled by the workflow, but by the user only. This means it is not possible to update and process one cost center at a time if the user has access to more than one cost center, as it is centralized. In the new workforce planning solution most logic is encrypted, so we cannot go and review the code for proces

We have our UD1 parents tagged with one base UD1 in Text8. For each UD1 parent in a cube view row, we need to have a column which has the base UD1 at POV to allow user inputs. Tried XFBR, UD8, Get Data Cell and Member List function.  The tricky part is the |MFUD1| can never reach any external functions, and UD8 can not post it back to the intersection in overrides.Thanks in advance!

Curious how in general people are handling ASC220 - Disaggregation of the Income Statement.  Alternate hierarchies or filtering on an Account Text1-4 field is my two options I think.  Or is it something you’ll do semi offline pulling OneStream data into a report or Excel?  I’m sure it depends in some cases how your hierarchies and data is, but I just wanted to see if there was something people are doing that I haven’t considered.

Hello, I have multiple excel files using XFGetCell to pull data from OS.  What I would like to do is, (1) create a report book that includes the XFGetCell formulas to refresh data when the report is ran, (2) Set up a DM/Parcel Service to automate sending the file to both OS and non-OS users.  Is there a way to do this?  I do not want to re-create these files as cube views because they are customized for our reporting requirements and have some intricate calculations.Thanks,Tyesha

OS Community,I’ve tried unsuccessfully to find the answer elsewhere.  Please help me understand this if you’re able.Scenario:  In one of our applications, I know that only business rule A and business rule B have been edited today.  One by User A and one by User B.  In the Application Reports dashboard, when I run the updated business rules audit report for today’s date (with all other filters left to default values), only the two expected rules are reported.  However, in the report rule A has a checkmark in the column titled “Business Rule Updated”, while rule B does not.  I happen to know that rule A with a checkmark was edited, saved, and compiled, but I know nothing about the change made to rule B other than “something” was updated.Question:  Precisely what is indicated by the presence (or lack of) a checkmark in the “Business Rule Updated” column of the updated business rules audit report?  Is it perhaps related to the act of saving and/or compiling the rule which has been updated

We have noticed that our application space is increasing significantly month over month. After analyzing the issue, we determined that the primary driver is the upload of supporting documentation within the Account Reconciliation module.It is currently difficult to identify which files are consuming the most storage and the specific accounts to which they are attached. Having greater visibility into file sizes and associated accounts would help us better manage the volume of supporting documents being loaded into the system.Additionally, could you advise on the recommended file types for attachments that provide good document quality while minimizing storage consumption? Understanding which file formats typically have the smallest file sizes would help us establish guidelines and optimize storage utilization within the application.

Hi Team,We're seeing user-entered annotations cleared during the workflow load process, while the associated data is preserved.SetupOur import process loads data and annotations for one set of accounts/sub-accounts. A separate set of accounts/sub-accounts is entered manually by users through Forms, CubeViews, or QuickViews. We have confirmed that the annotations from the import and the annotations entered by users are stored under the same Origin member (O#Import). They differ only by UD1 (SSSS1 vs. SSSS2).Sample intersectionsImport-loaded annotation:E#EEEE:S#FW:T#2027M12:C#Local:V#Annotation:A#AAAAA:F#PL_Load:I#0000:O#Import:U1#SSSS1:U2#DDD:U3#LID_001:U4#Form_Input:U5#None:U6#None:U7#None:U8#NoneUser-entered annotation (Forms):E#EEEE:S#FW:T#2027M12:C#Local:V#Annotation:A#AAAAA:F#PL_Load:I#0000:O#Import:U1#SSSS2:U2#DDD:U3#LID_001:U4#Form_Input:U5#None:U6#None:U7#None:U8#NoneTimelineSep 28: Ran Import, Validate, and Load. Data and annotations exist for SSSS1. Sep 29: A user entered data

Has anyone used a business rule to create either a sound notification or email notification for tasks you’re waiting to finish running in task activity? When force consolidating, I often find myself working in other applications and constantly having to go back to OS to see if the consolidation has finished running. It would be nice to be able to set a sound notification once its complete or receive a quick email saying your task has completed.

Hi everyone,I'd like to set up a specific account as read-only for all users, except for one group that should keep write access. I haven't done this before, but I'm thinking Data Cell Access Security might be the way to go.Has anyone got a simple example of something similar set up in Data Cell Access Security? Also, open to suggestions if you think there's a better approach!

I am in the process of implementing ARM as a replacement for a 3rd party account reconciliation tool.  We currently complete account recs at a company code level (ie: U.S. & Mexico); however, the current configuration in ARM defaults to the base entity level.Company Code: “1000 - US”  »  Base Entities: “100, 110, 120, 130, etc” (There are aprox 30 entities that make up our US company code.Company Code: “2000 - Mexico” » Base Entities: “200, 210, 220, 230, etc” (There are apox 10 entities that make up our MEX company code.For any given GL account (ie. Other Current Assets) there are values loaded to multiple base entities.  Is it possible to complete the account rec at the summary US and Mexico levels rather than needing to reconcile many individual base entity balances?