I know that calculated members should be
I know that calculated members should be created using same hierarchy.
But what i don't get is when i tried to create a member as
WITH MEMBER [A].[Name1] AS [B].[Name2] + [B].[Name3]
gives infinite recursion error but
WITH MEMBER [A].[Name1] AS [B].[Name2]
is giving null result