If you would like to turn on basic authentication for mondrian cubes from excel you need to implement steps below.
\n
\nFirst step, what you need to do is to impelment Authentication Callback Class. This class is an extension of default AuthenticatingXmlaRequestCallback class, which is provided by mondrian.<\/p>\n
XMLA Connect sends from Excel user and password as http request authorization header. We need to read user name and password and auhtenticate against LDAP or database, where users are saved.<\/p>\n
\r\n\r\npublic class CustomAuthentication extends AuthenticatingXmlaRequestCallback {\r\n\r\npublic void preAction(HttpServletRequest request, Element[] requestSoapParts, Map<String, Object> context)\r\n throws Exception {\r\n String authHeader = request.getHeader("authorization");\r\n String encodedValue = authHeader.split(" ")[1];\r\n String decodedValue = Base64.base64Decode(encodedValue);\r\n int k = decodedValue.indexOf(":");\r\n if (k > 0) {\r\n String user = decodedValue.substring(0, k);\r\n String password = decodedValue.substring(k + 1, decodedValue.length());\r\n context.put(XmlaConstants.CONTEXT_XMLA_USERNAME, user);\r\n context.put(XmlaConstants.CONTEXT_XMLA_PASSWORD, password);\r\n }\r\n\r\n super.preAction(request, requestSoapParts, context);\r\n }\r\n\r\n \/**\r\n * Implementation of authentication\r\n *\/\r\n @Override\r\n public String authenticate(String username, String password, String sessionID) {\r\n try {\r\n customAuthMethod(username, password);\r\n } catch (Exception e) {\r\n throwAuthenticationException("User: " + username + e.getMessage());\r\n }\r\n \/\/role\r\n return "xmla";\r\n }\r\n}\r\n<\/pre>\nNext we need to register this class in web.xml like:<\/p>\n
\r\n<servlet>\r\n....\r\n <init-param>\r\n\t\t\t<param-name>Callbacks<\/param-name>\r\n\t\t\t<param-value>CustomAuthentication<\/param-value>\r\n\t\t<\/init-param>\r\n...\r\n<\/servlet>\r\n<\/pre>\nNext step you need to add role in your schema xml for mondrian, where you define cubes:<\/p>\n
\r\n<Schema>\r\n...\r\n<Cube>\r\n...\r\n<\/Cube>\r\n\r\n<Role name="xmla">\r\n <SchemaGrant access="all">\r\n <\/SchemaGrant>\r\n<\/Role>\r\n<\/Schema>\r\n<\/pre>\n