The final third
The last two posts on dimension building have focused on building dimensions either by hand or via the Metadata Builder. But what about deleting members?
You may not make mistakes but Yr. Obt. Svt. is, unfortunately, all too well familiar with, “Aw, bugger, I didn’t mean to add those 10,000 products/200 entities/14 departments/etc. I really didn’t mean to. Bugger. And now I need to get rid of some or all of them. Triple bugger.” Mayhaps you too have done so? Let’s hope so as how to do that is the point of this, the third and final (Hah! No, part four of three is now planned. Also, I can’t count.) part of this series on managing hierarchies.
Driving a manual
Stick shifts (or if you’re perverse and have an old car, a three on a tree, or if you’re really crazy, a Wilson preselector, or if you’re ultra cool, an epicyclic transmission which I finally learnt how to use) are a key component of driving enjoyment because of the control they provide. Wind out the engine way past a “reasonable” rpm just to hear the exhaust bark, hold it in gear round a corner …
With extensive apologies to Rabbie Burns aka the Bard of Ayrshire aka the Ploughman Poet (I hope that every lit prof I had in school is now beyond happy that I can remember a line from Andrea del Sarto – see, I did pay attention, sometimes) I had high hopes that I could cover the entire OneStream dimension build process from thinking about it to building and editing it manually to loading and editing it from external sources. Whew. And that’s not even counting applying said dimension to a cube. Double whew.
It’s simply too much to cover in a single blog post so I’ll
disappoint you bitterly relieve you and me considerably by reducing scope as splitting this into multiple posts is the only way to reasonably approach the subject.
Along the way I’ll try to explain as much of the architecture and philosophy behind OSXF’s (I’m too lazy to write out OneStream XF more than once per post) metadata management but there will be much that I shan’t and can’t cover yet. There’s a lot going on and a lot of functionality that isn’t …
Can it be Cameron? Can it?
Without beating about the bush, I practised in the Oracle Essbase/Planning/ODI world for more years than I really care to remember. 1994 doesn’t seem all that long ago but I’ve had conversations with many who look at me aghast when they figure out how long that’s been till date: for those of you who struggle with math, that’s 24 years and counting as of this writing. In technology terms, that’s several lifetimes. It was, and has been, time for me to move on and I have, to OneStream Software.
As I noted before, you may be hearing pins drop. But it’s true, I promise you that.
The ground rules
As I’ve done in the past, I’m going to write about technology, problems, and how the former fixes the latter. I’ve been told that I have a…unique style. Or something. I certainly have a voice (ooh, if only my Faulkner professors would read this), and definitely have a point of view. With that, here’s what this blog will and won’t be.
Knowledge sharing is the only point to this blog for you or for me. I’m new to OneStream XF …