OneStream Platform Forums

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

Hi Everyone. I would appreciate some help in understanding how the DataBufferCellPk works in the following code, and in general. I’m currently reviewing a business rule where entities are charged to others—essentially an allocation. However, I haven't found any use of CALCULATE or similar functions that would typically handle this process. This leads me to believe that DataBufferCellPk might be responsible for it. Could you please assist me in understanding this better and provide more context on the issue I'm trying to resolve? Dim dbcpk As New DataBufferCellPk( mbrRefIdAcc, mbrRefIdFlow, intOriginId, mbrRefIdIC, mbrRefIdUd1, mbrRefIdUd2, mbrRefIdUd3, mbrRefIdUd4, mbrRefIdUd5, mbrRefIdUd6, mbrRefIdUd7, mbrRefIdUd8 ) 'BRApi.ErrorLog.LogMessage(si,$"Valores de DataBufferCellPk 2023M3: MbrRefIdAcc: {mbrRefIdAcc}, MbrRefIdFlow: {mbrRefIdFlow}, IntOriginId: {intOriginId}, MbrRefIdIC: {mbrRefIdIC}, MbrRefIdU

Hi there, I'm looking an example using the "Specific data filters". So far, I can filter the data using the "combinations of data filters" in the previous step as expected, but I need to be more specific on the data combinations to export. Does anyone have used it? For instance exporting: A#(subsetA1):F#(subsetF1) A#(subsetA2):F#(subsetF2) and do not exporting: A#(subsetA1):F#(subsetF2) A#(subsetA2):F#(subsetF1) Thank you Best regards, Carlos 

How do I set up a task in the task scheduler to run as Administrator and not as me? Thanks, Scott  

Dear community,   Is there a way to name (:Name("test")) a column when the columns in a CubeView is set by a parameter (Application dashboard) which is referencing to a business rule?   I want the last member to be renamed from description "2024 Q2" to a name I choose "2024Q2 YTD"   Public Function GetFCTCVColumnSet(ByVal si As SessionInfo, ByVal globals As BRGlobals, ByVal api As Object, ByVal args As DashboardStringFunctionArgs) As String Try Dim CurrentScen As String = args.NameValuePairs.XFGetValue("SelectedScenario").ToString.Replace("'","") Dim CheckFct As String = CurrentScen.Substring(0,8) Dim CheckFctSubstring As String = CurrentScen.Substring(0,12) Dim TimePeriods As String = ""   Dim CurrentScenYear As String = CurrentScen.Substring(CurrentScen.Length - 4) Dim CurrentScenNextYear = CurrentScenYear + 1 Dim CurrentScenNextNextYear = CurrentScenNextYear + 1   TimePeriods = "T#" & CurrentScenYear & "Q2:V#Periodic:U3#Top:U4#Top:U5#Top,T#"

Hello All,We have setup People Planning for 24 periods.  We need to import the data into a cube across 2 years/24 months.Wondering the best approach.We have flagged Allow Loads After Workflow View Year as "True".We have tried using "Range" in the Workflow Tracking Frequency.This approach works, but the fact that we can't change time periods in the Scenario, creates some monthly and annual process management issues.Anybody use an alternative approach?Thanks,Scott

Hi Team,   I am building a cube view with account in rows. In columns i need entity and UD2 dimension members but the columns  names should change as entity members and UD2 members based on choosing the parameters. I have tried  Primary dimension type as entity  and nested member expansion primary dimension type as UD2 but i am unable to achieve my requirement, can anyone please suggest .   Let me know if any questions.   Thanks in Advance.

Dear community, I need to send data over another external Azure SQL table. What are the ways (and possible business rules ?) to do so especially if this external table hasn't been configured as a regular "external table" by onestream ? Regards,

I have a BR that is setting a value in a member's text3 field. In doing this I have the following code which appears to NOT save the member description so it is being cleared. BRApi.Finance.MemberAdmin.SaveMemberInfo(si, PDOToUpdateInfo, True, True, False, TriStateBool.FalseValue) I changing the False in the line above to True, the code compiled with no errors, but at runtime I received the error " Error updating member 'IT_PGM_1038_27'. Invalid parameter. Descriptions, IT_PGM_1038_27." What am I doing wrong? I can send more of the code if that would be helpful.