OneStream Platform Forums

Is there a way to achieve a 90 degree vertical orientation for text within a report header?  See example screenshot where the right most 8 column headers are vertically oriented. Looking to achieve this within OneStream reports. Haven't found anything within the standard formatting available.  Thanks

I'm using the action setting on the buttons parameter to pass a value, but nothing is happening. This button is used as a link to open a dashboard, that parameter is the id of the dashboard.

Dear community, It's an open question, hopefully you can forward this topic to other consultant and active people working on OneStream. The question is : how do you think is the best way to work on restatements ? Use Case : the customer load and input data, then validate them all and lock them, finally they report data for 2022. In 2023, they need to modify some of their input because they have more accurate data, which they will ultimately report on as 2022 (restated) in their 2023 reportings. Waiting for your anticipated feedback and thoughts on Workflow definition for this use case, eventually consideration for dimensions build. Regards,

I have several data feeds from OneStream to different application/db. I am currently trying to pass a parameter from OS which says which application and environment does the data feeds belong to?   What is the db table and column name where the applicatiotion  name and  the application environment is stored in?   Thanks

Hi Everyone. how could I do the following getdacell through the data management, that is to say to obtain those specific departments, because when I leave it in all_departments in the data management it does not go through, then I would like to know what I can do to do things like this in the rest of the POV elements. Dim dataCell1 As DataCell = api.Data.GetDataCell("Cb#HLFPLN:E#41401_41402:C#INR:S#[Forecast 2023M2]:T#2023:V#Periodic:A#611900:F#None:O#Top:I#None:U1#D1309:U2#ALL_PRODUCTS:U3#COUNTRY_RPT:U4#ALL_PROJECTS:U5#None:U6#None:U7#None:U8#None")  

Hi, Does anybody know if there's a way to create Data Attachments using business rules? Something similar to this functionality, but in code: Thanks!

Hello, I am trying to add scroll bars to a dialog box that has 6 components.   Tried changing the layout to Horizonal and vertical stack with other settings.  This did not work and also asked the one stream experts . my team and appears there is no sure way of accomplishing this.  Is this possible in OneStream ?     Thank you, Sharon

I am trying to run a Custom FX translation rule on run a set of Account @HistoricalRate with Periodic Rule type.The function seems to be working fine for the direct Rule type but does not seems to be working for the periodic Rule type. any reason? Dim Accts As List(Of MemberInfo) = api.Members.GetMembersUsingFilter(api.Dimensions.GetDim("Dim_Accounts").DimPk,"A#Equity.Base.Remove(A#CTA,A#CY_RE,A#Pr_Yr_RE)") Dim AcctList As New List(Of String) For Each Mem As MemberInfo In Accts AcctList.Add(Mem.Member.Name) Next If AcctList.Contains(api.Pov.Account.Name) Then Return New FXRateResult(False,api.FxRates.GetCalculatedFxRate(api.FxRates.GetFxRateType("HistoricalRate")),FXRuleType.Periodic) 'Does not work 'Return New FXRateResult(False,api.FxRates.GetCalculatedFxRate(api.FxRates.GetFxRateType("HistoricalRate")),FXRuleType.Direct) 'This works (Commented) End If  

Hi, we recently migrate to OS 8.2.2 and we are facing a strange issue with the cube view connection in Excel. When we refresh them excel takes a lot of tie to show them and it looks like it's building them slowly on the screen. Example:  Frist came the color of the column headers; Second the color of the row headers; -Third the text somewhere; and so on.  It's like that excel is building lively the cube view and calculating each cell including setting the style of each cell.  Any one with the same issue? We tried to open the same connection in the spreadsheet inside of OneStream and the performance was great.  Kind regards

Hi, I need to extract the Task Activity from 01/01/2024 until today for audit purposes. Do you know if there is a report or the best way to extract this data instead of extracting it page by page under the below Task Activity option? Thanks in advance!    

Hi all, Has anyone else experienced the following issue with "Save Offline Copy" feature in excel? If the user has "retain all formatting" set to TRUE in preferences, the file takes an unreasonably long time to save.  During my testing of the file (only 684 bytes in size), I waited over 10 minutes for save to complete and it never did so I had to kill Excel and relaunch every time. If that retain formatting option is set to FALSE, the file saves immediately. Interestingly it also saves with all the formatting as well - except for any 'superscript' font settings. Same behavior seen whether using Excel 32 or 64 bit.   Same behavior seen whether saving to local folder or onedrive folder This makes no sense.  Really all the save offline process should be doing is replacing all cells containing XF() functions, with the resulting values. Right?  And If I set retain formatting to FALSE, shouldn't it save without any formatting at all?  This setting doesn't seem t

Hey there,We have created a BI Viewer and we want to extract the BI viewer to excel but through a button in a different dashboard. Is there way to get the data in the Bi Viewer through a Business Rule, create an excel workbook and save it to File Explorer>Application Database>users>(userName) ?I know how to create a workbook from a dataTable or a dataset in the BR and save it, but I am having a hard time getting data from the Bi Viewer to the business rule.Thanks

Hi, Is there a way through cube views member formulas or any other means to combine two scenarios? For example when reporting Actuals vs. Plan we now have a Plan_1.0 and Plan_2.0.  Rather than creating a new scenario to combine the two - is there a way to report on Actuals vs. (Plan_1.0+Plan_2.0)?  Thank you!

Hi! I have this cubeview with the filter member below When I export to Excel, I would like have the columns header filled with the dimension name "Entity" and "Consolidation" Someone can help me?  

Hi,  right now we have a bunch of Forecast scenarios that have a time span of two years, example:  Jan 24 to Dec 25 Is it possible to lock some inputs in one specific year? The forecast process has a period where some entities are adjusting some keys and they only should be able to do it in the second year (2025), not the first one (2024).  Any idea? 

Hi Everyone. What I want to do is restrict access to certain ICs so that some users cannot view them ,currently, even after changing permissions, they still appear. Therefore, I would like to know how to implement a solution where only specific intercompany data is accessible to a user.

I am storing a record in one of the OneStream database tables, but once stored, I am unable to view the component on the OneStream page. I need to refresh manually multiple times or modify another component to see the changes. Could anyone please help me resolve this issue? Thank you.

We have a requirement to have daily backups for our applications for a period of 15 days.  OneStream cloud offers point in time backups up to 7 days and only weekly backups past that period.  I know how to back up artifacts/metadata in OneStream but not sure how to back up data.  Does anyone have any ideas on the best way to create a data back up?

Can anyone tell me why our standard journals are reversing every month?  I thought that you had to select 'auto reversing' type for reversing and standard would therefore not reverse?

Hi Team, I  am building a cube view  with 8 columns and need to set up the color formatting to it which is yellow color for total values in first 4 rows/columns and red for negative numbers , green for positive numbers in the next 4 rows/columns , can anyone suggest.   Thanks in advance.

Hi, is there a way to completely validate data cell access for a user in a BR using the api? I'm looking for something that would run the same logic as you would expect from a cube view, basically validating cube, scenario, entity and sliced security at the same time.  I would expect a method that takes a user and a datacell object and returning true/false or similar.  

Is it possible to create a report that shows all of the Business Rules within an application and where in that application each business rule is being used? 

How to enabling tree expansions (+) in columns? This functionality works on rows when using the member filter (.tree), but it does not work on columns.   Any solution? Please.

Hi All, We have variance calculated column working fine for account members for all account types except for Dynamic account type members when we use the below formula. Do we need to do something different for Dynamic calc members to calculate variance correctly? Return api.Data.GetDataCell("BWDiff(U8#None, U8#None:T#PovPrior1)") Thank you

Hi Team, Is there a way to copy data from base entity member to parent entity member at O#AdjInput and at different scenario for ex: i have data setting at base entity at O#Import,S#Actual, now i want to copy the same to Immediate parent entity at O#AdjInput, S#Actual_Test. Please let me know if any one as any solution. Thank you in Advance Satish P