Application Build

I've got a Tree View component which is populated via code in an Assembly.It currently displays all the members for a selected dimension but will can only show those members that a user has access to.The tool that is a part of is indented for cross group use so it would be useful for users to see all the members available, not just the ones that they have access to. It's purely a visual aid, not for data viewing.Can anyone advise if this is possible and what I'd have to do to enable it?Thank you in advance :-)Craig

Hello, Other than the 200 character limit, are there any other restrictions imposed on the Default Description for a dimension member? Thank you for your time.

Hello All, I have a Cube View that I want to use as data source for a BI VIewer object. When I execute this CV, I can see data: When I use this (basic) CV as MD in data adapter, it is empty. I checked the set up steps in the doc and I can't see what I could have missed.   Would you have any ideas why the result table doesn't return values that I can see in my Cube View ? Thanks for your help Matthieu  

Hi,Is there a way to see what PoV was used when a Data Management step was executed?I am not able to find these details under Task Activity.Please suggest if there is a way.Tx.

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? 

Hi everyone, I have to do some systems diagnostics but I cannot run the dashboard because there is an error in the business rule "OSD_SolutionHelper". This business rule does not compile due to an error in line 4882Dim computer As New Microsoft.VisualBasic.Devices.Computer()Error: Type 'Microsoft.VisualBasic.Devices.Computer' is not defined. Anyone else encountering this issue? We are on version 8.4.0.16413. RegardsMartin  

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

Hi, I am testing V 7.2.3 in our Dev environment. Production is still on 6.5. The security and user groups, data sources, and workflow profiles are identical between the two. I am able to import and validate TB's in the workflow, but several others are not able to Validate in the Dev environment. Has anyone else experienced this?  The validation message is "No Security Access", but the workflow profile and security groups are idential to prod. Thanks!

I created a new dimension member as a child of our direct_department member in UD2.  I have updated all of the transformation rules and mirrored the member properties of its siblings.  I have loaded this month's data which includes the new department and none of that department's data is showing up following the load/transform process.  I'm not receiving any errors either.  Has anyone experienced this or has an idea of where I can look to resolve the issue?

Dear Community,Since I can create a weekly calendar using a customized Time Dim, what is the "Fiscal Year Month Type" such as Fixed week 4-5-4, 5-4-4 in the time profile used for? If it is used for fiscal year purposes, how can I see the impact? I tried to play around time profile, and it doesn't seem to impact anything. Please provide some ideas. Thank you

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  

I am attempting to update the "text" property (which varies by time) for my UD1 members using a business rule that pulls data from a custom table. The update process works as expected without any issues. However, when I remove a data value from the table, OneStream removes the value from the text property, but the corresponding period remains selected, showing blanks (see Screenshot 2). I am removing the data value using the "Else" condition as shown below (Screenshot 1).Can anyone provide insights on how to also remove the period from the selection when there is no value? TIAScreen Shot 1: Screen Shot 2: 

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.   

From a button-click, I want to open a different Dashboard, in a new tab (or just open it). It should be fairly straight forward, using: But if the Dashboard I want to open is not within the "Default" workspace, OR, if the Workspace that is hosting the Dashboard is not set to: the function does not work. Smart as I am, it should only be a matter of minutes to figure out the right combination, hereby prefixing the dashboard name with the Workspace name: XFPage=Dashboard:Current.MyDashboardName. But nope. Hopefully someone out there have the right combination to unlock level 2 to the Dashboarding Tour de Master. Cheers Frank

Hello, colleagues, Could you please advise am I right that when I create new user in OneStream application (and indicate his e-mail address in user profile), this user will not receive automatic e-mail notification about this?  

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? 

Hello, everyone, Could you please advise if we will need for Budget scenario more detailed accounts, than for Actual scenario, am I right that it will be solved by the following way:     Create second Accounts dimension     Apply this new Account dimension to Budget scenario on tab Cube Dimensions in Cube Could you please also advise how to copy existing Account dimension members into new Account dimension (as the first step before members updating for Budget scenario)?  

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?