Yesterday, a colleague came to me and said he can run MDX query but can’t see the OLAP database itself on the server via Management Studio. I thought this is strange since he belongs to one of the role on the database. After awhile, another came with the idea which later on solved the issue. Apparently in the role, under “Data Sources” section, the “Read Definition” option is uncheck.
This option is important because without it, the role member can’t read full definition of OLAP database metadata.