type=OLAP
name=pentaho
driver=mondrian.olap4j.MondrianOlap4jDriver
location=jdbc:mondrian:Jdbc=jdbc:sqlserver://SERVALL:1433;databaseName=pentaho;Catalog=res:warehouses/Bancos.xml;JdbcDrivers=com.microsoft.sqlserver.jdbc.SQLServerDriver; username=pentaho
password=xxx

# some security configuration for roles, first enable it
# security.enabled=true

# there are 3 different types of security:
# "one2one" (try and map spring user roles to mondrian roles),
# "mapping" (define the mapping of spring and mondrian roles manually)
# "passthrough" (will pass username + password of logged in user to connection, e.g. jdbc user + password)

# security.type=one2one

# security.type=mapping
# security.mapping=springRole=mondrianRole1;springRole2=mondrianRole2