Application Build

We are working on security settings for RCM and noticed that we can view the Actual results/all workflow steps. Is there a way to hide the Actual workflow steps from RCM only users? Currently if a user has access to RCM under the Model scenario they can still click on the Actual scenario and see their steps/all data. If there is not a way to easily hide the actual workflow steps/data are the 2 main options to create a suffix for the Model scenario and have it be its own cube root or to do slice security? Or do we need to also have the Read group for actuals be a large group of users that don't include only RCM users? 

Dear all, I'd like to know how you deal with this kind of case, because > and < symbols are special for .XML files. I have a case where the description uses a ">" or "<" symbols but they are not properly recognized once they have been loaded, instead they are loaded as ">" or "<". Do you know how to define them so the load would work properly?   Thank you.

OneStream community,  I have been experiencing a weird bug lately... when scrolling too quickly in the FX Rates page, OneStream freezes up.  Sometimes, going to my computer Task Manager (Ctrl + Alt + Delete) and ending the program closes OneStream, while other times that does not even work and I have to restart my computer.   Are other experiences this issue/bug?  

Hi ,   I am trying to create a offline package but getting the below error.(snapshot attached) '',hexadecimal value 0x03 is an invalid character What is the easy solution?    

Hi, We're trying to allow all users (Everyone) write access to a specific dimension V#Annotation for all entities that they have read access to. Example: UserA is part of a security group that has only read access to Entity1. We would like them to be able to write only to V#Annotation on Entity1 as well. We've tried using Data Cell Access Security but I can't get it to increase / decrease security where we want it to. Is it possible to increase access to users who don't already have write access to a specific entity? If so, what would be the best way to accomplish this?

Hi . Does someone know what is the maximum number of members allowed for a product dimension?, we are assessing implementing the SKU reporting level and we manage around 13k products, I am wondering if the application can manage this volume of data. Regards.

We created a customized application support security group (Pseudo Admin role) which excludes the accesses of cube view form input, JE create/post and user security provisioning.  This is required by internal control as segregation of duties.  We updated maintenance group setting with this Pseudo admin group in all applicable components. e.g. Workflow profiles, Transformation rule, dimensions, confirmation rules, Forms/JE template, Dashboards etc.  The limitations we confront are that the following components are accessible only to the default administrators.  Can we enable the discrete security settings to those components instead of default to admin only?  Thanks!System Diagnostic DashboardCATExtensibility business rulesDatabase under System tab

Hi,  Does anybody know if it's possible to configure a Bound List parameter to show both the Name and the Description as the Display Member? It's valid for Member Lists but I get an error in Bound List parameters.   Lee  

Hi, how can I recover a member that I remove relationship without deleting? I can't create it because exists,  

Hi All, Does anyone have the Consolidation and Planning in separate applications? If so, what are the reasons for having them separate or what are the challenges.

Hi All, I have UD1 and UD3 dimensions, here UD3 made as Is Attribute= True and linked to UD1 as Related Dimension Type=UD1, and i want to load and see the data in UD1,Account and UD3 combination, can anyone suggest how to achieve this scenario   Thanks in Advance.

We have an intercompany dividend we are trying to eliminate using a plug account. One entity is recording the expense the other entity is recording the dividend as an equity account. We are utilizing a plug account to match and have it appear on an intercompany statement.  Is it possible for the system to eliminate the amount using a balance sheet vs p&l account? I am seeing the consolidation top level hierarchy reporting out of balance in the balance sheet.   

Hello, does anyone know if we need to worry about this warning?  There aren't much details provided in the error log. Summary: SQL Blocking detected: Database Name: , Request Session ID: 72, Blocking Session ID: 12, Blocked Object Name: , Resource Type: FILE: 9:0, Requesting Text: , Blocking Text: , Request Mode: , Blocking Time: 12/2/2023 8:05:57 AM. Thank you,      

Hello, We have a url stored in SQL server as a text. When we retrieve that we want it to appear as a hyperlink in SQl table editor. Could someone please help. Thank You, Indu

Hi, We have a non-euro company that initially reported on input_level. That local amount has been translated to EUR. Later on in the process the local amount was removed, however the converted EUR amount remains in the system. i have done a force calculate, force translate, (force) consolidate. Nothing seems to remove the EUR amount!? Question: how to remove the EUR amount without touching the Local amounts. thanks!  

Is there a way to export a list of the members in the Accounts dimension to Excel? I'm interested in downloading:NameDefault DescriptionParent

I am working with two different Onestream clients and having login issue with one client. See attached picture of the error. I have tried clearing cache, restarting the machine multiple times. Any help to resolve this issue is appreciated.

I am new to OneStream and I am trying to find out how you retire an entity.  I have gone into the entity and tried to change the vary by scenario type but cannot get to where you would change to False for "In Use".  Any suggestions

My requirement is i need to provide few users(Admins) only oneplace and system tab access, and few users(Admin) i need to provide only oneplace and application tab access.Please any one give me detail steps on this, Thank you.

Hi! I just ran a parcel and didn't receive an email.  This has been working fine.  The log shows it was successful.  Email's not in junk folder either.  Do you know what else I can check? 

Hello, I am looking to build an Input Parameter and additional rule (if necessary) in which the User will be prompted to input the beginning of an Entity (eg. A123) and the Cube View will return all Entities in the rows which start with A123. (eg. A123_400, A123_500, A123_600). Has anyone created something similar to this? Thank you!

Originally posted by Andrea Tout 12/10/2019 Does applying slice security have any performance impact? Or is it more just maintenance impact?

Hi All,   I need a same base member in different parent members in Account dimension and it should aggregate to their respective parents, do i need to create multiple base members or I can use the relation, can anyone suggest what is the best way to achieve it.   Thanks in Advance.

Hi, I have an Application table containing a number of attribute columns, a currency column (EUR,USD,TRY...) and an Amount column. The client wants a twin table that has all rows from the table 1, but with all values converted to euros. I already have a dashboard that shows table 1 with a button to refresh its content (pulling data from other Application tables). What is the best way of refresh table 2? I was thinking of creating an extensible rule to update table 2 on demand, but I have noticed I cannot use the api.fxrates in there... Thank you

Dear OneStreamers! Building and maintaining an OneStream application can be done in many ways, but I would like to hear how you have approached the challenge of managing the build process, hereby testing, deployment etc. I would like to hear input around:Build Process:What tools/methods make your build process a breeze?Any automation gems? Version Control:Git, SVN, or something else? How?Share your repo structuring magic and any branching/merging tips.Visual Studio / Visual Code?Testing/Quality Assurance:Testing? Automation, frameworksCI/CD Integration:How do you deploy between applications/environments?Challenges and Wins:What hurdles have you faced in this realm?Any game-changing solutions?Thanks for any input. Maybe we can gather some wise words