Have you considered using the HsGetVal to pull your data in excel? Here’s my recent experience with it! The HsGetVal function has been a favorite of the HFM world for a LONG time.  Now it’s also available in the Planning/Essbase world.  The down side, there is a noticeable difference in retrieve time between Planning versus … More HsGetVal

The Power of CURRENT

Years ago I was on an engagement where I ended up building a TON of scorecards in Financial Reporting.  These reports were insane!  We had grids getting data from grids getting data from grids, you know….   Those kind of reports.  We used the GetCell function like mad!  But, they worked and they worked rather well.  … More The Power of CURRENT

Pesky Implied Share

I just had a support issue where the user kept inputting a value into a stored member, and after aggregating the web form the value disappears.  Again, STORED MEMBER.  So, we take a look at the member in the outline, and it falls under the parent, which his set to LABEL ONLY.  The sad little … More Pesky Implied Share


This year, I had the pleasure of attending KSCOPE15. If you came by the interRel booth, I was the one constantly saying “Pick a Duuuuuck”.  (Because that’s how we say it in Texas)  We launched our #PlayItForward initiative, which included a parody of one of my all time favorite commercials (yes, I was alive when … More #PlayItForward

Wonky rows in FR

I recently had a client that had expansion on the Year dimension for a column in the report, and every time we clicked to expand the report, the rows would shift.  The data no longer matched the rows. I got the skinny from Oracle that there have been some bugs in FR (this particular release was … More Wonky rows in FR

Hello world!

This is your very first post. Click the Edit link to modify or delete it, or start a new post. If you like, use this post to tell readers why you started this blog and what you plan to do with it. Happy blogging!