Dynamic Calc Members Are Not Auto Calculated in EPBCS
Background: We had a dynamic calc member with a member formula but it wasn't getting calculated automatically. We had to aggregate account dimension in order to calculate dynamic calc values. This defeats the purpose of having a dynamic calc member. After researching further we got to know the reason of the issue and a solution. Here is how we can replicate the issue: Create a TestMember, which Never Share or Store property: If you will go to the member formula tab, data storage for default cube and OEP_WFP cube will be Never Share: Let's edit this member and change the storage property to Dynamic Calc: You will notice data storage will change for the Default Cube: But if you look further data storage will still be never share for OEP_WFP cube. For us, initially when we loaded some members, we had the storage property as Never Share, which we later changed to Dynamic Calc, but internally it was still Never Share at th