Trouble with the member formula in ASO
Hello everyone,
I have one question regarding the member formula in ASO.
We now have two instances: PROD and UAT.
When I wrote the member formula in the UAT instance with the full qualified name [Account].[60142050], I was able to validate the member formula and refresh the database successfully.
However, when I copied and pasted this formula to the PROD instance, it showed an error:
When I deleted the prefix [Account]. from the formula in PROD, I could validate the formula successfully:
The two applications are nearly identical.
I'm unsure why this error occurs.
Can someone help explain?