Application Build

Is there a maximum number of source id values that can be loaded to one workflow? Is there a maximum number of source id values that can be loaded for an entire application?

I have some accounts that are set up as non financial account type. Is there an easy way to see average data on QTD/YTD? They are behaving as balance accounts now.

Hi,Currently we are not using translation (currency conversion) and I was wondering if we can skip translation process while consolidating or can consolidate only specific accounts (if it allows) to make the process faster?We have a reporting application with huge set of data and need to refresh the data hourly followed by consolidation which is time consuming process. I am using data management out of the box step for consolidation with C#Aggregated. Can I use any other approach to make it faster?

Hello OneStream Community, A few days ago a colleague of mine wanted to know the meaning of the various PropertyId constants present in one of the Application Database Audit Tables.I was unable to find any OneStream specific documentation on this PropertyId code and its meaning, so I created a business rule to complete the puzzle and get what we needed for the metadata audit at a very granular level.  For any one else experiencing an issue similar like this here is a table of the Member property Id's and their meaning.Dimension | PropertyID | PropertyDescription Entity PropertyID | 100 | Currency Scenario PropertyID | 100 | ScenarioType Account PropertyID | 100 | AccountType Entity PropertyID | 150 | IsConsolidated Entity PropertyID | 200 | IsIC Scenario PropertyID | 200 | InputFrequency Account PropertyID | 200 | FormulaType Flow PropertyID | 200 | FormulaType UDx PropertyID | 200 | FormulaType Scenario PropertyID | 300 | DefaultView Account PropertyID | 300 | AllowInput Flo

Hello ONECommunity, We use NetSuite as our ERP system, and we have different FX rates by subsidiaries that apply to the transactions that occur within those subsidiaries. This means that for AverageRate we can have two EUR->USD FX rates within NetSuite. One FX rate for each of the two subsidiaries. When we pull those transactions for our income statement accounts into OneStream to load our YTD Actual scenario, we are seeing some FX variances because OneStream can only apply one EUR->USD FX rate that is stored within the cube's applied FX rate type. How have others solved this issue? Is there a way to apply multiple EUR->USD FX rates within OneStream we are not seeing or is this whole process uncommon and we need some changes to our ERP? Thanks!    

Does it make sense to get OneStream Metadata (eg Entity, Cost Center etc) be updated automatically from upstream source system such as SAP?I would have thought it would be far too risky but just want to check if anyone out there had ever come across such requirement and what approach you deploy so that metadata between source ERP and OneStream are in sync?Thanks in advance for sharing your experience.

Hello, we are about to start our work on next year budget and we already know that, following a recent restructuration, there will be a lot of pot swaps between departments (e.g. Licence costs used to sit in the department using the software but will now all sit under IT). Some of the them will be just moving a cost center and its history from one department to the next so that will be easy.  Our issue is when we do a "pot swap" that moves part of a cost center. In this case we will have a disconnect when we compare actual and forecast unless we restate actual (i.e. also move the cost in actual). My question is on how best to tag/flag the "pot swap" in the actual data so that in reporting we can do like of like comparison (i.e. with past data restated) but also keep the original data. I have 2 potentials solutions: Flag the restatement using an UD: do the restatement of past periods under a specific UD so that we have the ability to see past periods with or without pot swap adjus

In V7 I had a cubeview and V#Annotation was open for capture but in V9 it is not but V#Auditcomment is open for capture.  Any idea why ?

Hi All - I have a question on the SetDataCell Does the below work? I am trying to write 1 to an account.api.Data.SetDataCell("S#UltOwnShipConsolTracker:V#YTD:A#DirectOwnership:F#None:O#AdjInput:I#None:U1#None:U2#None:U3#None:U4#None:U5#None:U6#None:U7#None:U8#None", 1, False)My Origin is AdjInput & Consol is OwnerPreAdjThanksKrishna  

In People Planning, is there a way to sum all the values in either the PLP register or calc plan for all employees to get a total to calculate an allocation. My client would like to allocate a Pension Pool by the Employee’s Wage / Total Employee Wages. I am trying to find a way to calculate the Total Wages for all Employees using Allocation Methods as they run by RegisterID/CalcPer. Any ideas. 

Hi all,I'm experiencing an issue with the connector in one of the cubes. Although everything is set to "replace," the stage is not being cleared, and old data is being loaded together with the new data. As a result, I have to manually clear the stage to resolve it.The log, is says replace Data keys are 2025M10,2025M11,2025M12,2026M1, but if i check th estage after the import i have periods outiside this rangeThe log indicates 9,261 lines, exacly the same amount of rows that the query produces. But the import shows 248 pages. With 50 rows per page, that would be around 12,400 rows loaded, which is quite different from what the log reports. I'm not sure if I'm missing something here, but I haven’t noticed this happening in other data loads. I still need to replicate the issue in a different app. Has anyone seen this before? Thanks in advance!  

Hi All,Apologies if this question has been answered before. I tried search community but couldn't find.I noticed that data can be loaded via Forms into BeforeAdj member.Two questions:(1) Wouldn't it mean that if data is subsequently loaded into both Forms and Import, the previously loaded data into BeforeAdj  member would get replaced?  Isn't BeforeAdju supposed to be an Aggregated member?(2) Why would anyone want to load data into BeforeAdj member in the first place? What is the benefit of loading data into BeforeAdj member directly and not using Forms member if data is input via Forms?Thanks in advance for any insights.

Hi all,  How do other customers go about archiving applications?  We've been live since 2017 and every year after filing our SEC reporting, we copy the production application and rename it with the year that's being archived. This is helpful as in the past we've move products in segments as well as various other master data changes affecting reporting.  The issue is that now we're nearing our storage capacity as the size of our application has grown over the years as we add in more data and features (35GB for the 2018 archive while our current 2021 production app is at 155 GB) and clearly this problem will continue every year.  Any suggestions on a more efficient and cost-effective strategy?  Thanks!  

In the cube view, I have the customer selection on the dropdown list. When NoCustomer is selected, they want to see data that is loaded on Import. But they want to block the input for NoCustomer on Forms. is there an easy way to achieve this? Like if NoCustomer, read only?  

Hi all, How to download the table contents from the System --> database --> Tables or Views, when I tried to download, it is allowing to download the 50 rows only - I'm not sure where is a restriction like this and how would I avoid these issues? Thanks  

We have a consolidation button in the excel add-in that does not work. However, it works fine in Spreadsheet. This is in version 8.5. I've seen others have had this error but no commentary on a solution. Is this resolved in later versions or is there something to change in the excel add-in

I have a requirement to setup auditor (view only) access within the Task Manager solution.  Unlike Account Reconciliations, there isn't a dedicated Role within the Global Options settings of the solution.  My initial thought was to assign an Auditor role to the "Viewer Group", however this would require every single task to have the role assigned.  Does anyone know of a better solution, or do we actually have to assign the viewer group on all 2,000+ tasks? E.g., regarding assigning the auditor role to the viewer group.  

Dear Community Members,Found several great posts about creating account members from a rule.  I am trying to clone a scenario member (Forecast with Range defined). I have to admit that i am running into a knowledge gap when it comes to how to create some of the properties.I am reading the properties of my source scenario and naively thought i can just use SetStoredValue with the property of the source scenario.  Got stuck at InputFrequency.Any pointers to documentation, Golfstream, Community posts, or samples would be greatly appreciated.

Hello, We are creating a user activity dashboard to monitor system activity by user.  In the TaskActivity table, there is a column for Task Type (TaskActivity.TaskActivityType), but it stores a numerical value. Does anyone know where the corresponding text description is stored to pull into a SQL dashboard data adapter? Thank you, Eric

Hi everyone, I need to delete all records from the error log, it became very slow and heavy to use. I tried the buttons abovebut they do not clear everything from it. I found some discussions partially covering the topic, they suggest to manipulate the table 'ErrorLog' via query, but it seems like that table does not exist.Is there an easy way to do it? Thank you

Hi OneStream, Please let me know when shall Core Platform Architect certification exam become GA? In the exam portal i still see OCP - LA certification exam. Thank you,

I've created a form template and assigned it to a workflow profile. However, each time I access that workflow profile, I have to manually click on the form to open it. Is there a way to set a default form template so that it opens automatically when a user navigates to that specific workflow profile?

Hi, I've created an XFBR String Service file, and I would like to reference other (also XFBR String Service) files to break up the XFBR rule to manageable pieces. I keep running into compile issues. Any insights would be helpful. Thanks. Here are the screenshots of what I have: -Main XFBR String Service file (referenced in the Service Factory): -The secondary XFBR String Service file I'm calling & error: 

Dear Community Members,Due to my error in the initial definition of culture codes I ended up with two es-MX local language options in the dim library.I removed the es-MX culture code. One of the two options went away in the DimLibrary, but the second one persists.Then i removed all descriptions from the MemberDescription table where CultureCode = es-MX.  Still the DimLibrary shows Spanish AND even more surprising shows the Spanish descriptions.Which leads me to believe that those descriptions are cached somewhere?Any tips?  My ultimate goal is to have es-MX culture code and local descriptions. But only one Spanish in the DimLibrary.SystemConfig (this is a locally hosted client) only has en-US definedMemberDescription Table has only Englishbut DimLibrary still has Spanish descriptions but only where defined before. Other members that never had a local translation do not show Spanish (Mexico), see Scenario Actual below.Thanks in advance

Does anyone have any information/advice on testing applications in OneStream? Are there gotcha's or must test items?