Application Build

Hi everyone, I have a question related to the upload of a new dimension hierarchy through an XML file. I currently have a file excel with the whole hierarchy for each dimension that I keep updating based on my client requests. I noticed that when I upload the file, the system merges the current version of the hierarchy with the previous one. This does not work for me because I would need the old hierarchy to be replaced by the new one.  A possible solution could be to manually delete the hierarchy members before the upload of the new hierarchy, but this would delete the data that has been loaded already. I would need a solution to just overwrite the current relationships between the members of the hierarchy without deleting them. Is there a way to do that? Thanks in advance!

Hi,   I have been trying (unsuccessfully) to configure my OneStream app against an azure AD. I have created an Azure AD and followed the steps that are in OS documentation. However when I try to login with my email which is configured against my Azure SSO I get a message "The external provider authentication provider settings in the XF Application Server Configuration file are invalid". My OS app is a local installation on my machine. Many thanks !

How do you add a data key to a OneStream application?

Hello, Here is an example of what we are trying. We have set the close dates and created a task in task manager which has a data management sequence as action and the start hour.  Does Task manager run the data management task as per the start hour given? The Auto execute option runs the task when the task is approved but we are trying to run the task at the scheduled time using task manager. Thanks in advance!  

Hi all We want to add more Cultures to the ENG-US one, but the option is greyed out. We are told to untick it, but this option does not exist or we are looking in the place? Please see attached.  Thank you.  Nouria

Good morning! Does anybody know how to fix these certification errors?  Thanks!

Hi all, Good Day ! I just want to launch my Input Value Parameter before my main dashboard gets launched. Can you please help me achieve this. Thank You  Noor   

When I try to upload my file it shows up like this, and this is the excel sheet I am trying to upload: any ideas? thank you!

Hi OneStream Community - I'm trying to create a rule to apply a specific % to the base entities of a specific region. To keep it simple, say we have 5 regions and I want to create an account that takes their PBBIT and multiplies it by a % that is different for each region, and I want it to calculate it at the base entity level, of that region. Is this possible? Many thanks in advance!

hello team  i am new OneStream consultant  kindly need to know how to setup Midstream Metadata Manager on OneStream application   Regards 

Hello, Wondering if anyone knows how to set up dimensions in order to have the following requirement :  - Users with access to the cube Consolidation need access only to data from the dimension B - Users with access to the cube Accounting need access only to data from the dimension C - Users with access to the cube FP&A need both access to data from the dimensions B & C (dimension A) The following setup does not yet meet our needs :  Thanks for your help. Harry

Hello, You can add a sample file in OS for a delimited or fixed data source type.I cannot find where to find it in OS database in base64. I had a look at the [ParserLayouts] table, but i can now find anything more...Do you know where it is hiding?Thanks

Hi OneStream Community, I hope you are all doing well. I am currently working on a project where I need to create a dropdown in a specific cell within the OneStream SQL Editor, and the values for this dropdown should be dynamically based on the value of another input parameter. Here's the situation: The SQL Editor only accepts delimited list parameters. I need to dynamically populate this delimited list parameter based on the value selected in another input parameter. For example, if the user selects a country from the first parameter, the second parameter (the dropdown) should display a list of cities from that selected country. I am struggling to find a way to dynamically feed a delimited list parameter based on the value of another input parameter. Could someone please guide me on how to achieve this? Any help, examples, or pointers to relevant documentation would be greatly appreciated. Thank you in advance for your assistance!

Hi, I have a member with 2 stored items formulas, one on default time and one on 2021. If I am in 2024, which one apply? Thank you  

We are on V8.2.2 Cloud and we need to change the Zip File Protection settings. ManageSystemConfiguration is enabled so we can change the settings. The Installation and Configuration guide mentions Zip File Protection settings after Task Activity. Task Activity is there but no Zip File Protection section: Anyone know where they are or do I have raise a ticket with support? Thanks    

Hi All, We are implementing some updates to the security model in our application, and we are coming across some unfamiliar territory, so we're looking for some input. We are using OneStream version 7.2.4. We are trying to prevent the user from seeing data for certain Flow members based on information in the Text1 value of the Flow member. Because we don't want the user to be able to see the data for certain Flow members, we decided to use Data Access Security on the cube, with the idea being that if the user tried to access data they weren't supposed to see, it would return "No Access" in the cell. However, the Text1 values for the Flow members vary based on the scenario and time, so we aren't able to use a simple member expansion formula in the Data Access Member Filter, like F#ParentMember.Base.Where(Text1 Contains 'Valid'). We couldn't get XFBRs to work either, leading us to use a Member List BR. We determined that we can get the Data Access security to call the Member List BR... b

Note: this post is a follow-up from a post I made previously: https://community.onestreamsoftware.com/t5/Application-Build/Member-List-Business-Rule-in-Data-Access-Security/m-p/34916#M3533 Hi all,  Previously, I had asked about some details surrounding the running of a MemberList BR in a Data Access security filter; specifically, when the data access security runs (answer: every 24 hours unless IIS is reset) and if there's a way to force a re-run (answer: resetting IIS). After doing more work on this, we noticed that it looks like the data access security is applied on an app server-by-app server basis, and the app server that's used to handle the security is based on the app server that handles the user's log in. For example, if my log in action is handled by AppServer1, the data access security that's applied to my session is determined by the security that's currently applied in AppServer1. So it's therefore possible that one user, their logging-in being handled by AppServ

Hi, we see some of our automated tasks cancelled by the system (e.g. task status = Cancelled by System in task activity) every now and again, and don't really understand why this occurs. Can someone shed some light on why this happens and how to prevent it?Thanks!Alex

Hi, I'm trying to copy consolidated data from one Cube to another one. All the process works perfectly except for the consolidated data. C#Elimination is not being imported. The part of the connector rule where I think there is a problem is here, but I don't know how to solve it: Dim dtDataRecord As DataTable = BRApi.Import.Data.FdxExecuteDataUnit(si, myCube, "E#E004", "C#Local:P#PL00", ScenarioTypeId.Actual, "S#ACT", "T#"& wfTime, "YTD", True, filterF, _ 4, False) Thanks,

Hello OneStream Expert: We are going to to convert one Hyperion Planning application to OneStream Application. In Hyperion application we have SmartList type of Datatype, for example we have an Account Member call  Display_Flag 1, Yes 2. No In web form, it will display Yes or No and data will be saved to Essbase as 1 or 2. But I cannot find the SmartList type of Datatype in OneStream for me to display Yes or No in the Cubeview. I wonder what kind of solution can be applied. Thank you in advance.

Good Day All: What table would contain the intercompany rule profile.  I see source value and target value in the grid.  But I want to see all mapping. On target value, I just see entity name, how do I confirm accounts (A#)? Thanks, Steve P.

Can we do input in multiple currency? How can we do input in other currency apart from Local? For example, if I have IN entity, I want to do input in SG, USD and other currency?

Hi, Is there any way to remove users from the groups by using Load/Extract option from the system tab. i know we can add new groups or users but i want to remove the existing user from existing groups via xml. Thank you in Advance, much appreciated for the help. Thanks Satish P 

I'm trying to better understand the best process for moving large Dev dimension changes from to Prod.  I've extracted my Dev and Prod Metadata and have it in the Dimension Comparision utility.  Now I know my differences which I have changes in Prod that aren't in my Dev and of course vice-versa.   I'm looking for feedback, do you edit the xml file or make some changes in Dimension portion of Onestream and re-extract.  The best practices process is what is stumping me or is the answer "it depends"

How can I edit my GLOBAL POV?