OneStream Platform Forums

Hi All, We are trying to load more than 100 rows through a table view using the method NumberOfEmptyRowsToAdd in the Business Rule: tv is our table view object.  However, when we add a value bigger than 100 in the code, no rows are available to load data in the Spreadsheet. We think is an internal limitation from Onestream to optimize performance. Is there any way to increase this limit? Maybe is only possible with some additional admin privileges in OS?    

Hello Our customer would like to reconcile sales/costs by division. is there a way to display the UD elements in the IC matching report? I see that only 1 element can be selected in the parameters Thanks in advance Marcello  

Is it possible to calculate slope, Correll and Intercept for a given factors vary by 12 periods using OS Finance Rules? If so, what are the libraries, I need to Import? Appreciate any suggestions how I can implement this in OS.      

Hihi, I am using a variant of the GolfStream finance business rule "XFR_MemberListAlphabetical" and need to pass an additional variable into the rule. For a Finance rule, is it possible for a CV or QV to pass the MF variable to the rule? Currently, the rule is setup statically on a starting entity:   Dim MemberListstart As String = "E#[Total GolfStream].base""   However, because our organization has thousands of entity, the finance rule passes all base entity into the QV. With suppression, I can arrive at the relevant members, however, it significantly slows down the rendering of the report. I've tried using the api.POV command, but it passes the user CV pov, which is not always relevant to the CV. Is there a way to pass a variable using something like an args.NameValuePairs()? I am having difficulty with the limitations of the finance rule VBA set. Essentially, I need the memberfilter builder of "E#[MyEntity].XFR_MemberListAlphabetical,Ent_Sort]" to use "E#[MyEntity] as

Hello, We are in the process of building workflows . During the demo of required workflow forms, there are some check reports built for users to verify their data and add comments. When the user switches between report tabs in the workflow, the refresh takes approximately 20 seconds to a full minute depending on the report. Our implementation partner suggested reducing the number of columns. We do have several columns of data, however this is needed for a proper review, and would like to review alternatives before reducing the reporting content. Is there anything else we can do to increase report refresh speed when there's multiple columns? Thanks, Will

Hi All,  In OneStream there are many audit tables containing specific sections that can be audited. I'm looking for a detailed overall data audit showing which user changed which number at what time. Preferably combining loads with (Excel) input. Does anybody know which tables to join to get the good old HFM data audit table?   Thanks in advance,  Marc

Assuming data exists at every base account shown, the data will be accurate at the 69000 – Net Income level using the following account structure in a monolithic cube. Question Credit: Chul Smith Is this statement fact or fiction? Comment your best guess below! Answers will be revealed in one week. * This question is applicable to Platform 7.3.0 and may not be relevant to future releases

Does anyone know how to keep the OS Excel Add-in from crashing when you activate the solver add-in? I can't seem to get these two to work at the same time. Has anyone else experienced this?

After validating data in the XFSqlTableEditorSaveDataTaskInfo.EditedDataRows property collection, if a record fails validation, I set the XFSqlTableEditorSaveDataTaskResult.CancelDefaultSave property on saveDataTaskResult = True and return it.  SQL Table Editor still saves the data.  Same if I set it to False.  Am I missing something?Code:         For Each xfRow As XFEditedDataRow In saveDataTaskRows isValid = validationHelper.IsValidDetails(xfRow) If (Not isValid) Then saveDataTaskResult.IsOK = False saveDataTaskResult.Message = $"{saveDataTaskResult.Message} {Environment.NewLine} {validationHelper.validationMsg}" saveDataTaskResult.ShowMessageBox = True 'SQL Table Editor still save the updates 'regardles whether this Is True Or False saveDataTaskResult.CancelDefaultSave = True Exit For End If Next Return saveDataTaskResult              

Hi,I'm working on clearing data from a Plan scenario and ran across this error. Has anyone encountered the image below? If so, what did you need to do to clear the data out?   

The issue is the following:For one of our clients we have a workspace step in our WF which has a button “Start SAP BW Process Chain”. This button triggers a data management sequence and should in the end turn the Workspace step green (if no error happened). When pushing this button there should also be progress bar showing where in the process the task is.Question - Is it somehow possible to start a data management sequence in a way that it displays the progress bar from a dashboard extender rule and that the workspace button is completed? We tried the following:Running all three versions of BRApi.Utilities.xxxxDataMgmtSequence (Start/Queue/Execute) but these always start the dm sequence in the background without displaying the progress bar.Is there a way to enforce to show the progress bar?Could event handlers maybe help out to give back the completion of the worfklow? Does anyone have an idea on how we can get the workspace to complete (turn green) and show the progres

Hello ! I am trying to execute the "LogonAndReturnCookie" web api. I thought everything was configured correctly, but I get the message (401 - unauthorized) : "Error processing External Provider Sign In information. Custom Scopes from the Request do not match the ones configured." In the REST API documentation, it is written that the "custom scope" should be as followed : (OneStream web api  app custom scope : allowpostman) : [screenshot removed] How do you configure this custom scope in the app / in azure AD / in postman ?   Regards,

Hi All, I am creating a cube view with a 'Current Year' column and a 'Prior Year' column based on the POV (this company has an August close fiscal year).  These columns work if I am viewing full year over full year, but if I want to view Feb 2022 YTD vs Feb 2021 YTD, it does not work for the prior year.  The values returned for 2021 only show the full year.  Is there a way to dynamically pull 2021 YTD data based on POV? Attached is a snapshot of what I currently have tried. Any help would be greatly appreciated. Thanks, Damaris

I don't know much about method queries, so I'm hoping to get some feedback on how to build off of or reference the data tables as well as where these tables are stored. The ICMatchingForWorkflowUnitMultiPlug method type used in the Intercompany Matching application reports returns the entities as "Name - Description," which causes a few problems for us considering our entity names' were created with an obscene number of characters and underscores. I've copied the reports and data adapters, but not sure how to write the script within the Report Designer or how to alter the data adapter... Any suggestions?

We are trying to input data on monthly basis for forecast and actual. As in next step if we want to see QTD view which should be M1+M2+M3 , but its not working. how does this QTD and MTD workflow works in the form ??In historical data its working perfectly fine.

I am trying to use LockWorkflowUnitDescendants with a non standard channel. The logic seems to allow express use of 'NoDataLock', 'AllChannelInput' and 'Standard', but for custom WF Channels, can't seem to identify how to get the GUID.'Dim wfChannelId As Guid = WorkflowChannel.Standard.UniqueID -> THis works'Dim wfChannelId As Guid = WorkflowChannel.custommadechannel.Uniqueid -> this doesnt workBRApi.Workflow.Locking.LockWorkflowUnitDescendants(si, wfClusterPk, WorkflowProfileTypes.InputImportChild,wfChannelId )

Hello,  Our Organization is currently going through a Planning implementation of OneStream. We have provided a list of enhancement requests to OneStream that we feel would significantly improve the products reporting capabilities. Here is a list of the enhancement requests submitted. I am posting with hope that other customers would also benefit from these enhancements and reach out to OneStream directly to also request this functionality! You can also like ("Kudos") this post.   1.       Drill Down within XFGetCell Function. (This was something that came up a lot at Splash when discussing with other customers) 2.       Retain excel formatting when refreshing quick views 3.       Ability to utilize the member description to pull quick views or XF functions (Today you can only user member name) 4.       “Hardcode” the default Quick View POV when creating

Hi All, Has anyone built a custom audit data report for their OneStream planning applications which shows which users changed which entities/accounts/scenarios, etc on specific days? Not sure if we have a marketplace solution for this. Any leads will be helpful. Thanks, Nidhi Mangtani

Hello Team, Do you have an update on possibility to have a direct connection to fetch data from OneStream SQL database. Thanks.    

In Microsoft Excel, the Percentile and Percentile.Inclusive functions use the R-7 Methodology, Percentile.Exc uses the R-6 Methodology for Quantiles.   These functions exist in the OneStream Spreadsheet tool, does anyone know if they are the same as Excel?

I am trying to import data directly from an external database and store it in a temporary data table in OneStream using Vb.net code.  Unsure if this needs to be achieved through extender business rule or connector business rule.  A code snippet of similar implementations would be helpful.

Hi,    I am trying to allow users to calculate cube view in a workflow on an icon (see picture attached) within the cube view, but when they right click on the cell, calculation is disabled. Please let me know if someone knows solution for this

I am looking for a business rule or function to lock and unlock workflow and then set it as scheduled task.

CubeView that was assigned to different role is still visible when the user is set to another role.Example:CubeViewProfile1 - Access Group: Role 1CubeViewGroup1.1 - Access Group: Role 1CubeViewGroup1.2 - Access Group: EveryoneCubeViewProfile2 - Access Group: Role 2CubeViewGroup2.1 - Access Group: Everyone User with Role2 is able to view CubeViewProfile1 and all of its members while user with Role1 is able to view CubeViewProfile2 under OnePlace > Cube Views.How do I hide the CubeViews in OnePlace from users who do not have the right role? Are there other configurations I need to take into consideration? 

Hi everyone, I don't find a lot of documentation about the vDataRecordAll view. Is there a reason as to why this is not easily available? How hard is to get the JOINS to the main tables, so we can see the dimension name, dimension value, etc? Or even a relationship diagram.     Thx Raf