OneStream Platform Forums

Is there a way to download OneStream Libraries to GitHub? We need to use gitHub for version controlling of the business rules.

Is there any documentation available for the backend tables in OneStream? Many of the tables are composed of keys pointing to other tables, and it can be challenging to discern the relationships between them. Additionally, understanding what each column in a table represents would be helpful. For instance, in the vStageSourceAndTargetData view table, columns like Wfk, Wsk, and Wtk essentially form the Workflow POV, but this isn't explicitly stated anywhere, making it difficult to interpret.

We can write a business rule to export data from the OneStream backend/custom tables, but is there an out of the box solution to do so? The Data Table Manager marketplace solution also has the option to export data, but only up to 5000 records.

in OneStream we can do custom table with process development, also there is Thing Planning where we can do process development. Is there any document or anyone can help us to provide the pros and cons of these 2 development methods? 

Hi, I am trying to access a file stored in Azure File Storage to import in the cube, but I need help to do that if I try using the REST API as the namespace Microsoft.Azure or any other Azure related namespace, as they are not available in the OneStream library.Has anyone encountered the same ?  Any better approach to achieve the desired outcome ? Thank you for your help 

Hi everyone. i want to make the following calculate, but i want to make the one of all the departments and all the projects, but when i put it as .base it gives me error in the calculate, then i would like to know how i can solve it or in what other way it should be made so that it works correctly.an image of my step configuration api.Data.Calculate("CB#[HLFPLN]:E#"& entity &":S#[" & scenario & "]:T#" & time & ":A#cra_639950:F#InCostsAllocation:O#Forms:I#11201_11207:U1#ALL_DEPARTMENTS.Base:U2#P0000:U3#LOCAL_DATA:U4#ALL_PROJECTS:U5#None:U6#None:U7#None:U8#None = (E#11201_11207:S#[ForecastAllocation]:T#" & time & ":A#cra_ALLOCPRCT:F#None:O#Import:I#11201_11257:U1#ALL_DEPARTMENTS.Base:U2#P0000:U3#LOCAL_DATA:U4#ALL_PROJECTS:U5#None:U6#None:U7#None:U8#None)*(E#11201_11207:S#[" & scenario & "]:T#" & time & ":A#cra_639950:F#None:O#Top:I#None:U1#ALL_DEPARTMENTS.Base:U2#P0000:U3#LOCAL_DATA:U4#ALL_PROJECTS:U5#None:U6#None:U7#None:U8#None)",False)

Hi, Good Day ! I would like to change the Entity Relationship property from dashboard. When the user clicks the button, the metadata associated with the entity relationship property should be updated to reflect the option the user has chosen from the dropdown menu. Can you please help me how can I achieve this requirement.    Thank You     

We upgraded to 8.2.2 last month and switched our data connector to the SIC connector.  Since upgrading all our drilldown cube views (to stage data) have been loading slow.  Most of them used to load instantaneously.  Now some take 5-15 minutes to load.  Has anyone had this issue?  I have an open ticket with support.   They ran indexing and that helped but just a bit.  Thanks in advance.

I am trying to get dimension info using a member name. I came across the function, Dim nValue As Integer = BRApi.Finance.Members.GetDimIdFromMemberId(si, dimTypeId, memberId), but it requires dimTypeId. Is it possible to get dimTypeId using member name

How do I concatenate 2 member filters? Something like this:  

Hello!We are using the OS API to pull data to ADF using data connectors and cube views.  This has been working fine until we upgraded to 8.2.2 a few weeks ago.  Here's the error I'm getting in ADF.  Our URL actually didn't change.  Has anyone seen this or know how to fix it?  THANKS IN ADVANCE! Operation on target Copy Actuals from HTTP Endpoint failed: ErrorCode=HttpRequestFailedWithClientError,'Type=Microsoft.DataTransfer.Common.Shared.HybridDeliveryException,Message=Http request failed with client error, status code 400 BadRequest, please check your activity settings. If you configured a baseUrl that includes path, please make sure it ends with '/'. Request URL: https://xxx.onestreamcloud.com/onestreamapi/api/DataProvider/GetAdoDataSetForAdapter?api-version=5.2.0/.,Source=Microsoft.DataTransfer.ClientLibrary,''Type=System.Net.WebException,Message=The remote server returned an error: (400) Bad Request.,Source=System,'  

I cannot select "Copy a Quick View" while my cursor is in the Quick View and I refreshed the sheet from the menu. Why? What am I missing?

Is there a way to make a data source process rows that do not have a value in the Amount column? For example,  an import file has 4 rows: Account Name Cost Center Name Amount Cash G&A 5,000 AR G&A 5,000 AP G&A   Retained Earnings G&A 10,000 OneStream will only process the Cash, AR, and Retained Earnings rows becuase the AP row has no value in the Amount column. While a complex expression can evaluate the empty amount in the AP row and retun "0", the Data Sources only processes the three rows into Stage.  

Hello, We are working on a navigation dashboard which navigates users to corresponding workflow when they click on a button. It works perfectly but we want to go further. In stead of positioning on the workflow (for example, current WFProfile is ConsoReporting.EntryForms1), is it possible to directly open the first required form on this workflow profile? Thanks in advance.

In version 8.2, rows get suppressed when using .Tree in combination with an indent level…is this expected behavior? For example: If I setup a cube view with Accounts in the row (e.g., A#Account.Tree) and have indention set to 0, it will display the account and its descendants properly. But, if I change the indention to 2, the row will be suppressed.

Is it possible to create a custom user prompt / error message to pop up when a user tries to complete a Form and triggers a FormsEventHandler? I have tried throwing an Exception as below but the problem is it includes additional information about the business rule error that is irrelevant to the end user and could cause confusion. Is it possible to create a cleaner message that just contains the message itself.    

Hi,I have a report book with Report item which contains a Dashboard Report. The Dashboard component is a Grid View with a BI Blend Data Adapter.I get the following error when the report book is opened from FileShare.I am using Dashboard Report type in Report Book, and per Design and Reference Guide: The chart and report items are application dashboard chart components, rather than dashboard components.Does it mean I cannot use the Grid View Component in Report Book? I have the BI Blend data in a Dashboard Grid View component, and I need to get this into the book.Please let me know if you are aware of any workaround to achieve this. Thanks in advance.AK

Trying to do a QTD Average during the second month of the quarter.  Using the v#QuarterAvg did not work as it includes all months in the calculation.    

We can create books that contain Excel Export Items but when using parcel service to send them, they are attached as pdf files. We need to send them as excel files. 

Hello, Is there a simple way to apply multiple data sources into one BI Blend Dashboard Graph? For example, a bar graph that compares Actual sales to PY.  I am running a SQL script to return data for my data adapters. I've added them as components to my BI Viewer, and can select one or the other under the "Data Source" drop down. I just can't manage to get both sets of data into one chart. I know this is feasible but think I am missing something. Thanks!

I'm trying to run cubeviews by way of the REST api on Version: 8.2.2.16127 We use PAT tokens for a native onestream user. Suddenly I started receiving meaningless errors about a day ago like so: "An error occurred returning data for 'Cube View RPT_SVC_PbopHierarchyBase', Please check the Error Log for more details. Unable to create database connection. There is no open application"         Does anyone know what this means?  Is it a bug?  Any help would be appreciated.

Dear all,   Is there any file containing the detail/syntax of the functions? I'm thinking for instance in an XML file or something similar.   This is a similar question already posted, but I'd like to know if there's an update. Solved: documentation/list of functions in OneStream Namespaces/Libraries - OneStream Community (onestreamsoftware.com) Thank you in advance. Carlos

Hi All, We have a requirement with regard to our data mapping. There are certain data fields which are marked as XXXXX. We want to skip these by using for example X? and X* but that does not seem to work. How can we simply skip every value which starts with and X? Thanks in advance.

Another system on the network is pushing data into OneStream using a REST API. OneStream has a DataManagement group and a step to absorb this data. Is there a way we can pass back a custom response to the calling system?   Thank You for all your help in advance. Indu

Hi All,  we are trying to check the data before deleting a member, the issue is with derived data if we have derived data in that member not able to track it. while deleting the member it show having data but in real there is no data only 0 derived is there not sure how to handle this. Please let me know if any more details required.