Application Build

Was able to "Process Cube" for October and November... in attempting to close a form for December (1Q) - now receiving this error message. The Entity Assignments and Calculation Definitions on the Workflow Profile are the same as they've ever been. Can somebody share other possibilities based on what this code is telling me? Cannot execute the Process Cube (Calculation) workflow task because the current workflow profile [Investment_Sub] has not been assigned a calculation definition.User Interface Stack Trace:   at System.ServiceModel.Channels.ServiceChannel.HandleReply(ProxyOperationRuntime operation, ProxyRpc& rpc)   at System.ServiceModel.Channels.ServiceChannel.Call(String action, Boolean oneway, ProxyOperationRuntime operation, Object[] ins, Object[] outs, TimeSpan timeout)   at System.ServiceModel.Channels.ServiceChannel.Call(String action, Boolean oneway, ProxyOperationRuntime operation, Object[] ins, Object[] outs)   at System.Se

Is it normal for certain security settings to be "reset" when a copy of production is made to dev? Every time we make a copy of production into the development environment certain security fields within Security Roles, Entity dimension, Scenario dimension, Workflow Profiles and Data Management Groups are set to "(Not Found)" instead of the correct security group.  Is this normal? If so, what's the easiest way to update this? Thanks!

Hi all,I'm quite new in OS and, as a Dev, I'm writing some code in Assemblies/Business Rules.I'm experiencing an issue with Intellisense.While I'm working from inside a class, I can see all the hints supplied by intellisense for all the Standard/OS Classes/Methods and for the Methods inside my current class.Unfortunately I cannot see hints for my other custom classes/methods that I wrote under the same assembly/namespace (they are correctly referenced, the assembly is compiled)I tried adding triple-slash comments, but - again - no luck.Just wondering if there's something I should do to make intellisense works or if I stumbled in a platform's limit.Thanks in Advance for Your precious helpFabioG 

Hi Team, Could someone assist me with transitioning WinSCP operations to SSH.Net? Also, is this a good move to make? Thanks, Anitha  

Hi, I have a SQL table with a decimal column that allows nulls, and I want to differentiate between an actual 0 and a null value.I seem unable to configure the SQL Table Editor in a way that enables me to save a null value. When I press Insert new row, it defaults to an amount of 0.0, instead of null. I am aware that I can do a dashboard extender and override the save operation but in this case the column value could be either 0 or null and I wouldn't know how to differentiate between the two. Any ideas? 

I am trying to build a cubeview to enter yearly rates in cubeview for forecast scenario. Is there any way I can do that? Idea is to enter rates during budget and use to for all forecast months instead of loading by periods.  

In the data record tables in the database, there are status code columns. For example. Here are what those status codes mean: Status (Stored Bits) Existence Type Storage Type 16 NoData StoredButNoActivity 17 IsRealData StoredButNoActivity 18 IsDerivedData StoredButNoActivity 32 NoData Input 33 IsRealData Input 34 IsDerivedData Input 37 IsDerivedData StoredButNoActivity 48 NoData Journals 49 IsRealData Journals 50 IsDerivedData Journals 64 NoData Calculation 65 IsRealData Calculation 66 IsDerivedData Calculation 80 NoData Translation 81 IsRealData Translation 82 IsDerivedData Translation 96 NoData Consolidation 97 IsRealData Consolidation 98 IsDerivedData Consolidation 113 IsRealData DataCellDetail 144 NoData DurableCalculation 145 IsRealData DurableCalculation 146 IsDerivedData DurableCalcula

Hello, I wonder if there are customers who use the OneStream solution "Security Audit Reports" in a non self hosted environment? We use OneStream as SaaS customers and we need to audit the security settings. Setup instructions for "Security Audit Reports" are written for self hosted environments. Furthermore I wonder, if anyone uses "Security Audit Reports" in production directly as it is very inconvenient to have this solution running in Dev (and for SaaS customers, there is no Dev environment available by standard). RegardsMartin

We're working on a solution, where users can enter and view a date through a Cube View using the Cell Type Date. The challenge is how OneStream handles date's (datetime) with time-zones. When a date is saved to the backend, it's converted to UTC time-zone. The Date component in the Cube View is also Time-Zone aware, so that it uses the local time of the user, to convert back from the backend UTC to local-time. The challenge with this is 2 fold: 1) Assuming we would calculate a rent for a given period. The user, based in CET time-zone, enters 2022-1-15 using the Gridview. This date is converted to 2022-1-14 as UTC (2022-1-14 23:00:00). Using a Custom Calculate method to calculate the rent from start (2022-1-15), now adds one day more, as the server time is UTC. (don't mention Daylight Saving Zone)  2) If another user, based in US Central, is reviewing data in the same Grid View (and same POV), this user will see a wrong date, as the server UTC date, is converted to this user's loca

Hi everybody, I would like to schedule an automatic extract of the security (users/groups/roles) I plan to use a data management job and a BR but I cannot find the syntax of the rule. The code "applicationZipFileHelper" does not extract the security, only the application. Thank you for your help  

Is there any way we can mask the People Planning register data in XFW_PLP_Register Table? The table contains sensitive information like employee salary which cna be accessed by an Non HR Admin.What is the possible solution for this.

Hi All, I am designing a new app with huge data set at detailed level and need time at weeks level. I would like to know if going by custom profile with time dimension at weeks level would be more efficient or having time dimension at month level and using WEEKS in User defined dimension would be better in the performance. It would be great if you can share some pros and cons for both the approaches and which one would be optimistic. Thanks in advance.   

Can someone please explain the difference between "Apply Access" and "Increase/Decrease Access" in Slice Security ?For Example : How it makes a difference when selecting "Apply Access - All Access" Vs "Increase Access -  All Access"Also please advise any training materials for Slice Security? 

Hi AllWe are using 8.4 at our new client and have been tasked with creating dashboards suitable to view on a tablet, web, windows app and phone.We have created different dashboards for each of the different devices, i.e. tablet, phone, windows app and web but have noted that for example, the phone dashboard formatting shows differently on each phone, depending on the phone screen size and it does not auto adjust to fit the screen size of every phone.Same as for tablet, web and windowsApp. Where can I get settings for auto fit on each device so that it shows uniformly on each device regardless of screen size? 

Hi, I am unable to access external database view via sql table editor in the Cloud OneStream (version 8.2). Can somebody suggest what can be the possible issues? It is working fine when accessing the current app database but only issue is when accessing external database. The external connections are fine as able to access the data via data adapters.

I have 1200+ orphaned members with no data in my U6 custom dimension that I'd like to delete.   The delete icon only allows 1 delete at a time.  Is there a way to perform a mass delete?

Hello,  I am wondering if there is any way to change a fiscal year once we have been using the application for quite sometime (several years.)  Our current Fiscal year is 2025 so all the data is being imported into year 2025, but we now need to adjust our fiscal year one year back.  So everything in 2025 becomes 2024.   Is this possible?  Or what options might I think about? Would I need to setup and start using a new scenario? Any ideas, comments, suggestions would be greatly appreciated.  Thank you  

I have captured journals at a base entity on C#OwnerPreAdj . When I process the cube, the values do not get consolidated. I have to run a Force Consolidate for the result to come through on reports.  I have set my cube settings for Calculate OwnerPreAdj if No data to True.  This is on Onestream Version 8.4.

Hi Team, The user is unable to download the OneStream Application in Edge and getting the below error.   The issue is coming from after Windows 11 upgrade, and it was working fine in Windows 10. We have tried with the solutions which all are the options available in below KB articles. KB0012987 : OneStream Troubleshooting Click Once KB0011265 : Error Starting Click Once Windows Application "Application cannot be started" Regards, Praveen

Hi,I want to build an input form for project planning where the projects are defined in UD1 dimension, but for the rest of the columns (Start date, End Date, and Contact type) there is no dimension defined. How can i build a input form via cube view if there is no dimension defined in Onestream. But Clinet wants to input the columns data (Start date, End Date and Contact type), in the system via form. 

Hi. Is there a way to automatically hide the Navigation Pane when the OS application is opened? I am using  Administrators Solutions Tools to set a homepage and I would like that homepage to open full screen (no Navigation Pane).  Thanks! Samuel

Hi , i am trying to copy between scenario through hybrid copy scenario feature but i observer that wherever only USD value present for non USD entities , data copy not happening. could anyone please suggest if anybody come across this scenario. 

Im having an issue with a transformation rulewhere i have on stage :- Account 5115-0001-UD2 2350-UD4 2020That combination of dimensions is being assigned by the following TRA#[5015~5115-0406~0408]:UD4#[2001~2010]:UD2#[2002~2203]I believe the problem is in the Account range, but do not understand why. can someone explain the reason why?

Hi there, we recently upgraded OS to 8.4 and the app itself its this dark grey color. Is there any way to change the color?

How to prevent the orange line in this spline chart from dropping to the X-axis when it encounters a null value. Basically it should end at the last valid data point without connecting to nulls.