Thursday 23 July 2015

Customization of Pentaho Login Page

Hey Guys,

In this post I am explaining How to customize the login page of the Pentaho BI server.

People are interested more to show their organization logo or used their branding color .So I would say everything is possible just know a little bit about css that help to over right the existing css .

Here I am  displaying the screen shot what I have done for one of the customer.




Feel free to contact the source code of that page or any other design that you want to customization .

Cheers  :)

Sumit Bansal
BI Developer
 



 

Friday 17 July 2015

Basic Of Pentaho Schema Workbench (PSW)

Hey Guys,

In this post i am explaining the basic knowledge of Pentaho Schema Workbench.

Introduction :

  • Allows you to create and test mondrian OLAP cube schemas visually
  • Mondrian engine processes MDX requests with ROLAP schemas
  • These schema files are XML metadata models that are created in a specific structure used by the Mondrian engine.
  • These XML models can be considered cube-like structures which utilize existing FACT and DIMENSION tables found in your RDBMS    

  Functionality: 
  • Schema editor integrated with the underlying data source for validation.
  • Test MDX queries against schema and database
  • Browse underlying databases structure 

Installation:

  • Unzip the Workbench into a directory.
  • Include your cube database’s JDBC driver in the drivers directory, so the Workbench can use it.
  • Start the Workbench by running “workbench.bat” (Windows) or “workbench.sh” (for Unix/Linux) where you installed. 
PSW Initial Screen:



If you have any question you can ask me or else you can drop me email :
 
Sumit Bansal
BI Developer