Application Build

Hi experts,Is there any audit report, to see Who did the Load ?When did it happen?What XML file is used to Load?I could not find it in the Navigation center?//Suresh

  Hi, we are looking for guidance and experience on automating the process of exporting  fx rate data from OneStream to Google Cloud Platform (GCP).What is the best approach to automate this data flow from OneStream to GCP?Are there recommended methods (API, connectors, data pipelines) for this integration?Any best practices or examples for handling FX data in this setup? Thank you!

HI,Modern browser could not be used.It has strange message "Skip to next section" for each dashboard component.

Hello everyone,I recently attempted to register for a OneStream certification exam and noticed that both the Lead Architect and Core Application Architect certifications are available. Could you please clarify which one is required for my consulting firm to qualify for a higher-level partnership with OneStream?Additionally, I would appreciate any insights into the main differences between these two certifications, as well as the passing score (percentage of correct answers) for each.Finally, if you have already taken one of these exams, I would be grateful if you could share your experience.Thank you in advance!

We are preparing to move the Transaction Matching (TM) module, an out-of-the-box marketplace solution, from the Development environment to the QAT environment.Could someone please guide me on the process for migrating the database tables, along with the match sets and matching rules created within the TM module?Specifically, is there a way to extract and load these artifacts directly, rather than recreating the entire solution from scratch in the new environment?

In my cube view- I have some cells which are greyed out. What does that mean? I am admin.    

Constraints in OneStream are filters applied to metadata dimensions such as Flow, Accounts, UD1, or specific cash flow lines to narrow the scope of calculations, data retrieval, or Cube View rendering. They’re powerful tools, but when applied too broadly or dynamically, can they degrade performance?Larger evaluation footprintA Flow or Account constraint forces OneStream to check every intersection in that dimension. In dense cubes, this can mean millions of evaluations.1. Dynamic filters are expensive.Static lists (e.g., A#1000, A#2000, Flow#Operating) resolve quickly. Dynamic logic FilterDim, Boolean conditions, or formula driven sets require runtime computation. Why?2. Stacked or nested constraints multiply the cost.Does layering constraints across Flows, Accounts, and UDs in OneStream force the system to resolve each filter before executing calculations?3. Reduced parallelism.When constraints slice across cash flow lines or UD dimensions, the engine can’t fully parallelize task

Hi Onestream experts,We need to install client software 9.1.0  for accessing Environment 1, which is running on version 9.1We could not use the client software 9.1.0 for accessing Environment 2, which is running on version 8.4Why is the client not backward compatible? This is a very normal situation for any customer, to have different environment in different version.How to solve this? ThanksSuresh

Hello Everyone,Does anyone know if it’s possible to use Wrap Text in comments within OneStream? This feature is available in Excel under cell formatting, but I can’t seem to find it in a OneStream Cube View. The member filter used for comments is V#Annotation.If anyone has a solution or workaround, please advise.Thank you!

Hi Community! Are there any solid performance issues / consideration of having ALL currencies from OneStream listed as Currency Filter of the Application Property, instead of selecting only the ones we need ? Regards,

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 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.

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?  

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.  

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