OneStream Community

poswald · 03-20-2024

Table Data Manager: OneStream has a Marketplace Solution, called Table Data Manager, which allows users to create custom tables where data can be loaded and updated. Table Data Manager has a feature to directly import data into tables; however, it on...

poswald · 01-31-2024

In today’s modern business world, a company’s organization structure can move more frequently than anticipated through changes like acquisitions, divestitures and mergers. The organization’s structure in OneStream is often represented in the Entity d...

poswald · 11-23-2021

Source: Migrated from Champions I asked this question from OneStream staff at the Splash conference and OneStream support. I thought perhaps someone in this group has run into the same issue: The standard that appears to be used for calculating FX do...

poswald · 11-29-2021

This worked. You showed me something different when working with variables. Usually I see variables used like this:api.data.calculate (script & "= 0* "& script, "A#IncStmnt.Base.Where(Text8 Startswith VarPercentofSales)",,"O#Forms")Instead the script...

poswald · 11-29-2021

I figured out how to do this correctly. Note: our fiscal year runs from Nov to Oct. November is the 1st month of our fiscal year. I calculated each of these in a separate flow member:YTD balance X Closing rate (FX_Activity_Closing_rate)- Periodic bal...

poswald · 11-22-2021

I've tried this, but I'm not following how to do this. I have several accounts where I only want to clear the Forms data. I need the forms data cleared for all the accounts where Text 8 Startswith VarPercentofSalesThis was the code I tried: Dim scrip...

OneStream Community

User Statistics

User Activity

How to upload Flat Files to a Custom Table

Historical Restatement, No Code Required!

Foreign currency translation error?

Re: Clear data on Origin Forms

Re: Foreign currency translation error?

Re: Clear data on Origin Forms