In this recipe, we will show you how to publish the Mondrian 4 schema on the Pentaho BI server, making the schema available to the Analysis Report for data exploration.
Make sure you have the Mondrian 4 schema that was created in the previous recipes defined well. MongoDB must be started with the databases created in the previous chapter.
Proceed with the following steps:
In your filesystem, go to
<Pentaho-installation-path>/server/biserver-ee/pentaho-solutions/system/
and open theolap4j.properties
file with your favorite text editor.Add the following lines. However, you need change the file path for the Mondrian schema; in my case, it is
/home/latino/git/pentaho-mongodb-cookbook/source code/chapter4/
. My MongoDB database has the username asroot
, and the password ispassword
. If your database doesn't require authentication, you can remove it from theconnectString
. Otherwise, if your database requires authentication, you can use...