Pentaho gives a set of tools to create a view of the data with OLAP ,to view a demo :
Mondrian is a very useful tool to get the view of data,lately after working on it for a month below are the steps to get mondrian started :
Where to get Pentaho :
You can get Pentaho BI Server Community Version from : Sourceforge
To Design the schema use Schema Workbench from : http://sourceforge.net/projects/mondrian/
Got Downloaded :
Extract the zip to folders ,get the Tomcat start & hit http://localhost:
Check your port in "TOMCATHOME/conf/server.xml" file,point your browser to that port ,change the port if it doesnt work for you ( change port = 8080 default to the port u need).
You must now be able to get the Pentaho screen in your browser.
Navigate to "biserver-ce\pentaho-solutions\system\simple-jndi\jdbc.properties" file
add entry to create a alias to connect to your database like for oracle
alias/type=javax.sql.DataSource
alias/driver=oracle.jdbc.driver.OracleDriver( driver name)
alias/url=jdbc:oracle:thin:@host:1521:sid (jdbc url to the database)
alias/user=dbusername
alias/password=dbpassword
To create a password to publish from Schema Workbench navigate to "biserver-ce\pentaho-solutions\system\publisher_config.xml" and create a password in the tag
Design your schema using Schema workbench and publish your schema to
http://localhost:
Use the user name from pentaho drop down box ( like joe pwd : password) and mention the alias u created & publish the schema.
Once the schema is published successfully,browse to http://localhost:
Go to New Analysis View and here u ll find your Schema name in the drop down ,click OK.
So now if u have your cube u can play around with it.Otherwise u might want to look at the logs @ "TOMCATHOME/logs/" and watch for any errors.
You can even place a log on pentaho application ,navigate to "biserver-ce\tomcat\webapps\pentaho\WEB-INF\classes\" look for log4j.xml and log4j.dtd ,if they are present login ,open log4j.xml and change
Set debug to true and value of param to a path on the directory on FS .
appender name="PENTAHOFILE" class="org.apache.log4j.DailyRollingFileAppender"
param name="File" value="C:/logs/pentaho.log"/>
param name="Append" value="false"/>
You can even enable logs for the MDX & SQL queries generated by mondrian to fetch the data for the dimension,to enable these logs just uncomment sections in log4j.xml which say
!-- Special Log File specifically for Mondrian /MDX/SQL Statements -->
Restart Apache after this change ,just check if the logs are created after Apache restarts.
So now you can debug your cube for which query is going wrong,even with the time each query takes.
No comments:
Post a Comment