I have created an input schedule with a number of different dimensions in rows and columns. My columns are static - they are controlled by Excel cells in top of the report. My rows are dynamic, baselevel of all the dimension members have been chosen for all row dimensions.
When the user chooses an Entity via an EPMContextMember formula in the top left corner the rows are supposed to be updated based on the users choice. Unfortunately the dynamic selections in the rows becomes static after the first refresh. This means that data don't change even though the Entity changes.
Usually the combination of dynamic rows and static columns work well for me but for some reason this is not the case here.
Any advice on how to get it to work?