OneStream Platform Forums

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.

Originally posted by Jon Golembiewski3/11/2020 Got a data source puzzler - I have a file with two amount columns that I need each amount to go to different flow members. The first amount will always be Euros but the second amount needs to go to Flow Members stored in another column. Screenshot of the file is below. I can't figure out how to pull this off. First I tried a matrix data source. It correctly creates rows for both amount but always uses the Column header as the Flow. I tried to use a parser rule to point it to the other column but it just picks up the column header of the other column and not the row values. I am currently trying to use a derivative rule but keep hitting dead ends. I think I've maxed out my data integration expertise so wondering if anyone has done this before or has any ideas?

Originally posted by Jon Golembiewski 4/9/2019 For those that have used the Flow Processing rules for multi currency input... if you have calculated data that you write to the currency flow members, does the calculation sequence still pick it up to reverse translate it back to the entity currency? My thinking is that any member formulas or business rules would run after the flow processing rules and thus wouldn't get picked up. Basically, in the sequence below, anything running after step 3 would not get translated to the entity currency. I could not be lazy and test it but just wanted to see if anyone had run into this before.

Originally posted by Andrea Tout 9/23/2019 Has anyone ever extended on the scenario? We have on division that has it's own cube, and they have a lot of versioning and no one wants to deal with it in the other cubes. Display security doesn't exist for the scenario dimension. 

Originally posted by Andrea Tout 8/22/2019 Hey! When people typically handle entity security, do you nest the parents security group in its children security group? So when you have access to a higher level parent, you just add them to that parents group, instead of adding the user to like 100 groups. I have always wondered what is better! I feel like it depends on the size of the client

Originally posted by Pascal De Schryver 7/23/2018 I would like to prevent input for certain users on a specific UD4. Can I use Data Cell Access Security for this or am I supposed to avoid this?

Originally posted by Rich House 5/13/2020 Is it possible to grant the ManageTransformationRules and TransformationRulesPage security roles to a non admin user, then by using security groups on the Transformation Rules Profiles only grant them access to specific areas?I tried on a fake user and failed. The user was able to amend other profiles. Is this observation right?

Originally posted by Craig Masters12/3/2018 Data Source Parser Question: Client's data file contains 12 columns for the months no matter when it is run for the year. If it's January, it will have 12 columns showing Jan - Dec. Does anyone have a Parse Rule or another method of getting just the current month to import.   

Originally posted by Matt Grundey5/23/2019 Data source question, is there any way to import a file that doesn't have a repeating member name on each line. If I have a file similar to the one in the picture (but saved as a CSV or tab delimited), is there any way to load the file and have the system repeat the cost center numbers on the relevant line?