Why I created a blog

Its been four years since I first created this blog. It has remained true to Essbase and related information over those years. Hopefully it has answered questions and given you insight over those years. I will continue to provide my observations and comments on the ever changing world of EPM. Don't be surprised if the scope of the blog changes and brings in other Hyperion topics.

Wednesday, January 4, 2017

FCCS- What you see is not always what you get

I was contacted by another consultant who is working on an FCCS implementation and he was having issues with not getting data for certain accounts. He looked at his mappings and they should have been loaded. From an Essbase perspective, I know that the typical reason data won't load is because it is trying to load to a dynamic calc member.
I mentioned this to him and he showed me the properties of one account:

 
So much for that, I thought. I then asked him to use the dimension editor in Smart View for FCCS and Long story short, Although the Data storage showed never share, the Data Storage for the cube (and the rates cube showed dynamic calc.


(Note, I hid the extra columns that are not applicable to this issue.)

It turns out h had created this and other members by copying a parent member and just changing the one data storage property. Why there are multiple that don't show up in the editor, I don't know.

As a side note, this consultant did later in the day meet with the Oracle "Seal" team that helps with issues. They have the ability to look at the created cube with EAS and lo and behold, the members were tagged as dynamic calc. He is fixing the entries using the dimension editor now and that should solve his problem.