#Error - Invalid Member Name when refreshing reports
I have an issue with one of my reports , i have a formula on 4 of my columns and when i run for different regions the report shows blanks members as shown below.#Error - Invalid Member Name: #Not an EPMOlapMember formula. Am i missing any sheet options or user options.
I tried all the possibilities of excel and nothing seems to be working. Please guide me in fixing this.
Thanks Dinesh and Vadim .
I had excel formula's which were causing the extra member appearing at the end of the report.
i have replaced them with Local members and it now looks good.