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
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
Given the nature of my business, I may be a little biased on this subject, but it’s for good reason. Let me tell you a little story. There was a time in my life where I spent 5 years at one client. I’m not complaining. It was a wonderful time in my life. I had … More Ain’t Nobody Got Time for That
If you have a child in your home, you know this song. You’ve heard it a gazillion+1 times, and you can do the handmotions! BUT, this blog has nothing to do with Frozen. It’s all about the excel add-in. Folks, it’s time to let…..it…..go. I’ve been doing this EPM world for 15 years. I KNOW … More Let it Go! Let it Go!
I get a TON of support calls on how to increase the rows in Smart View. I decided to just document it for one of our clients, and if course I HAVE to share it with you! 🙂 Right click on the server in EAS and select Edit->Properties Click on the Environment Tab: Use the … More Increase Rows in Smart View
A client called in stating his users in the ASO database had “READ” filters set to them, and yet, were able to write to the database. They had filters that were updated via MAXL that gave the users NONE access to certain districts and READ access to others. The NONE worked, but the READ did not, since … More ASO and Read/Write filters
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
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
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!