I would like to create an input template that has Entities and Reporting Currency down the rows and Time across the columns. The user of this input template will be sending data to multple entities at one time. The issue I am running into we have multiple reporting currencies set up in BPC, but we only want to send data to the entities home currencies. I have made the report work by pointing the EPMOLAP formula to a member property within the Entity dimension but I lose the dynamic selection. I have also tried using the EPMDimensionOverride formula but it doesn't seem to work either.
I appreciate your assistance.