OneStream Platform Forums

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

Hello - I'm working on a cube view that will be used to add variance commentary. The rows have accounts and subtotals, the first column will have a specific entity that will not change, then the next set of columns will be dynamic. I have it set to pull base entities based on specific text values. The entities that do have the first text value (called "DP_2023Q4") are appearing as intended, however there are no entities that have the text value (AQ_2023Q4) in the member filter of the next column, so when I run the CV it just repeats the first column to the right of the columns with the DP_2023Q4 entities. I have several questions for this: 1. How can I set the cube view to return a blank column if there are no base members that have a particular text value? I added a column override with a UD8 dynamic calc set to return nothing if there's no data, and that didn't work. 2. Right now the member filters are set to look for text values that have "DP_|WFYear|Q4" and "AQ_|WFYear|Q4". This sh

Hello,   I am trying to set up a business rule that seeds the forecast from actuals to the forecast. This works easily when I am not using all entities to seed. However, I need to somehow take the actual data from each base entity and copy it all into 1 entity for the forecast. The client only needs to forecast at 1 entity but wants to include the actuals from every base. Is this possible to do in 1 rule? I know you can't have the entity on the left side of the calculation so I'm not sure how to solve.   Thanks!

Hi, I know I could create a custom member list of an XFBR rule for the scope, but is there an easier option to get the cube view rows ordered alphabetically based on member names? Eg. currently, if I have E#Ent1000.Children in row, the cube view is by default showing the members children of Ent1000 in the order with which they appear in the Entity hierarchy. I would like them to be ordered based on their name. Thank you

Hi,   I have a WF where I dont want to have user load data through import. Only Forms and Adj. I could turn the profile Active to False.but the problem is  I have a historic WF where is an import level for this entity. I tried doing the  optional data load to True. when i am complete the Workflow for the Import step - I get a error saying import step doesnt have a datasource assigned- which is expected as I am not having a active TB load.   Any suggestion where I can complete the WF - Import step without really loading data?    

Good morning all! I'm hoping somebody can put me on the right path...! I'm writing a rule with a data buffer. I want to filter the data buffer so it only runs where needed. I put in the following filter relating to the Text6 field. This syntax works in a cube view (I've tested this) but it doesn't seem to work in the vb.net rule. Can anyone tell me what I should use here instead to return only when text 6 is not blank? Many thanks,Richard

I have an Import Profile Type that includes a Workspace, Import, Validate, Process Workflow Name. The Workspace step uses a Dashboard that contains a SQL Table Editor component.  The table does not allow updates. When I run the same Dashboard from the Dashboards editor it allows updates.  I've also tried using a Forms Profile Type instead of an Import Profile Type and that allows updates too.   It must be something with the Import Profile Typet that is preventing the updates.  Is there a setting that I can change to allow updates in the Import Profile type?  

Hi ,   I am trying to create a offline package but getting the below error.(snapshot attached) '',hexadecimal value 0x03 is an invalid character What is the easy solution?    

Hi All, I have created a cube view and added an empty column, I am able to see blank at base member rows but here I am getting value in the rows of calculated member in the empty column, can anyone suggest how to get complete empty column in the cube view. Please find the below snap for your reference.   Thanks in Advance.  

Hi Experts,  Can you please help me how EVA calculated in OneStream? and how EVA Analysis report should be created? 

Hi,  I am using Derivative Rules in order to generate additional records in Stage. In this example, I have two derivative rules per I/C transaction. The account mappings will bypass the original source value and one condition will be met and therefore loaded to the cube. If the value is greater than 0, then the value will go to 40L1CA.001A_DER. If the value is less than 0, then it will go to 40L1CA.001L_DER. Derivative Rules: Account Mappings: IC Mapping:   The value shown below is $224,469.18 therefore the rule is correct. However, the IC is this case is mapping to None. I was expecting IC to map to IC partner 170 based on the IC mapping shown above. How can I ensure that the IC partner is mapped correctly to the cube? I want to ultimately tie out IC matching report.

Hi, We're trying to allow all users (Everyone) write access to a specific dimension V#Annotation for all entities that they have read access to. Example: UserA is part of a security group that has only read access to Entity1. We would like them to be able to write only to V#Annotation on Entity1 as well. We've tried using Data Cell Access Security but I can't get it to increase / decrease security where we want it to. Is it possible to increase access to users who don't already have write access to a specific entity? If so, what would be the best way to accomplish this?

Hi all - This is probably pretty basic, but I keep getting stumped. Ultimately I have two monthly metrics I want to look at for each month for current year and prior year. I can get the current year rows set and working, but for some reason for the prior year rows, it shows me the full year data instead of the periodic, even when the cell POV shows "periodic" it fails to grab the month with the year. set up like this:   The months are tied to the columns and the year is tied to the row. Any idea why my PY rows cannot recognize the month while the current year can?

Hi there  I need to write a composite UD1 composite mapping rule based on a another dimension (Entity)  Example :  looks to see if the Entity is a base of Parent A , then map it to UD1 X , otherwise if the entity is a Base member of Parent B, then map it to UD1 = Y Please help    

Hello, I am trying to seed data from Actual to Forecast scenario. I am running the Business Rule through a DM step, whose data unit contains the forecast scenario, so that it picks this forecast scenario in the destination string. My Actual (Detail level accounts) are on more granular level and extend my planning accounts (plan and forecast accounts). The planning accounts are on top level.  Now, when i try to seed the data, it picks the Planning Accounts (since i have Forecast Account in my DM step), due to which my  Actual accounts are not picked up by the process. and the data copy is partial. I am trying this by using DataBuffer. Please let me know if there are any suggestions or solution to this. Thanks

Hi everyone. I have the issue that when clicking on a row in an SQL table editor, it doesn't open the view with the correct value, but instead, it displays the value from another table. I have 4 tables that use the same view to edit information, and each one has a different bound parameter, and that value is assigned in the SQL table editor section. Example: As you can see, it's set up in the same way, but where the DItemID value is assigned is where I'm having issues. ¿Any solution to this?  

Hi . Does someone know what is the maximum number of members allowed for a product dimension?, we are assessing implementing the SKU reporting level and we manage around 13k products, I am wondering if the application can manage this volume of data. Regards.