All posts by: Eric Padua

Do you ever see code spill over into the right-hand void? For most, you may have encountered situations where lines of code are not visible because they are just too long to fit onto your screen, like below....
Continue Reading →
Now that we have some experience in creating a SQL statement to query OneStream’s backend data record tables, we can now focus on some other aspects that would also tie into an end-to-end SQL solution. Here we’ll cover loading a relational table with data (outside of the staging tables) and querying that data to tie into existing sales information already loaded to OneStream....
Continue Reading →
For those familiar with SQL – in particular, T-SQL, since OneStream’s back-end relies on a MSSQL database – you’ll be happy to hear that you can build an end-to-end SQL solution within OneStream. For context, I have automated many financial and operational processes using SQL and have ported them over into different platforms (Tableau, Power BI, etc.) – you can do the same within OneStream....
Continue Reading →
A Financial Analyst Perspective Working with OneStream software for the first time, coming from a financial analyst background, I was always a bit confused by how data was stored for the reports I was creating or the hacked-together solutions I was deploying through OneStream reporting objects. I was familiar with data warehousing concepts and had......
Continue Reading →