Pull Dynamic Calc Member with DLR
Background: In FCCS, we currently have a level-0 member of the Account dimension (let's call it Account XYZ), which has a data storage type of "Dynamic Calc and Store". Account XYZ is calculated using a Member Formula. The calculated value is used in FCCS, and then a DLR is used to pull it out of FCCS and into other applications. Account XYZ is a ratio-type value, it does not roll up to parents.
Problem: When we run a Validate Metadata job, we get errors for Account XYZ. The errors are "Level 0 member must one of these Store, Never Share, Dynamic Calc or Shared" and "Level 0 Member with Formula must be Dynamic Calc". All business requirements are being met- the formula is correctly calculating the value of Account XYZ, and the correct value can be pulled out of FCCS using the DLR. The only issue is the Validate Metadata errors that we are seeing.