OneStream Platform Forums

Hello everyone,We are trying to upload data to OS through a csv but I'm getting the following errorI checked the file both with excel and directly with a text editor and it seems the amount is correctly formattedDo you guys have any idea why OS is giving us this error?

Hi - Is there a way to override security to show the IC Partners' Workflow Statuses in a Dashboard so each workflow can view altogether the status of all Partners?  I created a data adapter using a WorkflowAndEntityStatus Method Query but they can only see the Workflows they are in the Access Group of.  Can I replicate what is happening behind the scenes in the IC Matching > Show Partner Workflow Status?Thanks in advance to anyone that can help! 

Anyone has called and executed Excel function (Forecast.ETS) from within a business rule?

Hi,We would like a particular user with authority over several accountants that have certified their accounts for that user to be able to uncertify (un-certify) those certain workflow profiles if any changes are required.At present, if the workflow has been certified the user gets a warning.. has not been granted access to application role 'UnlockWorkflowUnit' for application.So how do I grant them this access ? The only group they are not in is 'Administrators', but we do not want them to have full unlock/uncertify rights, but only for the selected entities which are under the parent that they have reporting responibilty for.Keywords Unlock and UnCertify Ancestors and Unlock Workflow Unit

Hi,   Does OneStream application has any App or link to access for Apple Mac book users ? We have many leaders in our organization using MacBooks, IPAD Pro etc.. they are not able to access Onestream application now. Any suggestions ? We have recently upgraded to OS 8.1 version. 

I have an application using the culture feature. This gives me multiple member description options. When I pull a member in a cube view, it's displaying the description from the wrong culture. It's pulling from the English culture description instead of the default description. How can I change which description it displays?

We are exploring pros and cons of enabling  Onestream access to our global users using Citrix / Azure virtual environment. Primary reason are, to reduce the .net installation in individual desktops, control excel temples from a central team etc..Could you please let us know if there any others who are using Onestream from a Citrix / centeral environment ? if yes, how is the performance impact of Onestream vs a normal desktop environment ? Do you have any learnings /feedbacks from their experience which you can share ?Any other items we should consider before taking this path of Citrix / Central Onestream access approach ?Thanks for your time and inputs. 

We are (officially) migrating our archived, pre 2020 data into OneStream (from our HFM archived environment) does anyone have experience with this, tips, and tricks? Our thoughts are only loading data into the entity and account dimensions since we won't need to transact as it's post-close/post-calculated data. Any advice or support would be amazing!

Hi,I've been using a data management step (part of an archival sequence) to copy data between Scenarios and archive data. It has worked well in the past but now I'm getting below error when I run the step."Error processing Data Management Step 'step_SeedForecastMonths'. Arithmetic overflow error converting numeric to data type numeric.The statement has been terminated. (SQL Error Number -2146232060, 8115, 3621)"Any ideas as to what would be causing this ? I verified the data and I seems like the copy did work for the period selected however the error message still pops up.  Thanks in advance!JT

Of all the File Share types, the one I least understand is the "Contents" folder.  What is it used for? There are even three System Security Roles controlling its use, but no clue in the Design and Reference guide as to what we are meant to use that folder for.  Can someone please educate me?  

Hi!I am trying to do the following variance to calculate the incremental balance between 2 Qtrs but the time filter doesn't work:GetDataCell(Variance(CVR(Row8),CVR(Row8):T#PovPrior1)):Name(Incremental RWA EOP)Row 8 is also a CVR calculated row. I have Quarters in columns, so need to do the formula as dynamic as possible. 

I've seen an earlier post around this issue.  Was there a bug?  Is there a solution? thank you.

Hello,We are doing an implementation and my client needs to be able to have one legal hierarchie and one management hierarchie, the twist is I need to be able to share the accounts between the two.Example:Legal parent     AccountManagement parent     Account (Shared)I can't use extensibility because the two hierachies share no similarity whatsoever, the only thing they share is GL accounts. In my Oracle days that would be a piece of cake, but for some reason I can't make it work in OneStream Accounts dimension.Thanks in advance 

I am launching a business rule through a Data Management job for all the base entities of certain rollup, i.e, TopEntity.base. As expected, the code loops through all the base entities and executes the code. I want to log the POV passed in for troubleshooting purposes. When I log the message, it logs it for each iteration of the code. Is there a way to only log the message for the first iteration of the code to avoid logging multiple entries to the log? As a workaround, I have hard-coded a specific entity, but if I can avoid hard-coding that would be ideal. Below is the code snippet:#Region "Clear_Calculated_Data"If args.CustomCalculateArgs.FunctionName.XFEqualsIgnoreCase("ClearCalculatedData") ThenDim sTime As String = api.Pov.Time.NameDim sScenario As String = api.Pov.Scenario.NameDim sEntity As String = api.Pov.Entity.Name 'Logging Info for Troubleshooting Purposes - Using Single Entity so message is not logged multiple timesIf sEntity = "Ent_005" Then Brapi.ErrorLog.LogMe

The same formula works in a quick view sheet but errors out in member formaule on UD8.If (Not ViewMember.IsAnnotationTypeViewId(api.Pov.View.MemberId)) ThenReturn api.Data.GetDataCell("BWDiff(T#[Quarter(|WFTime|)]:U8#None,T#[QuarterPrior1(|WFTime|)]:U8#None)")End IfThe error that I am getting once i run the CV -formula using in th QV sheetGetDataCell(BWDiff(T#[Quarter(|WFTime|)]:U8#None,T#[QuarterPrior1(|WFTime|)]:U8#None))  

Hi All,  For some reason, local entities are translating incorrectly to reporting entity - they are not using the FX rates given. The FX setting are to use scenario FX rate setting (see screenshot), not the cube.  When doing the recon - I identified the differences when translating (see screenshot). Additional, it's taking amount not reported in local entity, and reporting it to reporting entity.    What could be the problem?

I have scheduled a data management sequence to run every 120 minutes between a specified time range (7 am to 9 am) -- But the data management sequence is not being executed. There are no parameters needed in the data management sequence, and I have confirmed that manually running the sequence works without error. When I check the grid view in Task Scheduler, I can see the "Next Start Date/Time" column is correct. However, when the system finally reaches that time, the task is not executed, the "Count" column remains as zero, and the "Next Start Date/Time" column updates to 120 minutes later. I receive no system errors on why the task is not executing.I have confirmed the scheduling a one time task, or even a daily task works successfully.  Any help on this would be great.

Is there any check that we can put in the WF confirmation step to check the if the data that was loaded through import was actually validated?I have configured the confirmation rules group which will show error/warning based on the threshold amount for the v_ Accounts.But if the data is not loaded to the cube, the variance accounts would still have zero balance, so the confirmations rules are still green as its technically within the threshold amount. Need to check if there is a way to not allow the users run the confirmation rules at all without passing the complete Import-Validate- Load sequence.

We are trying to do a multi-year planning application. One requirement is the ability to calculate out-months into the next year of the plan. One solution that would be very useful is the ability to run a custom calculation with a variable set of time periods.   "BRApi.Finance.Calculate.ExecuteCustomCalculateBusinessRule" has an enumerated argument of CustomCalculationTimeType. One of the enumerations is "MemberFilter", but there is no indication or documentation regarding how to supply the member filter for Time periods to execute for.   Would anyone know how to implement this, or where I could find the details regarding its usage?   Thanks in advance for any information or leads.

When I ran the report book, the Default value of Parameters is not showing instead it is taking recent selected value.Please provide any suggestions.

Hello there,I made an Event Handler capable of retrieving all 'Transformation' & 'Validation' rejects in order to treat these irregularities automatically. The script creates a 'List' type of transfo rule in the concerned dimensions and populates it with all the rejected source values. The script works just fine for most cases. However, if the group of transformation rules has One-To-One mappings then the 'List' rule is just ignored (since One-To-One is prioritized over Lists).My questions: - Since I cannot afford to go over original One-To-One mappings & change target value to 'ByPass', how can I modify the order of transformation rule types(List then O-t-O then composite etc...) ? If not possible, how can I retransform my data at the end of import using 'List' transfo rules only ? 

Is there any better way of getting rid of these default TOP other then explicitly adding them in each row with Name tag?  

Hi all except for the standard operators (+,-,*.....) are you aware of a complete list of operators that can be used in "api.Data.Calculate"? I have checked the official documentation with no success. In my case I would like to use the Absolute value in a formula that more or less shoud work in this way api.Data.Calculate("F#ABS_Element = ???AbsoluteValue???( F#ORIGINAL_ELEMENT)  )   Thanks in advance for the help   Marcello

I have a Reporting component that uses a rich Text sub componentand i want to bind multiple variables into  it :Does anyone know what the correct syntax is  syntax is ?Regards,

Hello, In the SQL table editor component, we can define namely the Schema Name, Table Name, Table Column Names, Where Clause and Order By Clause : However, I am using a Table that has encrypted data, so I would need to use my symmetric key when loading the table. For that, I need to write an SQL statement beforehand : OPEN SYMMETRIC KEY MyKey DECRYPTION BY CERTIFICATE MyCertificate; and a CLOSING statement : CLOSE SYMMETRIC KEY MyKey;  However, the SQL table editor component doesn't allow to add these fields. --> Is it possible to add these statements when the SQL table editor opens ? Could it be done with a business rule ? More generally, how can we handle encrypted data ? Regards,