OneStream Platform Forums

Originally posted by Rob Dessureault 7/31/2019 We have a process whereby when a workflow is certified, a data management job kicks off and copies specific Actual accounts into the Flash scenario.However, with the Manage Data Group set to Administrators, the users are encountering this error message.  . If I change it to Everyone, all works well

Originally posted by Kyle Nelson 9/5/2019 I have a business rule question regarding interaction with security groups. So the background is, we have hundreds of security groups that we thought we would need. We found another solution and want to clean up the security groups by deleting all of these extra groups. Has anyone ever used BRApi.Security functions before to pull a long list of identifiable groups and delete them? Or have you tried something else that achieves the same result?

Originally posted by Cosimo Palmisano 9/27/2019 In OS, we're seeing "label5" under the User Member column when running the Security User By Group Report / System Dashboard. Anyone know what this means?

Originally posted by Geoffroy des Dorides 3/10/2020 Hi, I have this weird situation where a user can input on an entry "form" but not launch a calculate or a force calculate. I guess the form is properly implemented as the administrator can launch a calculate or a force calculate from the same form. Which security role would prevent a user to calculate? (the user is able to input so I guess is has the proper access right on Entity and Scenario).

Originally posted by Karen Blackmon 4/1/2020 Do we share the Utility that allows us to clean security information from an extracted database with partners? I'm working with a partner and need for them to take a copy of client system and install on partner's system. Also, if we do share this kind of thing, how do we share it? We are prevented from emailing the exe, and they are prevented from receiving an exe. Is there a shared drive that we can leverage with partner collaborations? Thanks!!

Originally posted by Jon Golembiewski4/11/2018 I have a data source with spaces instead of commas as the thousands separator. I have tried the following to no avail:Put |Space| in the thousands separator field in the amount column of the data source Use the substitution settings to find/replace the space with either nothing or a comma Use a complex expression to manipulate the amountAnybody got any ideas to try to run into this before?

Originally posted by Michael Gialanella6/12/2018 Derivative Rule - Globals.Bypass - checking to see if anyone has done similar. Working on a ticket for a Partner and they are asking about performance implications and also if anyone else is using the Globals.Bypass function. Derivative rule is:

Originally posted by Craig Masters8/24/2018 I have a Data Source "issue"... I have 5 Tab Delimited files using the same Data Source. The Tab files only have the Entity designation on the first row in the 4th column number. No other dim is using the 4th column number. How do I tell OS to find the Entity code on the first line in the 4th column number?

Originally posted by Alain Fuhrer10/5/2018 We have Fixed File Data Source for a client and they would like to use the same source for different Entities.The problem is the following: The only place where we have the Entity name in row 8 (See print screen in red) and it’s just the description. How can we proceed to capture the Description name of row 8 in our Entity Data Source?

Originally posted by George Waddell11/1/2018 Hi, just want to confirm how the data copy works in Data Management...assuming all intersections from the Source are copied over to the Target? There is no capability to copy all data from source at a specific UD member to another UD member thru the Copy interface? Suppose a Business rule would be required instead?

Originally posted by Patrick Kiernan4/22/2019 How can I combine two source fields to generate one destination, such as UD2? I have a source number field, and where that doesn't exist the source description is to be used. For instance I have Supplier Number and that is what I am using as my UD2 Filed and then the description as an Attribute, but how can I use that Attribute to map if there is no supplier number? Example of data

Originally posted by Eric Osmanski1/8/2020 Does anyone know how I can get "9/19/2019 12:00 AM" to be "YYMMDD" in a Data Source?

Originally posted by Patrick Kiernan3/17/2020 People Planning Q. I set up an app with people planning. In Data Sources, GolfStream has the following: But in mine I do not get the dimensions, just (Unassigned). Am I missing something?

Originally posted by Craig Rowe 9/23/2019 Hi All, I am working with Relational Blending and pulling data from Stage into a dashboard. I am trying to format the value of my data into currency. When I use the query in SQL Server, I can see the correct format, with commas. When I put the same query into my business rule, see the format change the number of decimal places but I don't see the commas. Does anyone have any idea how to show commas in my dashboard grid view?

Originally posted by Chul Smith10/31/2018 Can you load two cubes (extended or not) from one central import? Gotta define data source by cube so that's why I'm asking…

Originally posted by Matt Ha 11/12/2019 So I know it's possible to write a BR to override FX rates like this: Does anyone know if it's possible to do this in a specific scenario member formula?

Originally posted by Rob Dessureault5/15/2019 In a confirmation rule, I need to get the Account dimension that is attached to the cube based on the WF that is in the POV

Originally posted by Laura Garcia 7/18/2018 Security question: is there a way to prevent someone from creating a new user account, but still allow them to provision a user to a group?

Originally posted by Eric Osmanski7/11/2018 Has anyone pulled Cube data into the Specialty Planning solutions?

Originally posted by Jon Golembiewski11/14/2019 I am trying to write a derivative rule with some logic in a complex expression. It seems the api.parser.DelimitedParsedValues function does not work within Derivative rules? I always get back 'Index Out of Range' error. Any idea how to get it working or what function I might be able to use to replace it? I am ultimately trying to pull in the amount for a particular column in my file.

Originally posted by Matt Grundey6/13/2018 Hello, question on data sources. I have a fixed width file format but I have a document number that the client wants to import as an attribute but it doesn't repeat on all rows. The document number appears on line 1 and then all rows under it use that same document number until a new document number is displayed. Has anyone come across this? Any suggestions on how I can handle it?

Originally posted by Eric Osmanski6/15/2018 Has anyone done mappings based on parents? For example, I have a source field in the GL 100-900 that maps * to * with UD1. I want to map UD2 based on the PARENT the source field is in in OneStream. So, if the Source Field is under Project X, then map to MemberA. If Source Field is under Project Y, then map to Member B.

Originally posted by Rob Dessureault 2/8/2019 What is the best way to stop a Flow member from translating? I have this and it works, but is there a better way?

Originally posted by Kathryn Watkins12/19/2018 Has anyone had an issue with Excel add-in coming back in after it was disabled or heard complaints about Excel taking a long time to open? Two users told me today that even if they disable the add-in and close/reopen Excel, the ribbon is activated again the next time they open Excel. The only way to make it go away was to go into the Trust Center to disable it. When it's active, they have found that it's taking "30 min" to load (not sure if it's really 30 min or if that was exaggeration). They think the long load time is because they have a bunch of other add-ins also running and it's in conflict with one / many. No one has administrator rights to their own computer and no one wants to uninstall it because they won't be able to get it back when they need it.

Originally posted by Sam Richards7/9/2019 I know in OS we have the DM clear that will clear a whole DU by origin or we can write a Clear rule with the is no data set to true but I was wondering if anybody has came up with anything else or if there is anything I am missing. A use case would be that you seed the current forecast with the prior forecast as a durable calc data so you need to clear say 20 accounts for a given period (Periodic Scenario) across a few DIDs so it would take some time in a form (plus you still have data in the import and forms origin). In Hyperion they would use the #missing s to clear out the data from what I am being told. I am thinking about going down the path of allowing a zero load to clear the data then running a rule overnight to clear out all the zeros to clean back up the database.