Showing posts with label Pentaho BI Server. Show all posts
Showing posts with label Pentaho BI Server. Show all posts

Thursday, December 26, 2013

Changing Pentaho Enterprise Console or Admin Console password & Publishing password :

         If you forget or if you want to change admin user password for Enterprise Console(Administration Console in Community Edition)

1. ----->
Do the following simple steps to change the admin console password:

1. Navigate to BI Server (biserver-ce-3.8.0-stable)\administration-console\resource\config
2. Open Login Properties file.
3. Get the MD5 encrypted text for your password (visit http://md5-encryption.com/ to create md5 encrpted password)
4. You will get something similar to 'vsdsdrfew232fesfq23'
5. Now replace 'admin: OBF:23f223ef23resf5ess' with 'admin: MD5:vsdsdrfew232fesfq23'
6. Restart your server and try login using your new password.
If any issue clear your browser cache and try.

2. ---- To change the publishing password.

Also If you want to change pentaho components publishing password, edit the following file and replace your own password, it is in plain text format.

<Pentaho-Home>\server\biserver-ee\pentaho-solutions\system\publisher_config.xml

<publisher-config>
<publisher-password>newpassword</publisher-password>
</publisher-config>

Save the file and try publish the pentaho bi component with new password. It would work fine.



Bi-Passing Pentaho User Console (Removing Pentaho Security)

  We can remove the Pentaho Security features by simply updating two files. We achieve this, by creating single user and role and by giving system-level access to that user.

   Those two files are
 <PENTAHO-BI-SERVER-HOME>\pentaho-solutions\system\applicationContext-spring-security.xml
<PENTAHO-BI-SERVER-HOME>\pentaho-solutions\system\pentaho.xml


          Please follow the steps at following wiki link to update those files...
          http://wiki.pentaho.com/display/ServerDoc1x/Removing+Security

Thursday, November 24, 2011

Pentaho Business Intelligence

       Pentaho Business Intelligence Suite is a collection of software applications intended to create and deliver solutions for decision making.
        It's a BI Server plus standalone client tools and it is having a graphical interface for managing data sources, users and roles and other administrator functions ,called  Pentaho Enterprise Console("Pentaho Administration Console" for community edition ).
     BI Suite= BI Server + (standalone client tools and PEC).
     The BI Server is a Java Web application that contains specialized content creation engines plus a graphical user interface ( Pentaho User Console) for interacting with them.
BI Server Contains :
      BI Platform,
      Analysis Engine,
      Reporting Engine,
      Data Integration Engine,
      Pentaho User Console(PUC).

      This includes an application server (Tomcat) and three WARs: one for the Pentaho Web application, and two optional WARs that provide style sheets for BI Server content.

BI Platform:
       The BI Platform is a workflow engine that forms the operational core of the BI Server. It ties the other content engines(Reporting, Analysis, and Data Integration ) to the Pentaho User Console to provide content display, delivery, and scheduling functionality.

The Reporting (JFreeReport) engine provides functions which create and render data-driven reports and
charts in a variety of formats.

The Pentaho Analysis (Mondrian) provides the ability to create an analysis schema, and to form data sets from that schema by using an MDX query.

The Data Integration (Kettle) engine enables Data Integration jobs and transformations to run in conjunction with other BI Server processes.(Data Integration Server)

 Pentaho Client Tools:
 Pentaho Data Integration:
           It's an ETL tool, some times it is called as KETTLE, which enables us to access and prepare data sources for analysis, data mining, or reporting. This is generally where you will start if you want to prepare data for analysis.

 Schema Workbench:
           A graphical tool that helps us to create ROLAP schema for analysis.We need to create mondrian schema to create analyzer report or JPivot report to analyze the data.

Report Designer:
          An advanced report creation tool. If you want to build a complex data-driven  report, this is the right tool to use. Report Designer offers far more flexibility and functionality than the ad hoc reporting capabilities of the Pentaho User Console(PUC).

Design Studio:
          An Eclipse-based tool that enables you to hand-edit a report or analysis view xaction file. Generally, people use Design Studio to add modifications to an existing report that cannot be added with Report Designer.(To create pentaho solutions and action sequences)

Aggregate Designer:
         To improve mondrian schema efficiency and performance, we can create aggregate tables using aggregate designer tool.

Metadata Editor : 
          Pentaho Metadata Editor is a Graphical User interface for creating a user friendly metadata model on top of complex relational (initial release) data sources.  These business views allow administrators to suppress the complexities of underlying data sources, enrich the models through concepts (formatting, data suppression, descriptions, and more), and apply role based security .

Dashboards:
         Dashboards are used to monitor and analyze Key Performance
Indicators (KPIs). A set of tools incorporated to the BI Suite in the latest version
allows users to create interesting dashboards, including graphs, reports, analysis
views, and other Pentaho content, without much effort.

There are three ways to create dashboards:
1.Enterprise dashboard (In PUC)
2.Community Dashboard Framework
3.Pentaho Dashboard Editor.