OneStream Platform Forums

Can someone please explain the difference between "Apply Access" and "Increase/Decrease Access" in Slice Security ?For Example : How it makes a difference when selecting "Apply Access - All Access" Vs "Increase Access -  All Access"Also please advise any training materials for Slice Security? 

Hi AllWe are using 8.4 at our new client and have been tasked with creating dashboards suitable to view on a tablet, web, windows app and phone.We have created different dashboards for each of the different devices, i.e. tablet, phone, windows app and web but have noted that for example, the phone dashboard formatting shows differently on each phone, depending on the phone screen size and it does not auto adjust to fit the screen size of every phone.Same as for tablet, web and windowsApp. Where can I get settings for auto fit on each device so that it shows uniformly on each device regardless of screen size? 

Hi there,I'm looking to automate dimension uploads in that I want the dimension to be "replaced" with the new one that I am loading. I want to reduce the burden of having to add or remove members from dimension and just automate that process. How can this be done and where should I start? Thank you in advance, Joesef

Hi, I am unable to access external database view via sql table editor in the Cloud OneStream (version 8.2). Can somebody suggest what can be the possible issues? It is working fine when accessing the current app database but only issue is when accessing external database. The external connections are fine as able to access the data via data adapters.

Hi everyone, Does anybody knows how to replicate the SEC format in a OneStream cubeview?  Here an example from Facebook.   Sincerely,  

I have 1200+ orphaned members with no data in my U6 custom dimension that I'd like to delete.   The delete icon only allows 1 delete at a time.  Is there a way to perform a mass delete?

HiI appear to be having a slight issue when trying to feed the user selection of multi combo boxes embedded in the main dashboard to other dashboards that the user would be navigating to (i.e. their selection on the main dashboard would be the default in the next dashboard).  I can currently only get it to work for one single combo box at a time?I'm using a Dashboard Extender Rule which incorporates both the LoadDashboard function type (this is activated against a server task for the dashboard being navigated to) and the ComponentSelectionChanged function type (this is attached to each of the combo boxes as a changed server task)Any advice on this would be much appreciated or if there is a easier way to achieve it?ThanksAndy 

The Preserve Excel Format option seems to work for retaining formatting done in Excel when re-opening and refreshing cube views. However, I'm finding that my data is greyed out as if invalidated upon refreshing a cube-view in Excel after the initial connection. I've tried setting the font color to black and that was overridden upon refreshing as well, even though all other formatting is still intact. Perhaps there is a setting I am missing?

Good Afternoon,    I am trying to save an offline file in onstream retrieve and I am getting this error. Not enough memory resources are available to complete this operation. (Exception from HRESULT: 0x8007000E (E_OUTOFMEMORY)) Has anyone had this issue

Hello,  I am wondering if there is any way to change a fiscal year once we have been using the application for quite sometime (several years.)  Our current Fiscal year is 2025 so all the data is being imported into year 2025, but we now need to adjust our fiscal year one year back.  So everything in 2025 becomes 2024.   Is this possible?  Or what options might I think about? Would I need to setup and start using a new scenario? Any ideas, comments, suggestions would be greatly appreciated.  Thank you  

I have a dashboard with a cubeview.  The user is allowed to enter data into multiple cells and then save.  I have a save event handler to verify the data entered, however, I cannot access all of the information at one time.  The event handler provides access to one cell at a time.  Also,within each row I have a cell where users may change the numeric value and another where they type in an annotation.  Changes to the numeric value cells will fire the event handler however changes to the annotation cells alone will not trigger the event handler.  Is there any way to access the entire cubeview pre saved data to verify entries.  I need to know that if a user entered a value that they also entered an annotation or if the user removed an annotation where a numeric value existed on that row.  

Hi all we have this error with our SIC connection to SAPhe SSL connection could not be established, see inner exception.)The SSL connection could not be established, see inner exception.Unable to read data from the transport connection: An existing connection was forcibly closed by the remote host..An existing connection was forcibly closed by the remote host. (Socket Error Number 10054)Anyone seen this before and knows how we can resolve?Nouria

Hi All,Could you please provide the code for sending a CSV file from OneStream to the SAP environment using the PUT API?Thanks,Chandrakala  

I have a Cubeview that's Header rows are Entity/Account/UD2.  I'm going to export to excel, but currently I get column A is Entity, Column B is Account and Column C is UD2. I'm trying to figure out if there is a way to make Column B be a concatenation of Account and UD2 when it's exported.  Column C can be whatever or not at all.

I'm trying to load a workflow using an Excel template and need to set the *WorkflowName* as one of the following: Import, Validate, Load, Process, Workspace, Confirm.Currently, I'm using the highlighted value in the *Workflow* column for this purpose.Similarly, if I need to set the *WorkflowName* to Workspace, Direct, Process, Confirm, Certify using the template, what value should I use? Is there a reference list for this, or where can I find it?   

Hi- I was wondering if there is any way to combine 2 cube views that are already built. Assets and Liabilities are on 2 different reports and I am trying to combine into 1 report. 

Hello All,Is it possible to establish a connection between SAP SuccessFactors and Onestream?Thanks,Chandu  

I have a dashboard with buttons that export excel workbooks. I have one cubeview that uses Column Sets and I am not able to get this one to work with the button. I was hoping either a combo box or pop up parameter would work, but I cannot get the export to recognize the columns. When I manually run the book from file explorer it gives me the column set parameter and works just fine. This leads me to think I'm missing something in the button execution.Thank you!

Hello,  Can the Excel format be set on the cube view so that the header font can be underlined, for example?  New Product Analysis instead of adding a guideline for the entire header cell?

Hi Everyone. I have a question about how I can assign the entity that appears in my Calculation Definitions to my assigned Data Management Step. Currently, I have it set to E#Root.WFProfileEntities, but since I have it in a Profile that does not have entities assigned (because it is a Profile where I want to mark all my WF as complete), it gives me an error when I try to use it from there.  

I have captured journals at a base entity on C#OwnerPreAdj . When I process the cube, the values do not get consolidated. I have to run a Force Consolidate for the result to come through on reports.  I have set my cube settings for Calculate OwnerPreAdj if No data to True.  This is on Onestream Version 8.4.

We are looking to turn some of our existing cube views into report books to loop through entities. Right now we use an XFBR string (referencing Brapi.Workflow.Metadata.GetParent) instead of a parameter to determine the entity. Is it possible to create a report that loops through the entities with the XFBR string or would we have to duplicate the cube views and use a parameter instead? 

I have a Cube View with three Account dimension columns - Net_Rev, Std_Cost, and a CVC calculated division column to calculate Std_Margin (Std_Cost/Net_Rev). Rows are a UD dimension representing the Product.  In my Dashboard, I have a Cube View MD Data Adapter using this Cube View as the data. When I add a BI Viewer Pivot Grid, I want to display the same three columns - Net_Rev, Std_Cost, and the calculated column. I see CalcScript in the Pivot Grid's Data Source dimensions. How do I use it in the Pivot Grid to display the calculation that the Cube View was doing for that third column?I thought I might reference it in the Value filter along with the two Accounts, but it doesn't appear as a column in the Pivot Grid. 

I am trying to get a dashboard to have a particular scrolling behavior that I am not sure how to do if it is even possible.  A simple example of the ideal is below.  In this ideal dashboard the dashboard will scroll horizontally only.  The inner dashboard will individually scroll vertically.  I can not seem to get the outer dashboard to only scroll horizontally, and when it does that outer horizontal scroll turns off it appears the inner vertical scrolls.  I think I am asking for too much but was hoping to get some confirmation.  Thanks.  

Hello everyone, I am experiencing an issue with a dynamic calculation rule in OneStream for a user-defined dimension (UD1) grouping entities. The rule works correctly for all Consolidation dimensions except for "Translated," where the data is not calculated or displayed at the UD1 level, even though the base entities have values for that member. Context: I have a dynamic calculation rule that sums the values of base entities grouped under a UD1. The rule’s logic is the following: Dim entity As String = api.Pov.Entity.Name Dim text5 As String = api.Entity.Text(5) Dim ud1 As String = api.Pov.UD1.Name Dim ud1Man As String = ud1.Substring(1,3) Dim parent As String = "P" & ud1Man Dim result As Decimal = 0.00 'Filter the entities by Text5 Dim entityPk As DimPk = api.Dimensions.GetDim("Entities").DimPk Dim entityList As List(Of MemberInfo) = api.Members.GetMembersUsingFilter(entityPk, "E#PL00.Base.Where(Text5 Contains '" & ud1 &"')", Nothing) 'If we deploy the entities with an