Discuss the features and functionality of OneStream.
Recently active
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?
Hello,I am creating a cube view to be used in a Dashboard on an Workflow in order for a client to enter Quarterly Commentary.I am having two issues.1. When I set the time on the Explanation Workflow(Annotation) column to a Quarter, I receive green cells and cannot enter a comment. When I switch it to the quarter month, I have white cells and can enter a comment. I just want to confirm that this is normal functionality and that we cannot write comments to the quarter.2. The second issue is that I would like to write the comment to the BeforeAdj Origin member. I am able to do this when I have the Explanation (Annotation) column looking to one of my Forecast scenarios. When I switch the column to look at the Actual scenario (which is the scenario I want to be looking at) the cells turn green. In this case, they only turn white if I switch the Origin member to Import. I must have a setting somewhere that needs to be adjusted but I am having trouble locating it. Any insights would be greatl
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
Hi all We have a process where we update dimensions and their children on a regular basis. This means we need to delete the relationships between parents and children and then reload the new updated dimensions...etc. This takes a very long time, because we have a lot of dimensions. Has anyone out here used a script to make this process faster, we we to not have to reload everthing, but only update the changes made to the different hierarchies? Thank you for any suggestions Nouria
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!!
Hello,I need to create an automation that uploads flat files with data, that are on a sharefolder, to OneStream.When uploaded into OneStream, those files should be removed from that sharefolder.Does anyone have any suggestion?Thank you!Ricardo
Hello - we are running the intercompany matching report in the Application Reports dashboard and I see there is a setting which states "Suppress Matches" is set to false as a default. Please can anyone advise how to change this to true so we just see the mismatches? Thank you!
Happy Holidays/ Black Friday,Is there a way to lock downstream steps in a workflow, unless the first step in workflow is completed?As we all know, a workflow shows all the steps. For example, our first step is to load data. Our 2nd step will allow users to make manual entries. We don't want users to jump to 2nd step without passing / getting a green light on first step.It seems like a common request.Thanks in advance.
Hi all, We have a question about invalid intersections in reports and whether it is just a presentation issue or if we need to be worried about calculations or transformation rules as well. We have Cost Centers in our UD1 dimension and we have some Accounts that require specific UD1s. For instance, Account 62000 Gross Sales has a constraint of UD1 65000_F Sales. The event handler ensures this combination is maintained when loading data using transformation rules. For reporting purposes, we have now created an alternate UD1 structure that does not include all UD1s for some very specific reasons. Now, when running reports such as the P&L, the row for Gross Sales shows pink when the alternate UD1 structure is used because that alternate structure does not include UD1 65000_F. The displayed data is still the correct Account 62000 and UD1 65000_F combination, but the cells are pink since that UD1 of 65000_F isn't in the alternate UD1 structure. This alternate UD1 structure is only used
Hi, I have an Extensibiity rule which uses the "Imports WinSCP" command as is used to connect to an SFTP server. The rule works fine. I have just made a copy of the rule within the same application because I wanted to try and make some changes, with the only difference between the two being the name of the rule, but it seems the "Imports WinSCP" command is not recognized in the new extensibility rule, despite being recognized in the old one. Any idea of what I could might be doing wrong? Thank you
Already have an account? Login
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.