OneStream Platform Forums

A = 50% allocated to B , 40% to C,  -90% to A What will be the best approach to allocate data between entities?  Also, If you have a code snippet for data buffer that will be helpful. 1. Data Buffer 2. ADC  

Hello, I would like to bring attribute "Text 1" field identified in Entity dimension into a Cube view.  When users run a Cube View, they should be able to see Entity as a Column name and the “Text 1” field attribute which is identified in entity

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

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

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.

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?

Originally posted by Steve Davis How do I save a Member to the root of a dimension (as a child of Hierarchy)? I have tried the SaveMemberAndRelationshipInfo method, but this gives me the error:  Error creating parent-child relationship.  Invalid Parameter. child, [CHILDNAME].  

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

Originally posted by Eric Osmanski 6/12/2017 Any one have an example of getting a list of users in a security group not attached to a Workflow?

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.    

Hello! I'm an Enterprise Applications Business Analyst and we are looking for a RACI chart that shows the intended usage of the OneStream tool to better understand who and how to support our clients (Finance). We currently use Financial Reporting, Account Reconciliation (without Trx matching), and Capital Planning. Does anyone know if something like this has been created by OneStream? Does anyone have one from their organization? Thanks!

Hello everyone, Is there a way to collapse/expend column via a native display configuration on Onestream (v8.1) ? Something same as the RowExpensionMode option in the Header Formatting but for the column. Thank you in advance.

Is there an upward limit on the number of blank lines that can be kept in a journal template?

Hi everyone, I'm just trying to set up a sandbox of the OneStream server for my own learning.  However, I'm not very knowledgeable on the database side and am not sure how to set up the databases required for the application.  I've installed SQL Server Developer version but as I'm not a database person, I'm not sure how to create the underlying databases.  Unfortunately the OneStream guides I'm following don't go into the details of the steps within the database (understandably).  Does anyone have any guides or describe the steps needed to create the underlying databases for the server? Thanks,

We have users experiencing connection conflicts with the OneStream Excel Add-in. When they enable the OneStream add-in it disables the add-in they have for their ERP. They would like to be able to use both add-ins at the same time. How can we enable them to have both add-ins active? Have there been similar issues? What is causing their ERP add-in to be disabled? 

Hi OneStreamers, I am using the table vStageSourceAndTargetDataWithAttributes in a dashboard to display cost centers (Source Account) and Accounts (Target Accounts) per all other dimensions, for a selected entity and period. It's working fine but the amount from the table is always in the local currency of the entity, and I'd like to see all amounts in EUR. Is there an easy way to convert the figures in the table ? I saw there was a column named "Converted Amount", maybe it can be used somehow to show translated figures ? Appreciate your insights on this. Adam

Is it possible to use Cubeview Parameters in XFGetCell ? Saurin