OneStream Platform Forums

Hi guys! I would like some guidance on how to pull all children at the same level in a Quickview. Thank you.  Oliveira, Vanessa

Hi  I am trying to delete files saved in public folder via business rule. Below BusinessRule.Extender works fine to delete the files from share folder. Dim configSettings As AppServerConfigSettings = AppServerConfig.GetSettings(si)'*** First Delete files from username folder created under Data Management->Export folder****'------------------------------------------------------------------------------------------------------------Dim xfolderPath As String = FileShareFolderHelper.GetDataManagementExportUsernameFolderForApp(si,True, configsettings.fileShareRootFolder,si.AppToken.AppName)'**xfolderPath stores the path for DataManagementExportUsernameFolderForApp**Dim filesToDelete As String = "TRF_Rules_*.xml" '; // Only delete all files which starts with names TRF_Rules*Dim fileList = System.IO.Directory.GetFiles(xfolderPath, filesToDelete)For Each file As String In fileList'System.Diagnostics.Debug.WriteLine(file + "will be deleted");System.IO.File.Delete(file)Next   H

You cannot use OneStream to directly report on SAP data Question Credit: Jack Lacava Is this statement fact or fiction? Comment your best guess below! Answers will be revealed in one week. * This question is applicable to Platform 7.3.0 and may not be relevant to future releases

Hi    I want to read a text value from dashboard in finance business rule. I tried attaching a parameter to text box component and then read that parameter in the code but that is not working.   Thanks, Omkareshwar    

Hello, I am looking to connect with folks who have implemented specialty cubes to manage data for sales, HR, Projects, Treasury, etc. We are exploring the capability of building a digital transformation roadmap using a cube approach, similar to how Essbase can be used. We are considering using the register to utilize larger data sets and other functionalities. Would love to hear your experiences. Thanks! Regards, Ronnie

You cannot change BiBlend configuration if a Workflow “Blend” step has already been executed Question Credit: Jack Lacava Is this statement fact or fiction? Comment your best guess below! Answers will be revealed in one week. * This question is applicable to Platform 7.3.0 and may not be relevant to future releases

Hi Everyone, I hope all are well.   I am trying to use the GetICMemberFilter function in a business rule but I don't know how to get the VarybyCubeTypeId.   Does anyone would know how to obtain the VarybyCubeTypeId using a XFBR?   Thank you for all the help.

Hi community, refering to the solved request in the link: Solved: Show 0.0 in Cube View Data Cell instead of blank cell - OneStream Community (onestreamsoftware.com) Is it also possible to get a drill down here? That doesn´t work with the described UD8 anymore. Thanks.

Hi all,In our use case, users are uploading data through files into OneStream. Is there a possibility to check if the file have 1000-seperators in the file and block the upload if this is the case? Reason is that within one workflow the 1000 seperators could differ between users and we want to avoid issues in this instance. Ideally we have a parser rule that checks the amount column.With kind regards,Tim Vierhout

Hi,I wonder what's the difference between IsConsolidated member property and Aggregation Weight which is relationship property? When one's usually set IsConsolidated to False? I can imagine that it make sense for non-additive values (like KPI's), but I'd rather use for that Aggregation Weight, so not sure what for is that differentiation. Any tips, example use-cases?

Hello, We need to clear data on the specific intersections of Account, Entity, UD2, UD3, and UD5 members (all members from the remaining dimensions). The data is copied from the Actual to the Forecast scenario. So, I tried to use clearcalculateddata API in the member formula but it is clearing data on that account for all members of UD dimensions. Can you please help with the simplest way to clear the data on a specific intersection?   Ex. We need to clear data for the below intersection. The below line is clearing the data for A#7041 irrespective of other defined UD members. api.Data.ClearCalculatedData(True,True,True,True,"A#7041:O#Import:F#Base:U2#13056:U3#327:U5#01973")  

Hi,   I have an existing extensibility rule which copy some data from a source scenario/period to a target scenario/period.   This is the "core" of the code Dim listDriversDataCellExFilterdForDriversTarget As New List(Of DatacellEx) For Each itemDataCellEx As DataCellEx In listDriversDataCellExFilterdForDrivers   itemDataCellEx.DataCell.DataCellPk.TimeId = TimeTargetId   itemDataCellEx.DataCell.DataCellPk.ScenarioId = ScenarioTargetId   listDriversDataCellExFilterdForDriversTarget.Add(itemDataCellEx)Next itemDataCellEx   Now, I was trying to update this to only copy data where UD3=None, but I am not sure on how to do that. I can see datacells have a function called GetUD3Name, but the function requires a FinanceRulesApi parameter.   Would using the GetUD3Name function work for my scope and what would be an example of valid FinanceRulesApi parameter?   Thank you

In a cube view, how can I use a manual input value in the formula in another column? Col1 Col2 Col3 EndBal Input Value EndBal - InputValue Many thanks in advance. Winni

OSAdmin If we have multiple OneStream Environments, is there any Market Place solution or a way we can compare Security (Users/Groups) between environments and then Synch up only those changes that are required to be migrated. Note: - We are aware of .xml extract and load, but a utility to perform the same would help and avoid any error related to security

How do I call a function that exist in a dashboard extender business rule for another dashboard extender business rule and how do I pass the all the required arguments?

Hi all, I need to assign a value in a field, dependeing on an other. I can do it in Delimited Files using  "api.Parser.DelimitedParsedValues()" but I don't know wich function can provide me the string of an other field.So, in conclusion: how can I do this in a Connector Complex expression? Thanks!  

All calculations must be executed as part of consolidation activities (Calculate, Translate, Consolidate). Question Credit: Jack Lacava Is this statement fact or fiction? Comment your best guess below! Answers will be revealed in one week. * This question is applicable to Platform 7.3.0 and may not be relevant to future releases

We need to provide users the ability to review the error log within the system tab. I don't see anything in the Application>>Security Roles.  Can thjis be granted and how?

I am looking for a Business rule function to write "data unit statistics" filtering on Year,month &Scenario. (OR) Cube view which can display DUS on the report.   PS- I know we can right click on calcstatus to get the DUS but require something which can create a report/write to a table for DUS>      

I was looking for a  way to bind a .net list object to a gridview instead of using DataAdapters. Any examples in this direction are appreciated.

How does one write a calculation where the result needs to land at an intersection that includes C#Elimination. Ideally, I'd want to have a function such as:     Public Sub Book(ByVal si As SessionInfo, ByVal api As FinanceRulesApi, ByVal sourceCell As dataBufferCell, ByVal target As String, ByVal factor As Decimal)     And then call it as     Book(si,api,sourceCell,"U4#SOMECALC:C#Elimination",-0.3563523553)    

I want to run a simple calculation setting one account equal to another.  Account A = Account B.  Account A, the account receiving the data in the calculation, is set to at the member level to YTD for No Data Zero View for NonAdjustments.  The account with the data is set to Periodic. The problem is when Account B has data for some months and then has a calculated 0 in later months.  The Account A with the YTD setting just replicates the last period's data in the months with 0 in Account B which causes the two accounts not to be equal.   I am using the following calculation. api.Data.Calculate("A#AccountA = A#AccountB" , True) How is this normally managed?

Hi    Is there a way to aplply user regional settings number format using Onestream client cube views, report... ? Or to apply the format user by user, or form by form? Thanks in adavnce for the help Marcello   ps I have noticed that the Excel addin shows the number with the specific user regional settings. So the question is related to the Onestream client only  

Hello  I made a mistake creating the  IC matching rules for several workflows related to the entities. Do you have any suggestion on how to bulk update the IC matching rules? Thanks in advance Marcello

Hello! I need to use the same entity hierarchy in my second cube.  In my second cube "marketing" I need to use the same entity hierarchy that I'm using on the first cube "Business".  I need it because both cubes will be load entity information for the same company (same code) ,in additional the "Corpo" cube, If I want to have the total "spain" using this configuration I do not have it. Let me show an example:   Thanks!!