OneStream Platform Forums

Hello,I have a consolidated /parent workflow where we make top-sided entries via forms and journals on rare occasion. When I book an entry through a form it causes a variance on my OOB report, I assume in the children workflows because the entries are one sided (hitting different entities in different workflows). These two lines in the form net to zero, but how can I get my OOB check to ignore or recognize this is an "unbalanced" entry from a workflow perspective?

Hi, I am new to Onestream, and have finally gotten used to the cube views.   My question is if there is somewhere that I can be pointed to for any sample dashboards or tutorial on how to create dashboards.   I have used the guided reporting, which is good for cube views, but cannot figure out the dasboarding.

We have a lot of Cube Views and most of them have multiple validations some of which are quite complex.We also want to use Confirmation Rules to check that these Cube View validations have been cleared. The prospect of duplicating the Cube View validations in Confirmation Rules is not pleasant so we are looking for alternatives. We were thinking of adding a summary validation to every Cube View in the same place and then (somehow) saving that single value to an account with a split on UD6 for the Cube View. That would mean the Confirmation Rules are very simple to write. The question is can you save a value calculated on a Cube View to the Cube? The FormsEventHandler only references data that has been input (happy to be corrected on that). Suggestions on how to do this or a completely different approach are very welcome. Thanks

Hi, We are having a requirement to pull the cubeview in excel. While pulling the cubeview the coulmns are not autofit. Is there a way or workaround for doing the autofit while opening cubeview in excel?     Regards, Madesh K

Hi all, We are running "force calculate" step to perform force calculation of 80% base entities  . It runs for 4-6 hours. How to improve performance , any way run this in multi thread/parallel by entity (servers are hosted by OneStream) ? Thanks!

How to improve the business rule performance using Parallel.ForEach() in OneStream. 

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

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. 

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

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

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.      

Happy Feb! how do I sync Prod with DEV ? We made a lot of changes to DEV over the past 5 months - but didn't upload all of our changes.  We are thinking of exporting a complete extract of metadata, Cubeviews, dashboards, datamanagement, DataSources to xml from DEV - then delete all metadata, Cubeviews, dashboards, datamanagement, DataSources before uploading our extract to PROD?  Both servers are in different physical locations and therefore have different firewalls. Is there an article regarding life-cycle management for OneStream ?  

Hi. I've created a multiselect parameter where the selection will be passed into another parameter. Param1 -> Multiselect combo box(Eg: Level 2 members selected as "US" and "ASIA") Param2 -> Should be populated based on the Param1 selection(Eg: Level 4 members "NY","PH","AZ" of "US" and "IND,SG,TH" of "ASIA" should be listed) Below options dint work. U1#Root.List(|!Param1!|).Base U1#|!Param1!|.Base Need suggestions

Hi, how many periods can be loaded and validated at once?  I have the need to load 360 periods, but I seem to be getting timed out. thanks,Greg