A co-worker (aka the owner of my company) gave me a t-shirt for Christmas with the picture above. Being the analytical female that I am, I immediately thought, “Great. My boss thinks I’m crazy”. But, the more I analyzed the picture, I realized it was more of a testament to my job, which makes it … More The Doc is In
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