OneStream Platform Forums

Hi, we are using a Central Load workflow to load trial balances for ~1,500 entities(set up as unrelated entities).  There are then approx 50 "Central Import" workflows where Entities are assigned and specific work is performed.  The central load file pulls all entities and will be loaded at least daily.  There are going to be cases when one workflow is certified and another still needs to be reloaded.  The import, however, fails in order to avoid loading data to a certified Entity.  Looking for any help on settings or BR to bypass already certified entities. Thanks

Hello,Would anyone have any issues upgrading your current version to 7.1? It’s my 1st time upgrading our current 6.4 to 7.1 as I just came on-board as ABA couple weeks ago.Appreciate if you can share your experiences.Thanks.*this post has been migrated from Champions

Hello OS experts, I have BR that load P&L bucket and one BR that loads my BS bucket. I have DM sequence which load P&L,BS and then does consolidation etc. I want to know if I am able to write new BR or something I can do in DM to load P&L and BS data parallel to save time. Let me know your thoughts and example code if you are doing it at your job. ThanksSaurin *Migrated from onestream champions

SOURCE: ONESTREAM CHAMPIONS Does anyone have any tips or best practices to make it clearly visible when an admin is in Production vs. Development? Obviously next to user name we can see Production or Development, but other than that one word, they look identical. I’m thinking of something like a big red “DEV” logo at the top ribbon next to OneStream XF or something similar to that.

1. Why is the "Total number of stored records" same across all months for one year ?  

SOURCE: ONESTREAM CHAMPIONS Hi - I am trying to create a journal entry summary report, and am able to get most of my data from the application tables, however the created by, submitted by, etc user data are all just the unique identifiers, and not actual user names. Currently I only know of user names being kept in the Framework database location, in the SecUser table (or similar ones). Is there specific syntax I can use that will allow me to read from that database location (Framework) while running an SQL query capturing the rest of my data in the application database location through a dashboard data adapter? Or does this need to be done using a business rule to combine two tables? Thanks.

Hello Team, I have a user who, when opening certain specific reports, gets the following error:   but with another user that has the same permissions this error does not appear.To do a test, I created another native user, added exactly the same permissions as my user, and the error does not appear, it only appears to her (the problem user):: ---------------------------------------- Exception Type: XFException Thread Id: 175 Source code: DataWcf.cs, line 137, method GetDataCellsUsingMultipleThreadsWithTimeout   Stack Trace:    at OneStream.Shared.Wcf.DataWcf.GetDataCellsUsingMultipleThreadsWithTimeout(SessionInfo si, ExternalWcfClient externalWcfClient, WorkflowUnitClusterPk wfClusterPk, DataCellPk povDataCellPk, List`1 dataCellPkAndCalcScripts, CubeViewGrid cubeViewGridOrNull, String cubeViewName, Dictionary`2 customSubstVars, DataCellDisplayOptions options, Int32 numSecondsBeforeLoggingGetDataCells) in C:\agent\_work\298\s\Source\Shared\Wcf\OneStreamWcfService\Imp

Hi,I'm trying to use a csv file from a filepath as a data source for my connector. Have saw this function in OneStream parser rule, I tried but it gives me an object reference error without any clue on the error message.api.Parser.ProcessTextFile(si, filePath, api.ProcessInfo, Nothing)with the following syntax Has anyone tried it before or have encounter the same issue as I am?How can I make it work?Thanks in advance for your response.

I have a report book that loops through over 200 members and creates a new cube view for each member. The cube view is relatively short and I could definitely fit 2 on one page. Does anyone know of a way to get multiple cube views to fit on one page of a report book?

Can anyone offer any help when using View = Quarter Average on for example January 2023 data when the quarter being referenced is not yet complete?  It seems that the View will not work until the quarter is fully populated.

Hello,   I am requesting some assistance. I am trying to write a business rule that will exclude " 1 account and 1 department combination" from and entire rollup. For example, the all included account that is pulling is A#equip_rev and I am trying to exclude Account#410000, Dep#190 from the rule. Do anyone know how I should right that rule to exclude that account/department combination? Your help and feedback is greatly appreciated. 

If the workflow time is 2020M3 and you used the time function T#YearPrior1(|WFTime|)PeriodNext1(|WFTime|) it would return 2019M2. Question Credit: Andrea Tout 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

I would like to reference in a BRAPI rule text stored in the workflow profile's Substitution Text Settings.  Can someone provide an example how to do this please. 

Hi,I need the excel add-in. Can you please help me with the same.Thanks  

It is possible to create a multi-grid report where two grids are displayed in one page. Question Credit: Andrea Tout 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,I'am newly at OneStream and now I have a requirement from a client:- They want to import, automatically, files that will be data source of a Workflow Profile = import;1. Those files are on FTP (FTP connection), that means that I need to add on the current application server, a connector type = gateway, right?  Also, what I need to define on the connection string?2. Then I need to create a BR for the connector;3. Since the files are "delimited files", so on the Data Sources menu, I need to create a new Data source - delimited file and map the columns to the correspondent dimensions that exists in OneStream right? Also, on the connector setting option, I need to assign the delimited file to the BR connector that I created previously, right?   4. On the Workflow Profile, I will assign it to the new delimited file. Are these the correct steps?Thank you all.Ricardo  

Hi All,   I have created new Transformation Group and Profile ,If i try to link my group with Profile by using "Manage profile Members" icon i am not able to see the group name in the Available Groups list. Do we need to change any settings for that? Can anyone suggest?   Thanks, Dhanitha.

Hi, We will be setting up tables using Table Data Manager to store some filtered extract of application data. My question is how can on-prem folks access these tables? We were wondering whether we should just use on-prem database and use BR to extract the data to those on-prem tables. But this means we have to rely on IT to maintain those staging tables and access.  I prefer keeping the tables in Onestream app and give access to those tables. Thank you, Mikki

Is Application build for administrators course available in OS Navigator?  I have seen reference to the ABA course in  Administration Certification Exam Prep – December 2022 webinar, but can't locate the actual course link in Navigator. Thank you

Hi Community, I am trying to refresh on a quick view sent from another user.  The file will not refresh though it looks like it is connected to the quick views.  I am sure I am missing a setting or something but can't seem to figure it out.  Any suggestions would be great. Thank You

Hello All, Looking for a way to supress rows where there is 0s  (drilldown has some +/- which nets to zeor for the row in CV). I have supression on and it works for the rows where there is no data and 0 as expcted. now in my below screnshot you can see whole rows seems like it is 0s or No data. there are few columns where it will be net 0 but has data on detial level. is there a way to supress these rows somehow? Looking for a an example or some pointers to explore the solution.      

Hello,Currently a brand new customer and I was wondering if there's a way to automate currency loads from a SQL table to load into OneStream? We were told there was a way, but our consultants are telling us its not possible?Can it be done through a Workflow using Data Manager? Thanks,Will

Hi all, Happy New Year! Is there a way of extracting an active entity list from OneStream including Entity Name, Description, and Currency fields by using a data management job? Any ideas will be appreciated. Thank you!  

When trying to update another user's workflow view within OS, I'm seeing the following error. Replacing the current file with an updated xml works but I would like to avoid that if possible. Any ideas?    

Hi, I'm getting this error on different applications in my OS instance. Apologies if it is not relevant to this forum.