Posts filed under: Blog

The last thrilling post on this subject ended with a Data Management Export Sequence data source. We must now map its fields to the super-duper AVBS application’s equally super-duper Sample cube. This is just a configuration exercise with no code needed....
Continue Reading →
Moving cube data across scenarios (or entities or time or whatever) can be done via a Data Management Copy Data step or simple api.Data.Calculate statements or api.Data.ConvertDataBufferExtendedMembers. But what happens when there’s a need to perform a data movement and there’s a requirement for complex data transformation?...
Continue Reading →
There are times in every geek’s life (mine) where he must face the various vagaries and vicissitudes of life with unflinching good humor lest he lose what few precious marbles he has left. This is one of those times. OneStream’s role in performance management is serious. How could it be anything but unless financial consolidations and multiyear plans are the stuff of jokes? They are not. But life is not all a dire dirge for there are moments of rare joy that illuminate what otherwise might be a life of drab, dreary corporate existence. I live for them. I hope you...
Continue Reading →
Little – or big – things can have an impact. Sometimes they are a (gasp) Ferrari 308 in a ditch, sometimes they are data where data should never, ever, ever be. Double gasp....
Continue Reading →
Dynamic formulas are, by their very name, not stored. So what, you might say (I fear that many say that when I write but such is the way of the world), dynamic members are for reporting, stored calculations whether in a Business Rule or a formula, are for allocations and other calculations that are, well, stored. There are times, however, where the calculated results in a dynamic formula are needed in a stored calculation. Unfortunately, referring to a dynamic calculation within a Finance Business Rule (I believe this is true for the elventy million other kinds of rules as well, but...
Continue Reading →
Wouldn’t it (well, maybe?) be great if Lizard People (I invite you to read here if you’ve never heard of the term) controlled OneStream Business Rules? Briefly, an imaginary force – apparently from the Draco or maybe the Sirius or perhaps the Orion constellation* — controls the world, thus absolving humans from the responsibility of making it into the less-than-tidy state than it is today. So, kind of great for collective guilt, except for the all the evil bits that Lizard People bring to the table. Actually, no, not at all, but might it be equally great if there was...
Continue Reading →
Yes. Yes we are. Here it is, after a somewhat incredible delay (Could I have written this in one post? Maybe. I did learn a lot along the way so probably not. If the question is: should I have written this in one post, the answer is almost certainly affirmative. Such is the way of the world.) is the culmination of using SQL to drive Finance Business Rules. It looks a little complex but really isn’t. Trust me if you dare....
Continue Reading →
It is possible – barely so – that the maxim, “You can’t write outside of a Data Unit” isn’t quite as oppressive as the struggle Prisoner No. 6 faced in his quest for answers and freedom from his jailer’s shackles, but only by a hair’s breadth. Maybe. Probably....
Continue Reading →
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 →