Application Build

Hi Team,I’m working on a Hybrid Scenario setup where the goal is to copy data from a source scenario to a management (MGT) scenario. This allows the MGT team to work with the data independently, using their own workflow with high-level access. So far, the base data copy works well.However, I want to summarize entity data in the target scenario so that users only see Entity parent nodes, while maintaining visibility of all other 17 dimension members (Account, UD1-UD8, etc.).To achieve this, I tried creating a dummy parent member (Entity X) in a new Entity dimension that mimics the top-level parent from the legal entity hierarchy (Entity Y). My intention was to use this structure in the Pre-Aggregated Members field in the Hybrid Scenario configuration, effectively copying:Entity X = Entity YUnfortunately, this method worked successfully in Version 7.4, but does not appear to function as expected in Version 8.4.Maybe in version 9.0 +, we can successfully configure pre-aggregated entity ma

Hi all, I’ve encountered an issue in OneStream where inputting a value of 0 does not trigger any calculations, while entering 0.1 or any other non-zero value works as expected. From what I understand, this seems to be related to Zero Suppression, which may be preventing the system from storing or processing the zero value. However, I’d like to confirm if this is standard behavior, or if there’s a recommended best practice for handling zeros in data input and calculations (e.g., in cube views or business rules). Thanks!

Hello, In our planning solution I'm looking for a change to plan with less detail. We import transfer prices on material level, but now we want to plan on product level which includes several materials. During transformation the items with the same dimensionality are being combined and show a total value, but for these prices I would need a simple average. Example below: Imported values: After transformation the original UD4 is replace by the product member which is imported on Flow, because some UD4's remain unchanged: I would need to have the simple average (871.48 + 880.82)/2 = 876.15. Is there a simple setting for this, i can't find it, any other suggestion would help also. kind regards Ben

Hi all,while configuring a local OneStream instance, I know that I have to copy the "Encrypted Connection String For Server" from DataBase Configuration, putting it into the Application Server Configuration File, in the "Database Server Connections" item.I see that there's also a "Is Connection String Encrypted" flag, so I suppose I could set a clear connection string.Is not clear which would be the format of an unencrypted string (I took a look in the Installation Guide but I wasn't able to find what I was looking for...). Since this is a local development instance, there's no need to secure it... Could someone share this knowledge (or point me in the right direction) ? Thanks a lotFabioG

Hi all,I wrote a bunch of BRules and a couple of Assemblies (in different workspaces) that work together to perform calculations. So in the end I have a dependency chain like this:BR => Assembly => AssemblyThings works like a charm.Sometimes, after I made changes to an Assembly, I get a weird error saying that OneStream cannot find my assembly. While this is true when it cannot compile correctly (due to errors), it doesn't make sense to me when it compiles fine.Even if I compile my assemblies before I run the BRules, sometimes it happens.I'm trying to find out an explanation and I thought that:I run the BRule and OneStream think that Assembly1 - a dependence - is "old", so....OneStream start compiling Assembly1, and, while compiling it, OneStream think that Assembly2 - a dependence -  is "old", so....OneStream start compiling Assembly2Maybe these compilations are running async and in parallel... And, maybe, the last compilation takes too much time, taking the first one

Hi, I'm trying to build a dashboard that reviews all of the members in certain dimensions and ensures it has all of the members rolling up to the top properly.  To do this, I'm trying to find the table in the back end of OneStream to find the Aggregation Weight.  Does anyone know where that table is retained?   Thanks, Ben

Hi, I want to extract metadata in OneStream. While extracting the Accounts metadata, I want to extract both the 'Parent description' and 'Account type'. Through the grid view if you check the 'Display Parent Child Relationships' box, the account type goes away! I want to extract both of them together in a .csv file. This process also needs to be automated to be extracted on a scheduled basis. What would be the best solution to this problem?

Hi all, How should it be managed in case a base member containing data should change to become a parent member? Is there a preferred procedure to follow? Thank you for your help.Best regards,Carlos

Is there anyway we can develop a custom elimination process in the OS and attached with the cube. I see there is a "Custom" option in the cube properties but dont know what this function will do. FinanceFunctionType.ConsolidateElimination. I developed a custom rules which eliminate at first common parent dummy base member and it all ties when I sum but i wanted to get it roll up to Total Entity in USD.

           I am currently working on a Dynamic Cube with Data Binding Type (Share Data using Workspace Assembly). I was able to load Local currency data from BiBlend table and verify data using Cube View. Does Dynamic cube support Translation & Consolidation? I was unable to view translated data.  

Anyone willing to share the process by which you copy prior year accumulated retained earnings to the current year? Is this just handled via data management steps, or do you need a business rule? It does not seem that our implementation partner set this up for us... therefore this account currently is just being imported from our ERPs at the start of the year. This is an issue for our few entities with foreign currency, as the balance continues to translate at the current month closing rate, which we do not want.  Appreciate any insight! :-)

I am curious if there is a way to bypass characters in a transformation rule without using a complex expression.For example,000485 (Source) -> 458 (Target)394904 (Source) -> 904 (Target) 

Hello ! I've noticed that the workflow time stored in the application is having a weird format, for instance :  Workflow Time : 022008000 = 2022M5Workflow Start Time : 2022003000 = 2022M1Workflow End Time : 2022018000 = 2022M12 The only reason I see for this weird format is on the FX rate table (shown below), as it seems that 2022M1 is in the 4th column (hence 003 if we count column 0), 2022M5 in the 8th column and 2022M12 in the 18th column...   --> Is it just a coincidence, or am I assuming correctly the date format ?    

Hello !   As stated in the OneStream V8.0 the release note document : Cube View Shortcuts: Cube views have been enhanced for scaling, shortcuts, andhotkeys. See Shortcuts, Scaling, and HotKeys for more information. (PF8-57) But this paragraph is nowhere to be found... does someone know what are the new shortcuts, scaling and hotkeys that we could use in Cube View starting release 8.0 ?   Many thanks !

In v9.0, I have created all my cube views in a named Workspace (i.e. Not Default). I need to attach a single Cube View to a workflow task. In the past, I would create a Form Template Profile which I would then assign to a workflow Form Input task. In v9.0, when I select the Workflow task, I get the message (Unable to open Cube View "mycubeview"). Is this possible, or do I need to create them under the Default workspace or under Application->Presenatation->Cube Views? Thanks

Hi All, I am trying to use getSessionDataTable and SetSessionDataTable for loading data from a file placed in harvest folder and then using the table to store it in cube with direct approach. Can anyone provide more insight on these functions? How is it work and if there are any challenge of using these functions?

Hi Team,In guided reporting, I've attached cube views that contain parameters. Defined global options in guided reporting setting.When I discover parameters, it does not work. Can't see the parameter list.

Hi All, I am trying to explore and use Dynamic cube services for one of the requirements however not sure where to start on this. Could you please help me with some inputs around this if anyone has implemented this ? Thank you.   

Hi All,Any idea why the formula below won't work in CV?GetDataCell(T#|!Par_Time!| - T#|!Par_Time!|.Prior1)The first column contains the formula, and the second one contains this: T#|!Par_Time!|.Prior1. Regards, 

I am currently working on a SQL Table Editor component in Workspaces and would like to know if it is possible to dynamically change the background color of a cell after a user edits its content (e.g. highlight the updated cell in a different color). Is this functionality supported in the SQL Table Editor? If so, please share how to implement this behavior - either through a business rule, parameter or any available UI configuration. Any guidance or examples would be greatly appreciated.

Hi all,We have a situation where an Entity was created and incorrectly set up and contains data for period 2024M12 and 2025M3.We decided to create a new Entity and updated the transformation rules to ensure that the data loaded goes to the newly created member and not the old one.We have set the consolidation and ownership percentage of the old entity to 0 as added measure.We are now faced with the challenge of not deleting the member as it contains data.Kindly asking if it is advisable to set the In Use feature in this scenario and is there any impact that would cause.Thanks in advance.

Hi everyone, I'm having problems in writing data to one scenario through a cubeview. I have 2 scenarios available. If in the cubeview I use one of them, it allows me to manually input data. If I change the scenario, I cannot input data anymore. All the other dimensions are base members and they are unchanged.In addition, I cannot find the setting to allow data input on one specific scenario. I checked the settings of both scenarios and they are identical.Does anyone have any idea how to do it?Thanks!

Hello,we need to turn on the "Logon Activity Threshold" on our OneStream cloud instance. I have looked at the documentation and I believe the information there regarding this is for on-prem installations (it involves editing configuration files).I do see this on the cloud application:Is this where you set this on cloud?If so, is this enough to prevent the users from accessing the instance if they don't log on in the required interval? (I ask this because of this post: Automated process to disable users based on Inactivity Threshold / Remaining Allowed Inactivity | OneStream Community)Thanks in advance.

I need to be able to visualize a cube view in english and in spanish.The description of the account member is set in spanish, and if I put something in the 'English' line, because the user security only has the English option in culture, the cube view would come out in english. So i need to be able to add another option for culture in the user security. ¿How can I accomplish this?Thanks!  

Hi,Out of Curiosity, Is it possible to update Task Activity.