OneStream Platform Forums

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.    

is there any video available on 8.4 upgrades/features/enhancements?

Hi all, I am exploring the functionality of cell formatting based on the text of column header 3-6, I noticed there is a conditional formatting ColE1HeaderDisplayText and ColE2HeaderDisplayText, but not sure if the same function could be applied to header 3 -6 as well. Thank you.  

We are building a Consolidation application with 10 Base Entities and approx. 2000 Cost Centers. Each Cost Center is valid for only one Entity. In Other words a group of Cost Centers are valid for One Entity and the same group of Cost centers are NOT valid for any other entities. Given this requirement is it best approach to create Separate cubes for the 10 Entities and apply Extensibility on Cost Center dimension with Valid Cost centers for the Entity OR Create One Cube and apply UD Constraint on Entity with the Group of Valid Cost Centers ? Appreciate any thoughts or recommendation between these 2 options.  

Hello,  I am trying to change the columns of a cube view so that using entity ChildrenInclusive we get each column sectioned by each entity and in one single tab. We want this to be in one tab, not multiple tabs so I didn't think a book would work. I was able to make it look like this with these columns members. However, in the original CV we had specific formatting for the Variance B/W and Variance % columns which I cannot figure out how to apply to the multiple items in the nested column member. This is what I have currently for format. This works, but applies the pink formatting across the first 3 columns when I only want it on the Variance B/W column. Is this even possible? NumberFormat = [#,###,0;(#,###,0);0], If (RowName Contains FSLI) AND (ColName Contains Entity) AND ((CellAmount > 4000000) OR (CellAmount < -4000000)) Then BackgroundColor = Pink Any ideas or other ways to go about this? Thanks, Megan  

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!

Hello OneStreamers, I'm looking out for a potential solution to create a custom Entity Drop Down that displays Text2 property value inside the dropdown. Eg: Entity Name Text 2 Property EntA ABC EntB DEF EntC GHI Now, when I fetch the Entity List, the dropdown should show like: ABCDEFGHI And NOT the entity names. Do we have a workaround to achieve this?Thank you!JackLacava OSAdmin 

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.  

Hello, I'm tying to read files from an azure fileshare mount as a disc unit in the same server  where SIC is installed. I guess this has to works as a disc unit C:/ but the business rule throws an execution error Could not find a part of the path 'z:\\Temp\\zw_2023.csv'. this is part of the code that I'm using Public Sub CleanupData(ByVal si As SessionInfo)Dim objRemoteRequestResultDto As RemoteRequestResultDto = BRApi.Utilities.ExecRemoteGatewayBusinessRule(si, "TestFile", Nothing, "remote_test", "DeleteOldFileData")If (objRemoteRequestResultDto.RemoteResultStatus = RemoteMessageResultType.RunOperationReturnObject) ThenDim result As Booleanresult = objRemoteRequestResultDto.ObjectResultValueDim objRemoteRequestResultDtoCached As RemoteRequestResultDto = BRApi.Utilities.ExecRemoteGatewayCachedBusinessRule(si, "TestFile", Nothing, "remote_test", 90) BRApi.ErrorLog.LogMessage(si, "File Deleted: " & result) ElseIf (Not (objRemoteRequestResultDto.remoteException Is Nothing))