The Planning Repository: HSP_MEMBER (Part 3 – UDA’s)

Not to sound like a broken record, but…a few disclaimers: This is the fun stuff…that voids your warranty.  Not that you have to tell Oracle that you poke around here, but if you do, they will blame anything and everything that’s wrong on you for being in there. The content here has been tested and…

Veeam Backup & Replication Free Edition Experience and Sample

This post is a bit outside of what I normally write about, but I had some trouble getting it working and all of the web searching didn’t really help.  So just in case someone else is having the same problems I was having, Google should provide this for you! First a quick introduction.  I have a…

The Planning Repository: HSP_MEMBER (Part 2 – HSP_ALIAS)

Not to sound like a broken record, but…a few disclaimers: This is the fun stuff…that voids your warranty.  Not that you have to tell Oracle that you poke around here, but if you do, they will blame anything and everything that’s wrong on you for being in there. The content here has been tested and…

Working with Strings in ASO

I needed a break from the Planning repository and recently had a colleague inquire about getting the name of a member as a string value in ASO.  This is a relatively simple process, but it occurred to me that when working with strings in Essbase, sometimes it helps to actually see what you are working with….

The Planning Repository: HSP_MEMBER (Part 1 – The Table)

Not to sound like a broken record, but…a few disclaimers: This is the fun stuff…that voids your warranty.  Not that you have to tell Oracle that you poke around here, but if you do, they will blame anything and everything that’s wrong on you for being in there. The content here has been tested and…

The Planning Repository: HSP_DIMENSION

Not to sound like a broken record, but…a few disclaimers: This is the fun stuff…that voids your warranty.  Not that you have to tell Oracle that you poke around here, but if you do, they will blame anything and everything that’s wrong on you for being in there. The content here has been tested and…

Kscope15 Presentations and Queries

I’m back in Texas after my quick in-and-out trip to present.  As promised, I’m posting both my presentations and more importantly, the queries that we reviewed during my Planning repository presentation.  Have a look at the files here: Cash Forecasting Kscope15 Planning Repository Kscope15 Planning Repository Kscope15 Queries for SQL Server I’d love to hear…

Brian @ Kscope15

It’s been a long time since my last post.  Moving and life seem to have slowed me down a bit, but I’m still here!  Right now I’m in Hollywood, Florida getting ready for my presentations at Kscope15.  I’m here for a quick trip in and out, so if you are at the conference, you can…

The Planning Repository: HSP_OBJECT and HSP_OBJECT_TYPE

Welcome to the first of a long series of posts describing the Planning Repository.  The point of this series is to describe many of the tables and their purpose inside of the relational repository that supports your Hyperion Planning applications.  Additionally, we’ll take a look at things like deleting a dimension or years from your application….