OneStream Platform Forums

Hi Community, For us the biggest lack of the Onestream product is the ability to point to two different applications in the Excel formulas. We are a customer since around 2016 (live 2018) and we have raised this on may occasions and in many forums.  It has been hurting us all along when testing developments on test vs. production - to see either that it did not impact the numbers or it had the impact we desired. We have been coping with comparing reports etc.   Now we are in the middle of the first rebuild after going live - and the amount of datapoints, levels that we need to check is massive - while we still wait for this most obvious long term deficit, in an otherwise very good product, to be fixed, we turn to you guys.   Can any one share their approaches to compare the data between applications in the development process in generally.   Kind regards Per

We would like the ability to auto consolidate 2 other constant ex rate scenarios once we have consolidated the main Actual scenario.  We want to retain the ability to consolidate the main Actual scenario in isolation also i.e. we don't want to consol all 3 scenarios every time. What would be the best way to do this?

I want to create a new application in our production environment, but I only want certain people to have access to the application.  How do I add security on the application?   Thanks, Winni

Happy upcoming Father's day everyone!! I just submitted the following enhancement request to OneStream developers. Does it make sense to you. Let me explain the context:Before I select a Workflow I have to select a Cube. Why is that required? Why can’t users organize Workflow under some other criteria of their choice - maybe a folder of Workflows based on Finance Dept's functions?From my experience, a workflow can be designed to update and pull data from multiple cubes; so why is it associated with only one “Cube”? That confuses me.Here is the enhancement request:Under OnePlace - give us a Workflow-Explorer that allows us to organize by creating sub-folders of Workflows.Create a default folder with Consolidation, LRP, Planning, Forecast as sub-folders.May Oracle stock crash -  like Bitcoin and the rest of stock market!!

Statement: You can do a direct cash flow in OneStream. Question Credit:  Peter Fugere Is this statement fact or fiction? Comment your best guess below! Answers will be revealed in one week.   * This question is applicable to Platform 7.3.0 and may not be relevant to future releases

Hello,How can we navigate to a specific workflow step from a button? That workflow step holds a form template group at present. Can we have navigation on button click to that form template group?Any leads would be appreciated.

Is there a way to change the Cube name after data has been loaded to it? thanks,Greg

We have a requirement of replacing Power BI dashboard's with OneStream .Which module would be better apt to configure from marketplace to full fill this requirement.

Hi,We want to import data from Oracle EBS Cloud (v.12.2.9) into OneStream Cloud. What would be the best way to do this? Should we use REST API? Thanks!

Team Is there a way where i can sum the columns/data using Variables.  Example: Instead of using GetDataCell(T#2021M1+T#2021M2):Name(Total) , can i use some kind of variable which calculates based on POV/Cube view GetDataCell(T#Quarters):Name(Total)  

Hi- Our scenario is set up as Range ( say 2022M1 to 2024M12). I have a database table which have Jan to dec as columns and I have Year also as a column. So we have different year 2022, 2023 as rows and the data is in Jan to dec. IS there any way to load all of this together. Right now i can use a matrix data and put in a complex expression which can either say workflow time & "M1" etc or i can read a literal parameter read the year to be loaded and i can concat and return in the data source. But is there a way in data source complex expression or a parser business rule that I can get the value of another column  in the data source , so i can reference what is the field value of the year and the concatenate that.

Is there any way to do a GetDataCell in a Cube View or Quick View where the members are dynamic/based on some criteria?  The formula below doesn't work, but hopefully give you an idea of what I wish did work.   GetDataCell(SUM(E#TopEntityMember.Base.Where(Text5 = 'Germany'))):Name(GermanySum)   I know you can add specific members together in the GetDataCell, but I'd like to be able to have one row that shows the sum, which is based on a property value that can be changed or be able to use it as a member filter and not have to display it in the grid.

Dear community, I have a Connector-type business rule that works like a charm.However, the SQL query which is the source of this connector is currently returning data for all entities, while this should be use for each entities that are affected to the given workflow profile. --> What is the best way to achieve a connector business rule that would be filtered by workflow profile entities ? Any exemples out there ? Best Regards,

Hello, has anyone seen an error like this before? I'm loading information from our PreProd to Prod environment and am getting the following error: "Summary: Error processing XML file type 'TransformationRules' XML: Line 379, position 22, element transformationRule. Rule already exists in this Rule Group, [Aggregate amount of institution's - 1- largest loan commitments]." From what I can tell there isn't anything particularly special about this line of code, it's just the line showing the given rule. And if it already exists, shouldn't it be overwritten through the load process? Any help in this matter would be greatly appreciated.

Hi, I am building cube views that should be accessible by several users based on the workflow they are affected to.   These cube views are the same, but each workflow has its own entity. Therefore, the same cube view will be available through several workflow, and the entity (or entity selection) should change based on entity affected to each workflow profile.   I'm probably missing something, but the problem is that there are no (known) parameters that would simply give me the list of entities attached to the current workflow profile... what would be the best way to achieve this ?   Regards,

Hi,   Is it possible to define restrictions for input in a cube view between two UDs dimensions ? In order to "guide" the user in their input, I would like to define a restriction between UD4 and UD5, so that only specific UD5 elements (in columns) could be editable based on the UD4 (in rows). I don't see any restrictions on UDs elements in the datamodel, so what would be the best way to achieve this ?   Regards,

Hi all, I have built out my cube view that shows headcount change for 2019 M12, I want to be able to capture the ‘Ending Balance Headcount’ for 2020 M1 as its ‘Begin Balance’.  Will a rule be the way to go in order to achieve this? Unsure on where to go from here.   Thank you.

Is there a way to export the Transformation Rules into an Excel file? 

Hi Team, Is there any option to delete user groups in RCM under the Account Reconciliation Market place solution using a template? We have close to 3000+ obsolete user groups which need to be deleted.

Hello All, Could someone guide on how a system business rule is triggered? As part of automating some daily tasks, we intend to automate addition, deletion of metadata members through a system business rule. Is the process similar to triggering extender rules? Any leads would be appreciated. Thanks  

Statement: I can run any business rule in the business rules section in order to test it. Question Credit:  Chris Bielinski   Is this statement fact or fiction? Comment your best guess below! Answers will be revealed in one week. * This question is applicable to Platform 7.3.0 and may not be relevant to future releases

Hi !I am trying to use a Drill Back option in my Data Connector.So far, I get the data from my connector in the staging area, which is great. Now I am trying to open an invoice document, which is stored noth in FileShare, or in Application Database for test purposes.However, even though I get the drill back types name, when trying to open the PDF file I only get the message "querying source system" and then nothing happen!Do you know of any reason why ? I thought it was a simple business rule ... Regards,

Hi All, I hope you are all well!  Just a quick intro - I'm new to OS and have just completed my first training course. I work for a large global company who use OS to consolidate and report. We have an instance where we reported or Jan22 figures, but now OS is showing slightly different figures at the consolidated level. I'm hoping to find a report where I can identify if a user has either imported or updated a form for that Jan period after we reporting.  So a report that shows my by user if they entered in Jan by the stamp date?   Thanking you in advance!

How do you prevent users from accidentally loading data via QV submission to a non-forecast scenario ie; Actuals. The CV is set up to point at the WF scenario so if a user doesn't change their WF POV it will submit the data to the incorrect scenario. 

Is there any documents for Entity Aggregation ?