OneStream Platform Forums

Dear community, I am currently using the REST API (using the Personal Access Token that really works well !) in order to retrive a Cube View. It's very easy to use as it works just like a regular Data Adapter configuration. However, the cube view that I query is using 2 parameters. If I don't specific the parameters and a value in the REST API query, nothing is returned. I can specify the value manually, however I will lack the flexibility of the cube view to retrieve specific values. How can I change the REST API call for my cube view so that the parameters are indeed prompted ? {"BaseWebServerUrl": "XXXXXXX","ApplicationName": "Production","CubeViewName": "PVM_Graph2","DataTablePerCubeViewRow ": true,"ResultDataTableName": "ResultDataTableNames","CustomSubstVarsAsCommaSeparatedPairs": "P_POC_INP_UD7_Part1=D1,P_POC_INP_UD7_part2=D2","CubeViewDataTableOptions": {"IncludeTitle": false,"IncludeHeaderLeftLabel1": true,"IncludeHeaderLeftLabel2": true,"IncludeHeaderLeftLabel3": true,"Includ

Hello,  Wondering if there was a way to carryforward V#Annotation inputs on BalanceRecurring Account Types (or any other Account Types) similar to how a V#Periodic input is carried forward on BalanceRecurring.  For example, we have the users selecting a text string in a data cell and would like that data cell to be carried forward when saved. When we click save on this BalanceRecurring Account, the text string doesn't carry forward months because no value is being stored at V#Annotation. V#Annotation:   However, we can change the parameter to have the value of a MemberID (Integer) which stores the value at V#Periodic and displays the String. At V#Periodic, this carries forward that string which is our end goal. V#Periodic: Due to the nature of the tables supporting these custom dropdowns, we would prefer to be at V#Annotation and carrying forward text strings that way. Has anyone encountered this or have solution to carryforward V#Annotation inputs?    

We have been using the SAP connector for fetching the GL data and few other information like units and install base. The connectors were working fine until Oct 2023. We noticed duplicate and/or missing rows. The row counts would match. It would only have this issue when the data is in multiple packages. We had package size of 10000. As a workaround we increased the package size 100000. But one of the integration has >500000 rows. When we tried to increase the package size to match the rows, the integration would fail with internal memory size error. Looking into get data function, I would like to know if there is a way to add order. Below you will find the get data code. The where clause is - r3Table.AddCriteria("FISCYEAR = " & "'" & fiscalYear & "'"). Is there a way to add order by? #Region "GetData" 'Read source data from the R3 table Private Sub GetSourceDataSAP(ByVal si As SessionInfo, ByVal globals As BRGlobals, ByVal api As Transformer, ByVal r3Conn As R3Conn

Hello~, I am wondering if there are any solutions available for bulk deletion of DM Sequences and Steps. We have hundreds of Sequences and Steps that will not be used, and deleting them manually would require a significant amount of effort. Could you please assist us with this? Thank you in advance!

Hi, I have a data source, where the leading character of the alphanumeric values in the column are used to identify if the row value should be assigned to a particular dimension field in a UD. The complex expression here will display results in the error log indicating it has found the rows that I want to assign a different value for in the UD, but I don't know how to set that , so that the imported data assigns my UD requirement. Basically I want it so that if the args.value starts with "R" then assign it a value of "R" in the UD2 otherwise, leave it/set it as "None". Dim sValue As String = args.Value Dim myValue1 As String = "UD2 R-" & sValue Dim myValue2 As String = "Ignore" If Left(svalue,1)="R" Then BRApi.ErrorLog.LogMessage(si, myValue1) Else BRApi.ErrorLog.LogMessage(si, myValue2) End If   Any thoughts or am I approaching this the wrong way ? I cannot see that I would do this in a transformation rule as it is the source GL code that carries this information. Ch

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  

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?

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

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?