Essbase Data Load containing NULL Members

The most common way to get data into Essbase is to use a data load rule.  Load Rules are a simple, proven, and consistent object which make them ideal for almost any environment.   Recently, I discovered a quirk in load rules that I believed to be a bug, but later discovered was Essbase functionality.  I…

Read More

HsGetValue Issues in Smart View

I have recently come across some HsGetValue issues in Smart View where #Invalid and #Value were being returned in err from the HsGetValue function in spreadsheets being used for reporting. It took quite a bit of investigating to figure out what was going on in these cases, and below are some findings and best practices…

Read More