OneStream Platform Forums

We have a bunch of related party accounts that need to equal other locations within the company similar to intercompany. It would be nice if this can be added to the IC matching table that is on the workflow. I do not want these to eliminate but have visibility to the locations that these accounts are out of balance. Has anyone dealt with something similar to this and if so how do you go about it? 

Hi,Do we have a mechanism to map unmapped item to a holding member ( specific member of the dimension) during the data load to prevent data load failure.Thanks 

Hi All -    I am attempting to export Stage Data through a Data Management Job using a Business Rule. The customer is hoping to remove some columns from the export and filter down the data by selecting Entity & UD1 prior to the export. Has anyone ever modified the data export sequence extender rule?     Thanks, Emily 

What is the best approach to choose the first base member in a hierarchy, the following member filters not returning the expected results. E#|CVEntity|.Base.First nor E#|CVEntity|.First.Base or  E#|CVEntity|.Children.First.Base Entity keeps pulling in POV as in CV which is a parent the goal is to pick one single member from the hierarchy for Input  thanks  

I have a tabbed dashboard with three tabs displaying cube views. I would like to give my users the ability to print, export to excel or to pdf with a single action instead of doing so with each cube view individually. I would appreciate any approaches that community can suggest. Thank you.

Hello team, I am trying to get a dump of Yearly data in one table where I will use joins of member table with data records and want to expose this in BI viewer so that analysis can be nicely done on Month on Month, YOY basis etc. however pulling so much data seems problematic and I came to know about a term 'FDX' (Seems Fast data Extraction). Kindly help with some details on it, I could not find any content on this.   Thanks Satish

Hi AllIs there a way of clearing data that is already in the application using the XFF file format? I have tried NODATA, nodata and -. I have searched the documentation but I can't find any reference to it.Thanks

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?

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!!

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)  

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,   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 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.

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 ?

Is there any way to get a complete listing of active users and disabled users

SOURCE: ONESTREAM CHAMPIONS Hi All, Is there any way to see the active user count from the application? My requirement is to project the active users from the total users available in the application.

  In the BI Viewer component, is there a setting to change the minimum or maximum data points on both Y-Axis's in the top right quadrant of the print screen below?     

HI All, I am working on script to copy data from one channel member A to channel member B (New member),  requirement here is to copy Actual, planning and forecast data. After data copy Member A become parent and Member B become children for Member A. As per my knowledge this can be achieved with below mentioned options. 1.  Right custom script copy data from Member A to Member B.  2. Export data from Member A and load back into Member B. apart from this are there other ways like mentioned below. 1. What will happen if I rename Member A to Member B, is this work ? I mean data move from MemberA to Member B? 2. Post creating member B, is there any workaround to map Member A data to Member B by changing reference back end tables? Thanks, Sandeep

I have a extensibility rule which copies and adjusts rates in modeling scenarios. Works fine for Administrators, but I would need to get this working also certain divisional users, which do not have the Manage FX rate role (as per now). To my understanding the rule is not able to update the rates since the session info contains user which does not have Manage FX rate role. Is there any way of getting around this, other than granting the Divisional users the Manage FX rate role, which would give them access also to certain rates that they should not be able to adjust?