OneStream Platform Forums

Hi, I sent out an excel cube view report to My colleague. He filled in the numbers and sent it back to me to submit. However, when I click the submit button in excel, the cube view report number is overridden ( to existing system data) and the number my colleagues input is gone. Any way to submit his number before the cube view loads the previous number? Thank you.

Hello Fellow OneStreamers, Please bear with the long post. I have the following workflow profile structure that contains Level 2 data unit overlap I am trying to change based on a financial planning requirement. The requirement comes in when an analyst reconfigures an hourly labor position in one of the assumption forms. A clear, retransform, load, and seed process should occur to align loaded data with the new configuration that will be used throughout the planning process for a particular position. The current workflow structure is a hinderance here because kicking off this process for a particular position retransforms and loads all entities which is much more data than needed. It also contains Level 2 data unit overlap because the same data unit is currently being loaded for the specified accounts within the current workflow profile structure. Our Current Production State: Base Input Workflow Structure Current State: Import Labor Data (Base Input Workflow Profile Step) Import Act

Some users are facing issue when running a calculate in a specific form in OS. I attached the error log. We're not able to replicate the issue. We notice that around the time the issue occured the CPU usage was 14%. I don't know if there's any link. Can you, please, help ? Summary: An error (The request was aborted: The request was canceled.) occurred while transmitting data over the HTTP channel. The request was aborted: The request was canceled.   ---------------------------------------- Error Time: 12/13/2023 4:15:28 PM Error Level: Error Tier: Client User: Justine UREEL Application: CONSO_PRODUCTION Web Server: vmPRD1Web2 Web Server XF Version: 7.0.1.13612 App Server: vmPRD1App5 App Server XF Version: 7.0.1.13612 App Server OS Version: Microsoft Windows NT 10.0.14393.0 Session ID: 330d13da-2417-4c2f-8734-e711820e6b76 Error Log ID: 27125b97-acc3-4ba7-a4ad-6e671620bc83   Total Memory: 68,719,005,696 (64.00 GB) Memory In Use: 3,243,065,344 (3.02 GB) Private Memory In Use: 3

The formula I created to calculate the MoM Variance% does not work. I am using the column filter to do the calculation. MoM Variance and Prior Year are calculations based on other columns in the report. What am I missing?GetDataCell(BWPercent(CVC(MOM_Variance), CVC(Prior_year))):Name(MoM Change %)    

Was making a application copy of which we do all the time. I have one environment. OS told us to download the new version of application copy and we did. Ran fine last week now we are receiving a failed error. I noticed that the iis reset is now not in the script.  This is my selection  

Dear all, I'd like to know how do you define a particular text for an IC member. I thought that once you define a text for an entity having a IsIC = True will transfer that information automatically to the same member in the IC dimension but it seems that it doesn't work that way. Given this, how would you set up the text for IC members? Thank you. Best regards, Carlos 

How do I filter I#ICEntities exclude E#Group(Text 5 = Equity) in Cube View and Excel Add In?

We are working on security settings for RCM and noticed that we can view the Actual results/all workflow steps. Is there a way to hide the Actual workflow steps from RCM only users? Currently if a user has access to RCM under the Model scenario they can still click on the Actual scenario and see their steps/all data. If there is not a way to easily hide the actual workflow steps/data are the 2 main options to create a suffix for the Model scenario and have it be its own cube root or to do slice security? Or do we need to also have the Read group for actuals be a large group of users that don't include only RCM users? 

Hi all,    This is a follow up on this original post (Reduce the size of empty row - OneStream Community (onestreamsoftware.com)). Does anyone know how to reduce the row size? For columns we have the ColumnWidth option in the formatting tab but there's no direct equivalence for rows. Thank you!

Hi, I am trying to load data from file where amount should be calculated as prior period minus current period and loaded. I tried using derivative rule to setup current period equal to prior period and multiply by -1 as below but it is being assigned to prior month, it is taking the current month value as below and calculated as zero. Please help me how I can assigned prior month value to current month.   Thanks, Manju Komara

I am trying to build a cube view where the columns represent the 4 quarters in the year and then a YTD column. So if the POV is 2023M8 then I would like to see Q1 2023, Q22023, Q3 (should be M7+M8) and Q4 should be zero. I have tried this but it is still displaying the total for q3 even if my pov is M8 it is still picking up M9 T#Quarter(|PovTime|).allpriorinyearinclusive:V#periodic my next column has this T#Quarter(|PovTime|).allnextinyear:V#periodic but it is still showing the YTD reversal any suggestions? thanks

Hi All - explored other threads but could not find the right answer. Unsure if this should be one or two mappings and what type if they are a conditional rule or composite? If value at SourceAccount MAIN has a value of 1, then: Source should be SourceAccount A for Target Account A and Source should be SourceAccount B for Target Account B Otherwise, Source should be SourceAccount C for Target Account A, Source should be SourceAccount D for Target Account B Thanks!  

I am trying to update StageSoureData table with member information during import step at BREventOperationType.Transformation.ParseAndTrans.WriteTransformedData event. Next when I go to validate step I am not seeing the updated data from StageSoureData table.Any idea from which table or cache the validate and intersect steps will get data?Thank you

Dear all, I'd like to know how you deal with this kind of case, because > and < symbols are special for .XML files. I have a case where the description uses a ">" or "<" symbols but they are not properly recognized once they have been loaded, instead they are loaded as ">" or "<". Do you know how to define them so the load would work properly?   Thank you.

Dear community, we have requirement to reduce the size of empty row, do we have any solutions to this. Any solutions to this question will be very helpful.Thank You!

We have come across an issue where a subledger has been loaded but is not picking up a singular item/line in the subledger. The item contains a number of commas and special characters in one of the text attribute columns, as do other items in the subledger, these other items load no problem. For additional context the item contains over 100 characters in this text attribute column, as do other items in the subledger, and although a character limit had been placed in the data source via complex expression all other items make it in except this item. Any thoughts would be great, Thanks!

Dear all, I'd like to ask about a generalization for the "Insert suppressed Member" tool. In the link (Insert Suppressed Row Members - OneStream Community (onestreamsoftware.com)), we can find a successful case but I can't implement it in a general case using member list. Also, at the beginning of the list, I added the parent member ("ICEntities" in this case). The issue is that when there's no data, the whole line is suppressed so it's impossible to use the "Insert suppressed Member" option. Also I checked the options for the columns as recommended here (Solved: Cube view rows suppression - OneStream Community (onestreamsoftware.com)) but the main line still doesn't appear. Some pictures about the setup: 1. Calling the member list in the Member Filter: 2. Options for row suppression:  3. Suppression options for each column:   Thank you  

Hi everyone, I was wondering if it is possible to retrieve the workflow status of a workflow profile in Excel.  Thanks for any help! Floris

Hi,My company has entities 2,5,8,N,U,O,X,Z.When I prepare the loop and if statement in the books;not sure why I could only use the if statement for N/U/O/X/Z but not 2/5/8.I have tried different settings but still not working.Can you share with me how should I write the code if the entity name is purely a number?Thank you.(|Loop1Variable| =[2]) Or (|Loop1Variable| =[U])Or (|Loop1Variable| =[O])Or (|Loop1Variable| =[X])Or (|Loop1Variable| =[5])Or (|Loop1Variable| =[8])(|Loop1Variable| =2) Or (|Loop1Variable| =[U])Or (|Loop1Variable| =[O])Or (|Loop1Variable| =[X])Or (|Loop1Variable| =5)Or (|Loop1Variable| =8)  

Hi Everyone. I have the following section of code. 'Search for values for the DataBufferCellPK, they are not empty. Dim dbcpk As New DataBufferCellPk( mbrRefIdAcc, mbrRefIdFlow, intOriginId, mbrRefIdIC, mbrRefIdUd1, mbrRefIdUd2, mbrRefIdUd3, mbrRefIdUd4, mbrRefIdUd5, mbrRefIdUd6, mbrRefIdUd7, mbrRefIdUd8 ) 'BRApi.ErrorLog.LogMessage(si, $"values of DataBufferCellPk: MbrRefIdAcc: {mbrRefIdAcc}, MbrRefIdFlow: {mbrRefIdFlow}, IntOriginId: {intOriginId}, MbrRefIdIC: {mbrRefIdIC}, MbrRefIdUd1: {mbrRefIdUd1}, MbrRefIdUd2: {mbrRefIdUd2}, MbrRefIdUd3: {mbrRefIdUd3}, MbrRefIdUd4: {mbrRefIdUd4}, MbrRefIdUd5: {mbrRefIdUd5}, MbrRefIdUd6: {mbrRefIdUd6}, MbrRefIdUd7: {mbrRefIdUd7}, MbrRefIdUd8: {mbrRefIdUd8}") 'BRApi.ErrorLog.LogMessage(si, "Parameters bufferdatacell: " & dupk.ToString & " * " & intViewId) Using dbConnFW As DBConnInfo = BRApi.Database.CreateFrameworkDbConnInfo(si) Using dbConnApp As DBConnInfo = BRApi.Datab

Hi; While trying to export TRX file from the transformation rule, the Visual Studio gets opened and it in turn gives an error message and I do not get an option to save it as a TRX file.  Would anyone be able to give any suggestions to help.    thanks Kumar

When we use the "Import a TRX file into the selected group" icon, the .trx file keeps getting uploaded into the "one-to-one" type. How I upload my .trx file into the proper Type (i.e. Mask, List, Range, etc). Background: I extra a copy of an existing transformation mapping by going to a rules profile/group and clicking onto the "Export selected group to a TRX file" on the top of the page.  Once I edit a few mapping changes and save the file back as .trx, I attempt to upload this .trx file using the other icon, "Import a TRX file into the selected group".  However, each and every time I upload this file, it doesn't hit the right Type (i.e. Mask, etc).  I extract from a Mask, and attempt to upload into the Mask Type, but the file keeps on going into the "one-to-one" type.  There must be a change I need to make to the .trx file before uploading it, to allow the system to know to upload the file into the Mask type and not the one-to-one type?   

Hi Community members, Need your help on the below business rule, as i am unable to identify the errors. The rule wrote for to get the value from combobox value and run Data managment sequence to clear the data. Namespace OneStream.BusinessRule.Finance.BOYD_Clear_Data_2 Public Class MainClass Public Function Main(ByVal si As SessionInfo, ByVal globals As BRGlobals, ByVal api As FinanceRulesApi, ByVal args As FinanceRulesArgs) As Object Try Select Case api.FunctionType Case Is = FinanceFunctionType.CustomCalculate If args.CustomCalculateArgs.FunctionName.XFEqualsIgnoreCase("ClearSeeding") Then '{Clear_Seeding}{Param=[|!ParamWFProfileEntities!|],Time=T#2023.BASE} 'Dim objList = api.Workflow.GetWFProfileEntities() Dim wfClusterPk As WorkflowUnitClusterPk = si.WorkflowClusterPk Dim intScenarioId As Integer = wfClusterPk.ScenarioKey Dim myWorkflowUnitPk As WorkflowUnitPk = BRApi.Workflow.General.GetWorkflowUnitPk(si) Dim intYear As Integer = BRAp

OneStream community,  I have been experiencing a weird bug lately... when scrolling too quickly in the FX Rates page, OneStream freezes up.  Sometimes, going to my computer Task Manager (Ctrl + Alt + Delete) and ending the program closes OneStream, while other times that does not even work and I have to restart my computer.   Are other experiences this issue/bug?  

I had one of our head budgeting people bring me a question the other day and I feel awkward that I didn't know how to answer him.He loaded data. He validated his 100k. The following day, he sees it's 75k. Neither of us has any idea how to tell who entered the data.He emailed the group of users who have security access to that data and one user confirmed that she had in fact submitted the updated number but... we did have to ask.Have I just lucked out and gone years without needing to do this so have become blind to a whole auditing feature I didn't know was there all along? Or, is it that recording per-cell auditing for every single edit is just impractical and there really is no way for us to do this? I don't see questions about it in Community. I don't even see any particularly relevant products/labels for this question! So, I'm at a bit of a loss. What don't I know that I don't know?Edit: I do see a mention in the Foundation Handbook that data auditing is there and can be used to fi