OneStream Platform Forums

I have a column template an the final column the client would like to make comments.  This is the V#Annotation.  I am doing balance sheet planning and have in the rows a mix of V#Periodic for flows and V#YTD for the balances.  The views in the rows take precedence over the view in the column.  I need to use the Row Override in the comments column with the V#Annotation in my column template.  The problem is there is no way to easily define all possible row name in all my cube view forms.  I think there should be some absolute override for all rows.  Does this exist or is there another way to do this I don't know about?

Hi all  have you ever seen this error message? I am logged as administrator but when I try to import the journal from excel I receive this error message. "Security Access Error. Unable to create journal. Company X 2021M12_Investment Template Top_ACTUAL_TEST." Thanks for help, Marcello

I am writing a member formula/dynamic BR where i have to get 'YTD" like cumulative members but instead get it from month 7 onwards i.e. if i want to get cumulative data from month 7 onwards, i wrote a very rudimentary code to do this and it works but checking if we have something better. Please let me know if there is something better: If api.Pov.Cube.Name = "Ledger" Then If (api.Cons.IsCurrency()) Then Dim fiscalYearShort As Int16 = CInt(Left(api.Pov.Time.Name, 4)) Dim periodLabel As String = api.Pov.Time.Name Dim periodIdentifier As Integer = api.Pov.Time.MemberId Dim periodSequence As Integer = api.Time.GetPeriodNumFromId(periodIdentifier) Dim filterString As String = "V#Periodic:A#IncStmt:F#EndBal:O#Top:U1#TotCC:U2#TotRegion:U3#TotDept:U4#TotLevel:U5#Reporting" Dim dataCellResult As DataCell = api.Data.GetDataCell(filterString) Dim cumulativeAmount As Decimal = Nothing If fiscalYearShort < 2023 Then

Hi I'm trying to fit the Cube View contents to the width of the page. When I set "Auto Fit to Page Width" = "True" and "Auto Fit Number of Pages Wide" = "1", it increases the font size until the CV reaches the margins, instead of extending the rows with the line-item descriptions. Is there a workaround for this? Regards, Allison

Hello- I am looking to build a shared column template to use across a number of existing row templates. One Column needs a format override applied to all rows. Unfortunately, CV row sets that this needs to be applied to, have differing naming conventions, (not row1, row2 , etc) When defining the Row Range in the Row Override, is it possible to have enter value that will apply to all rows? regardless of the name? Regards

Hi Community, We are trying to set up Rest API call to execute Data Management (OneStream v8.1) call from external system (e.g. Postman) I followed the document for REST_API_Implementation_Guide.pdf and I am not able to configure the Bearer Token (we are using Okta as Single Sign-on).    This is not working,  I am wondering if something need to be done on the Okta beside the steps in the document;  

Hello, We upgrade our OS from 7.2.2 to V8.0.0. When compile all BR we found an error on a SAP Connector BR: 1) Error at line 92: 'CreateSAPConnection' is not a member of 'BRApiDatabase'  2) Warning at line 93: 'Function GetLiteralParameterValue(si As SessionInfo, isSystemLevel As Boolean, parameterName As String) As String' is obsolete: 'This is a temporary function used by Marketplace Solutions for backwards compatibility with old XF versions. Please change your code to use supported functionality.'."  We already copy dll files into the integration folder (sapnwrfc.dll and associated icudt50.dll, icuin50.dll, icuuc50.dll) and add on the Referenced Assemblies the "XF\ERPConnectStandard20.dll;XF\sapnwrfc.dll" Looking into the BRApi functions of 7.2.2 we have a "CreateSAPConnection" that is no longer available on this new version: Dim r3Conn As R3Connection =  BRApi.Database.CreateSAPConnection(si, "ConnectionName", True) Does anyone know which functions is replacing this

Good Day  I would like to know what could I possible check to ensure that a green cell turns to white so users can input data. I have checked the Accounts dimension on the row as well as the override dimension and the allowed input has been set to true. Further to that I have checked the UD dimensions on that cell and those are set to true as well. I have checked on the cube view and the modify data is set to true as well. Is there some other place I could see to resolve the issue?   Regards Rehaan

HI All,  I'm running into an issue when running a Finance Business Rule, essentially this rule creates a data buffer and loops through where U8 member is not 0. From here we have a SQL statement where we're inserting these dimensions and the Business Unit which is derived from the Workflow Text field. Whenever a end user presses the button it should trigger this DM job and Business Rule to delete an existing records for this BU in the table and then add all the records again.  The issue is however that in this case that we're expecting to see 112 records but only seeing around 40. I wrote to the error log and see all the row records of 112, however when inserting into the table we only get around 40, sometimes even less. From what I compared looking at all 112 records vs the 40 in the table, I noticed that from the error most of the records that are the looping through last are being added to the table, but only a few from the beginning. It's almost as if these records are be

Hi Community, I am using a range transformation rule to give all balance sheet accounts a Flow of CB_Load. In the data source Flow is pointing the account number. I then use account ranges in the Flow transformation group to derive the Target Value of CB_Load. However, I am getting a validation error because Flow is reverting to None which is against the constraint settings for these accounts. I would expect this account (8100030) to derive a Flow of CB_Load due to Rule Name Range4 in the screenshot. However the Range rule is ignored and Flow is stamped with None as per the Mask pass through rule. Does anybody have an idea of what might be going wrong? I could just have a hundreds of pages of one to one mappings but this would be a nightmare to maintain! Please note that the account transformation rule is a mask pass through where Rule Expression = * and Target Value = * so in the above example 8100030 is also the account in the data source. Thanks Russ

Originally posted by Tim VierhoutHi, I am working with an automated import, which imports files into specific country workflow profiles. Right now this is triggered manually by the admin, but in the future, we want to schedule this. The DM Sequence loops all country workflows load the appropriate files and process the cube based on a parameter in this sequence containing the time period. For example 2021M1. Part of the calculation definition is to trigger a DM Sequence to execute a consolidation. In this DM Sequence, the variable T#WF is used, because it will also be triggered by users manually when executing the workflow. This leads to the problem, that when for example we load 2021M1, but in the workflow, something else is selected, the T#WF variable is filled with the incorrect selection, as in the month that is selected in the workflow. When manually triggering this is not a problem, because we can select the correct workflow. However, when scheduling, we would like to schedule fu

Does anyone know of a way to handle this situation while using a Line Item dimension on a cube view input form? Let's say the Line Item dimension has 20 members.  Can you set a default number of Line Item rows to always show, say 10, but allow the users to add more as they wish?  I know the latter part is possible with the Allow Insert Suppressed Member property.  I don't know about the first part of the question.  I tried splitting it up into two rows, but the second row, which would be the one to insert Line Item rows when desired, doesn't display anything to click on and use the insert suppressed action. Thank you.

Can a databuffer be made available in a dashboard data set business rule? I'm trying to get a data buffer data into dashboard data set so that I can manipulate the output for reporting.   I tried passing the databuffer from globals.getobject, but even though the object is visible, it doesn't expose all the methods.

Hi, I'm new to OneStream and wondering if this Account rollup is possible using inherited Account dimensions? Cube 1 is the Main cube and needs to show all Accounts, but the Cube2&3 should only show & operate on a subset of Accounts within this Hierarchy Thanks for your help! Sincerely,David

Hi, Can OneStream work on Mac OS? If so, how?

Hello --  I'm trying to isolate a data point sitting at an Account parent with USD as the currency, then copy that value to a different account.  Then, I want to use the second account to seed another in different scenario and account structure, where it will NOT translate (plan to use flow dimension to accomplish that part). For the first part of this, I'm trying to hold the USD value by inserting into another account. api.Data.Calculate("A#BPA_InvestSubs_USD:C#USD = A#InvestmentSubsidiaries:C#USD") Is something like this possible?  I'm getting an error about invalid destination when I attempt to consolidate.  Is an Eval needed instead?  What might one look like for this if so? I'm new to OneStream - appreciate any tips and thoughts. Thank you!  

Dear community, I am working on some Data Buffer and I noticed something : As you can see (if it's not too small ...), the Data Buffer is not taking into consideration the data units (that makes sense) and not the View dimension either. However, the data units will have the dimensions : Cube, Entity, Parent, Consolidation, Time, and Scenario. --> Hence, where is the "View" member in all that ? Am I missing something ?   Regards,  

Trying to align the text in a button to the left. HorizontalAlignment = Left does nothing. I've also tried HorizontalContentAlignment under Image. It centers the interior text no matter what I do. Anyone have any thoughts? Is this possible at all? Kind of annoying if not.    

Hi, I have  this workbook with 2 spreadsheets. 1. A tableview retrieving data from a Custom table. 2. A sheet with a lot of formulas to calculate some numbers.  When I try to copy a cell or range of cell from the second sheet it gives an error saying ' DocumentModel.IsCopyCutMode is false'. This happens only in OneStream Spreadsheet window not in excel add-in.   Any idea what could be the reason and how can it be resolved? Thanks

Dear Community, For an allocation purpose, I would like to load data currently stored in a data table, into a cube. But to speed up the process, I would like to ignore Validation and Transformation steps. Is there a way to do so ? Regards,

Does anyone have example code they'd be willing to share here that allows the Intersection Error report to be attached and sent via email when errors are encountered during *automated* load processing?Our users are being notified that an error has been encountered, but they have to log into OS to look up what the error was (new unmapped account, etc.). It would be nice to provide the error detail as an attachment or in the body of the email.Also just curious how others in the community are notifying users that Load Errors have been encountered during automation, and providing the error detail to them?Any input is appreciated.Thanks!

Hi all,  We created a test account to load some test data into but we now would like to remove the account. How would I go about clearing the data from the account in order to delete the account? The data was inputted into the account using an XFSET function.   Thanks!

Hi!   I’m trying to create a cube view that can drill down to stage detail data. Is there any documentation on this?  Any input would be greatly appreciated!

Is there any way for me to rename different scenario types(from the 24 scenario types) and also add a new one?

New to onestream and doing some training and have sandbox env to play around with it. I have questions on the cube design and extensibility.  I am trying to extend account and product dimension to fit to my three cubes even though level of entity will be the same in two diff cubes. How would I go about? e.g I want to reallocate my salary based on NetSales.Can I have two account dimensions? I cant think of how I am going to do allocation. Or I just need one cube & have everything in their but that will decrease performance, I guess.