Posts filed under: Blog

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 →
Yes, Gentle Reader, in my last SQL and OneStream Finance Business Rule post, I pinky promised that the next post (this one) would finally cover really using SQL to drive said rules. I also said (actually I only did this in response to a comment from Cosimo Palmisano) that I’d cover LINQ and SQL....
Continue Reading →
In my last exciting (ahem) post on SQL in Finance Business Rules, I noted (ranted) that looping a zero-based Data Table using its one-based Count property made me sad. It does because it is – at best – inelegant. Why Microsoft, why did you take an object and give it two different item counts? The world may never know, but no matter, as my ex-coworker (Mustn’t there be a better way of wording that? If so, what is it? More literate readers, comment please.) Cosimo Palmisano pointed out, using VB.Net’s For Each…Next is a simpler way to loop a collection...
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 →
While the last thrilling (surely) post on SQL in OneStream focused on the core tables that store data, this post is about custom tables in Finance Business Rules. Custom tables can provide supplemental data that isn’t loaded into the Cube and isn’t in Stage or provide metadata (amongst other possibilities) for internal methods and functions. It’s relational, but not as we mostly know it....
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 →
Migrating A OneStream App Or Making GolfStream Yours, Part 2 Just Desserts As The Duke (probably not, but why spoil the meme?) once said: Unpossible! Remember the triumph of Yr. Obt. Svt. in the last exciting blog post on migrating a OneStream application via a SQL Server file import? The process worked: I copied the......
Continue Reading →
Migrating A OneStream App Or Making GolfStream Yours, Part 1 From the Ashes of Disaster Grow the Roses of Success Were Yr. Obt. Svt. smart, installing a local copy of the GolfStream sample application would have fast, easy (the first part of this post shows how to do it and it really is simple), and......
Continue Reading →
Fellow OneStream enthusiast, if your list of OneStream Connector Business Rules looks like the below then this blog is for you. If it doesn’t, I hope you still find it useful or at least mildly interesting!...
Continue Reading →
Have you ever wondered what you can do with the calculation type “No Calculate” when setting up a Calculation Definition in your Workflow Profile? It’s sort of odd: Calculation Definition implies a calculation; No Calculate does precisely the opposite. “No Calculate”, despite its name, is a powerful technique that can kick off a Data Management Sequence (to, um, calculate) from a Workflow Profile Process step, which opens the world to endless types of different scenarios (or at least calculations running after data loads)....
Continue Reading →
12