I am getting the following error when I try to create a new formula using the above program.
MDX statement error: sql processing error: Error occurred while executing a MDX statement. The error message is: Cube xxxx.xxxx could not be found. Please check if the Cube is valid and exists.
Message no. UJO_READ_EXCEPTION018
The cube does exist and it has standard periodic, qtd and ytd formulas that are working fine. I have tried with sap_all so security should not be an issue.