OneStream Platform Forums

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.

Hello I am trying to create the below CV. I am struggling with the Account % Change from PY.  Is there a way to reference the column time - 1 year and still have it dynamic?     2022m1 2022m2 2022m3 2022Q1 Account         Account % Change from PY                               T#|!ParamQtr!|.base T#|!ParamQtr!|     Account         Account % Change from PY        

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,

Hello,I'm working in the excel add-in and creating a some reports for my company and was wondering if you can use Column Better/Worse in the add-in. I know you can with cube views or quick views, but those limit the formatting we want. The reason I want this is to be able to differentiate between account types when it's doing the comparison like it does in Spreadsheets or in Cubeviews.Thanks,Will

Hello, I'm trying to figure out a way to have OneStream perform profit in inventory eliminations.Currently we manually compile data in excel to calculate how much profit sitting in the inventory and at what common parent we need to eliminate it. These manual eliminations are ultimately loaded in OneStream via upload files.One thought is to setup custom input form in the workflows that would collect ins-&-outs of profit in the inventory and utilize Flow dimensionality. But I'm not sure if there is a better approach to this problem.  

Hi All, My team and I need to create a dashboard that will help the user in bulk certify workflow profiles. the whole interface is similar to Workflow Multi-Period Processing(screenshot) but with few changes, which will only focus on Certify the workflow profiles for import trial balance step for multiple LEs at once and not multiple steps for 1 LE. This needs to be created under Dashboard process. Is there any guide or marketplace solution for this? any help will be greatly appreciated.     

Hello there,I am wondering if there is any possible method to link a dashboard to a GridView. Upon clicking on a specific row on the gridview, I want to retrieve all row values (similar to bound param in Cube Views) & then display my dashboard based on those valuesAlso, is it possible to horizontally center columns in a GridView ? Thanks in advance 

Good Day I am new to OneStream so forgive me if this question and the answer should be known but I have created a SQL table with values and I would like to take those values and write them to a cubeview. I am using a business rule and was wondering how would I do this. I am aware I need to make a sql connection so my initial code is:Dim sql As New Text.StringBuildersql.AppendLine(" SELECT * From x_BatchControl")Using dbConnApp As DBConnInfo = BRApi.Database.CreateApplicationDbConnInfo(si)Using dt As DataTable = BRAPi.Database.ExecuteSql(dbConnApp, sql.ToString, True)Looking for any help on this. Thanks Rehaan

Logging with OneStream is great but when we all use the Error Log at the same time, things can get messy very quickly. Moreover, logging in a file instead of the Error Log can be very convenient when logging kickouts.The initial setup can be a little involving but once you get a knack out of it, logging in a file is as easy as using the Error Log.In this post, I will show you how to do the initial setup and then how to log into a file instead of the Error Log only when there is an exception or every time.This rule and methodology is the result of the genius work of Matt Ha and I am very thankful he shared it with us.Initial SetupIn order to log into a file, you need to import a Public Business Rule, it will be called by the logger and it is available in this post (GS_GlobalHelper.xml).Side note, remember that in order to make a BR Public, you need to change the setting for ‘Contains Global Functions for Formulas’ to True.Setup of the BR to log into a fileIn order to call a Public funct

Hi all, is there a possibility to create a data source and give it a fixed file-name on an UNC path instead of having to select it in the user-interface? e.g. assume I get the file always put to \\fileserver\sharename\subfolder\filename.csv and want to directly load from there.If not, what would be the workaround?ThanksMarkus

Hi Team,   I would like to know does anyone Implemented the OneStream Integration with NetSuite Cloud using RESTlets and I am looking for the right documentation and the details required from NetSuite cloud. Thanks  

We are trying to Override account member in Column.we have 2 accounts being called in a single column, her we need to Override only 1 account member from the list of 2 accounts.Below is the reference CV.In the below screenshot we are having 2 accounts "A#100 and A#200" in Col2, here we need to Override only A#100 Account member with "A#300"Currently problem which we are facing is it overrides both "A#100" and "A#200" with A#300.Please let me know if we can overcome this by using some Business rules? Thanks in advance!Nidhi   

Hi all, We're trying to pass below listed parameters to the table view: Case Is = SpreadsheetFunctionType.GetCustomSubstVarsInUse Dim paramList As New List (Of String) paramList.Add("ParamScenario") paramList.Add("prm_UD4_Select") Return paramList Case Is = SpreadsheetFunctionType.GetTableView Dim objDictionary As Dictionary(Of String,String) = args.CustSubstVarsAlreadyResolved Dim objDataSet As DataSet = BRApi.Dashboards.Process.GetAdoDataSetForAdapter(si, _ False, "da_Capital_Reports", "Getfullreport", objDictionary) Dim dts As New DataTable() dts = objDataSet.Tables(0) Dim tableview As New TableView() tableview.PopulateFromDataTable(dts,True,True) tableview.CanModifyData=True Return tableview Case Is = SpreadsheetFunctionType.SaveTableView   but the refresh sheet (via excel add-in) errors out as "Conversion from string "tu" to type 'Integer' is not valid.Input s