Application Build

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? 

Dear User Community: My users have asked me what is the major difference between version 8.4 and soon to be released 8.5. Does anyone have an answer?  Has anyone been part of the beta groups (guessing they have them)? Love to hear because we need to know if we should wait for 8.5. Thanks,SP

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?

Hi All, I am trying to schedule a task in Task Scheduler to trigger a Data Management job every 180 minutes, starting at 02:50:00 AM and ending at 9:00 PM. However, when I attempt to set this up, I receive the following message. Is this a warning, or is it something that needs to be addressed in order to resolve the issue? Thank you for your assistance.  

Hello,We've recently upgraded to OFC 8.4 and after this upgrade, underlying RCM table names have been updated.For ex - XFW_RCM_ReconItems is now updated as ReconItem.Earlier on OFC 8.2 , we were able to query this table using a data adapter as well as in Business rule (DBConnInfoApp) . But now it's not working anymore. Same issue is occurring for all other RCM related tables. It does work for other tables not related to OFC/RCM (for ex - Member).Are there any restrictions in OneStream to query certain application tables? Is there any workaround for this?Regards,GauravTable showing in Application Database: Giving error while querying from data adapter:  

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  

how can i change the Is IC account parameter to true from 2025?  for historical data it should be false

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 Everyone, I'm designing a form where I display accounts in rows and columns header like Beg Bal, End Bal, Variance, etc. In the rows, I've configured a member filter as follows, which pulls all accounts under the PREPAY hierarchy, but excludes A#150123: A#PREPAY.Base.Remove(150123):Name(|MFAccount| - |MFAccountDesc|) This works perfectly, as it displays all the accounts under the PREPAY hierarchy except A#150123. However, when I try to display the total, I encounter an issue. I'm using the following member filter to display the total, but it doesn't work: A#PREPAY.Remove(150123):Name(Total: Prepaid RF, net)orA#PREPAY.Remove(A#150123):Name(Total: Prepaid RF, net) As a workaround, I have displayed the accounts under PREPAY individually and used the following formula to display the total: Is there a simpler or more efficient way to achieve this without the workaround? TIA

Hi All, I need to access parameter A which is present outside default workspace in my cube view. |!A!| this doesnot work as it only pulls the parameters within default workspace.  

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.