I'm trying to lock local member formulas cells. Right now I can lock them but when I change the time dimension in the context and refresh the report they become "unprotected" again.
The formulas I'm using are as followed:
=IFERROR(EPMComparison("finance", EPMMemberID(E33), F33, G33), 0)
=IF(E29="Check Sum", "", IF(ABS(G29)>1, IFERROR(H29/ABS(G29), 0), 0))
I was reading online it has to do with the iferror function, but was wondering if I can get them to lock anyways with them through epmformatting sheet.