All posts by: Cameron Lackpour

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 →
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 →
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 →
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 →
Gentle Reader, if you – as your author most definitely was when he first researched it – are somewhat puzzled when reading about Unbalanced Math, this is post is for you as it is a powerful method that illustrates OneStream’s flexibility and utility, prevents pretty dramatic error messages, and stops you from writing stupendously ill thought out nonoptimal solutions to simple problems. Seriously, if you write Finance Business Rules, you need to understand this....
Continue Reading →
It has been your author’s observation that the glue that holds OneStream applications together – Workflow – is a victim of terminological inexactitude. No, not that odious euphemism, but instead the common usage of just one term – “Workflow Profile” – for the four (arguably five) different Workflow Profile types. When we OneStream practitioners use the same word to mean many things, we confuse ourselves, make mistakes, and generally make everyone who touches the application unhappy. Happy is more fun....
Continue Reading →